eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_UDA_IMPORT_PKG dependencies on PO_LOG

Line 2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');

2204: p_transaction_id IN NUMBER)
2205: IS
2206:
2207: d_api_name VARCHAR2(50) := 'TRANSFER_UDA_DATA';
2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
2209: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;

Line 2278: IF (PO_LOG.d_stmt) THEN

2274:
2275: FOR i IN 1..l_uda_pk1_tbl.Count
2276: LOOP
2277:
2278: IF (PO_LOG.d_stmt) THEN
2279: PO_LOG.stmt(d_module, d_position, 'inside loop');
2280: END IF;
2281:
2282: --Call import function to import data into po_uda_interface table

Line 2279: PO_LOG.stmt(d_module, d_position, 'inside loop');

2275: FOR i IN 1..l_uda_pk1_tbl.Count
2276: LOOP
2277:
2278: IF (PO_LOG.d_stmt) THEN
2279: PO_LOG.stmt(d_module, d_position, 'inside loop');
2280: END IF;
2281:
2282: --Call import function to import data into po_uda_interface table
2283: IMPORT_UDA_ATTRS( p_attr_grp_type => l_attr_group_type_tbl(i), --ATTR_GROUP_TYPE

Line 2297: IF (PO_LOG.d_stmt) THEN

2293: p_commit_flag => 'N');
2294:
2295: d_position := 10;
2296:
2297: IF (PO_LOG.d_stmt) THEN
2298: PO_LOG.stmt(d_module, d_position,'x_return_status after IMPORT_UDA_ATTRS : '|| x_return_status);
2299: END IF;
2300:
2301: IF Nvl(x_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS

Line 2298: PO_LOG.stmt(d_module, d_position,'x_return_status after IMPORT_UDA_ATTRS : '|| x_return_status);

2294:
2295: d_position := 10;
2296:
2297: IF (PO_LOG.d_stmt) THEN
2298: PO_LOG.stmt(d_module, d_position,'x_return_status after IMPORT_UDA_ATTRS : '|| x_return_status);
2299: END IF;
2300:
2301: IF Nvl(x_return_status, FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS
2302: THEN

Line 2307: IF (PO_LOG.d_stmt) THEN

2303: l_invalid_line_count := l_invalid_line_count + 1;
2304: END IF;
2305: END LOOP;
2306:
2307: IF (PO_LOG.d_stmt) THEN
2308: PO_LOG.stmt(d_module, d_position, 'The value of l_invalid_line_count is ' ||
2309: l_invalid_line_count);
2310: END IF;
2311:

Line 2308: PO_LOG.stmt(d_module, d_position, 'The value of l_invalid_line_count is ' ||

2304: END IF;
2305: END LOOP;
2306:
2307: IF (PO_LOG.d_stmt) THEN
2308: PO_LOG.stmt(d_module, d_position, 'The value of l_invalid_line_count is ' ||
2309: l_invalid_line_count);
2310: END IF;
2311:
2312: --Return in case of error

Line 2325: IF (PO_LOG.d_exc) THEN

2321:
2322: --Check if all the mandatory attributes are provided
2323: IF validate_uda_req_attributes(p_transaction_id) = 'N' THEN
2324:
2325: IF (PO_LOG.d_exc) THEN
2326: PO_LOG.exc(d_module, d_position,' Validation for mandatory attributes failed ');
2327: END IF;
2328:
2329: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2326: PO_LOG.exc(d_module, d_position,' Validation for mandatory attributes failed ');

2322: --Check if all the mandatory attributes are provided
2323: IF validate_uda_req_attributes(p_transaction_id) = 'N' THEN
2324:
2325: IF (PO_LOG.d_exc) THEN
2326: PO_LOG.exc(d_module, d_position,' Validation for mandatory attributes failed ');
2327: END IF;
2328:
2329: x_return_status := FND_API.G_RET_STS_ERROR;
2330: x_msg_data := 'Mandatory UDA attributes are missing';

Line 2486: IF (PO_LOG.d_stmt) THEN

2482: END ;
2483:
2484: d_position := 40;
2485:
2486: IF (PO_LOG.d_stmt) THEN
2487: PO_LOG.stmt(d_module, d_position, 'The value of l_records_exist is ' ||
2488: l_records_exist);
2489: END IF;
2490:

Line 2487: PO_LOG.stmt(d_module, d_position, 'The value of l_records_exist is ' ||

2483:
2484: d_position := 40;
2485:
2486: IF (PO_LOG.d_stmt) THEN
2487: PO_LOG.stmt(d_module, d_position, 'The value of l_records_exist is ' ||
2488: l_records_exist);
2489: END IF;
2490:
2491: --Collect installed langages

Line 3313: IF (PO_LOG.d_stmt) THEN

3309: AND PO_LINE_ID = l_po_lines_tbl(i)
3310: AND draft_id = -1
3311: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE');
3312:
3313: IF (PO_LOG.d_stmt) THEN
3314: PO_LOG.stmt(d_module, d_position, 'Delta and old records inserted ');
3315: END IF;
3316: END IF;
3317: END LOOP;

Line 3314: PO_LOG.stmt(d_module, d_position, 'Delta and old records inserted ');

3310: AND draft_id = -1
3311: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_OLD_ARCHIVE');
3312:
3313: IF (PO_LOG.d_stmt) THEN
3314: PO_LOG.stmt(d_module, d_position, 'Delta and old records inserted ');
3315: END IF;
3316: END IF;
3317: END LOOP;
3318: END IF;

Line 3358: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');

3354: l_attr_grp_name_tbl po_tbl_varchar100;
3355: l_attr_group_typ_tbl po_tbl_varchar30;
3356: l_pk1_value_tbl po_tbl_number;
3357: d_api_name CONSTANT VARCHAR2(30) := 'validate_uda_req_attributes';
3358: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
3359: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
3360: d_position NUMBER;
3361:
3362: BEGIN

Line 3412: IF PO_LOG.d_stmt THEN

3408: AND pk1_value = l_pk1_value_tbl(i)
3409: ) ;
3410:
3411: d_position := 10;
3412: IF PO_LOG.d_stmt THEN
3413: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);
3414: PO_LOG.stmt(d_module,d_position,'l_pk1_value_tbl ',l_pk1_value_tbl(i));
3415: END IF;
3416:

Line 3413: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);

3409: ) ;
3410:
3411: d_position := 10;
3412: IF PO_LOG.d_stmt THEN
3413: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);
3414: PO_LOG.stmt(d_module,d_position,'l_pk1_value_tbl ',l_pk1_value_tbl(i));
3415: END IF;
3416:
3417: IF l_is_valid = 'N' THEN

Line 3414: PO_LOG.stmt(d_module,d_position,'l_pk1_value_tbl ',l_pk1_value_tbl(i));

3410:
3411: d_position := 10;
3412: IF PO_LOG.d_stmt THEN
3413: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);
3414: PO_LOG.stmt(d_module,d_position,'l_pk1_value_tbl ',l_pk1_value_tbl(i));
3415: END IF;
3416:
3417: IF l_is_valid = 'N' THEN
3418: RETURN l_is_valid;

Line 3430: IF PO_LOG.d_stmt THEN

3426: EXCEPTION
3427: WHEN No_Data_Found THEN
3428: NULL;
3429:
3430: IF PO_LOG.d_stmt THEN
3431: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);
3432: END IF;
3433:
3434: RETURN l_is_valid;

Line 3431: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);

3427: WHEN No_Data_Found THEN
3428: NULL;
3429:
3430: IF PO_LOG.d_stmt THEN
3431: PO_LOG.stmt(d_module,d_position,'l_is_valid ',l_is_valid);
3432: END IF;
3433:
3434: RETURN l_is_valid;
3435: END validate_uda_req_attributes;