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_OM_INTEGRATION_GRP dependencies on PO_DEBUG

Line 13: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

9:
10: -- Read the profile option that enables/disables the debug log
11: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
12:
13: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
14: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
15:
16: -- START Forward declarations for package private procedures:
17: PROCEDURE call_po_change_api (

Line 14: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

10: -- Read the profile option that enables/disables the debug log
11: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
12:
13: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
14: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
15:
16: -- START Forward declarations for package private procedures:
17: PROCEDURE call_po_change_api (
18: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

Line 282: PO_DEBUG.debug_stmt (

278:
279: When OTHERS then
280:
281: IF (g_debug_stmt) THEN
282: PO_DEBUG.debug_stmt (
283: p_log_head => l_log_head,
284: p_token => l_progress,
285: p_message => 'Exception while retrieving drop ship row :' || p_po_line_location_id(i) );
286: END IF;

Line 292: PO_DEBUG.debug_stmt (

288: End;
289:
290:
291: IF (g_debug_stmt) THEN
292: PO_DEBUG.debug_stmt (
293: p_log_head => l_log_head,
294: p_token => l_progress,
295: p_message => 'Sales Order uom :' ||l_so_request_unit_of_measure||', Secondary UOM :'||l_so_request_secondary_uom);
296: END IF;

Line 312: PO_DEBUG.debug_stmt (

308: from po_lines_all
309: WHERE po_line_id = p_po_line_id(i);
310:
311: IF (g_debug_stmt) THEN
312: PO_DEBUG.debug_stmt (
313: p_log_head => l_log_head,
314: p_token => l_progress,
315: p_message => 'PO uom :' ||l_po_request_unit_of_measure||', Secondary UOM :'||l_po_request_secondary_uom);
316:

Line 329: PO_DEBUG.debug_stmt (

325: l_so_request_unit_of_measure,
326: l_po_request_unit_of_measure,
327: l_item_id),1);
328: IF (g_debug_stmt) THEN
329: PO_DEBUG.debug_stmt (
330: p_log_head => l_log_head,
331: p_token => l_progress,
332: p_message => 'PO UOM conversion rate :' ||to_char(l_uom_conversion_rate));
333: END IF;

Line 347: PO_DEBUG.debug_stmt (

343: l_so_request_secondary_uom,
344: l_po_request_secondary_uom,
345: l_item_id),1);
346: IF (g_debug_stmt) THEN
347: PO_DEBUG.debug_stmt (
348: p_log_head => l_log_head,
349: p_token => l_progress,
350: p_message => 'PO Secondary UOM conversion rate :' ||to_char(l_suom_conversion_rate));
351: END IF;

Line 417: PO_DEBUG.debug_stmt (

413:
414: -- Bug 3639067 START
415: ELSE -- l_drop_ship_flag is not Y
416: IF (g_debug_stmt) THEN
417: PO_DEBUG.debug_stmt (
418: p_log_head => l_log_head,
419: p_token => l_progress,
420: p_message => 'Skip this PO shipment - drop_ship_flag is not Y: '
421: || p_po_line_location_id(i) );

Line 530: PO_DEBUG.debug_stmt (

526: and ol.ordered_quantity_uom2=suom.uom_code(+);
527: Exception
528: When OTHERS then
529: IF (g_debug_stmt) THEN
530: PO_DEBUG.debug_stmt (
531: p_log_head => l_log_head,
532: p_token => l_progress,
533: p_message => 'Exception while retrieving drop ship row :' || p_req_line_id(i));
534: END IF;

Line 538: PO_DEBUG.debug_stmt (

534: END IF;
535: End;
536:
537: IF (g_debug_stmt) THEN
538: PO_DEBUG.debug_stmt (
539: p_log_head => l_log_head,
540: p_token => l_progress,
541: p_message => 'Sales Order uom :' ||l_so_request_unit_of_measure||', Secondary UOM :'||l_so_request_secondary_uom);
542: END IF;

Line 556: PO_DEBUG.debug_stmt (

552: from po_requisition_lines_all
553: WHERE requisition_line_id = p_req_line_id(i);
554:
555: IF (g_debug_stmt) THEN
556: PO_DEBUG.debug_stmt (
557: p_log_head => l_log_head,
558: p_token => l_progress,
559: p_message => 'Req uom :' ||l_request_unit_of_measure||', Secondary UOM :'||
560: l_request_secondary_uom);

Line 574: PO_DEBUG.debug_stmt (

570: l_so_request_unit_of_measure,
571: l_request_unit_of_measure,
572: l_item_id),1);
573: IF (g_debug_stmt) THEN
574: PO_DEBUG.debug_stmt (
575: p_log_head => l_log_head,
576: p_token => l_progress,
577: p_message => ' Primary UOM conversion rate From Sales Order to req :' ||to_char(
578: l_uom_conversion_rate));

Line 593: PO_DEBUG.debug_stmt (

589: l_so_request_secondary_uom,
590: l_request_secondary_uom,
591: l_item_id),1);
592: IF (g_debug_stmt) THEN
593: PO_DEBUG.debug_stmt (
594: p_log_head => l_log_head,
595: p_token => l_progress,
596: p_message => 'Secondary UOM conversion rate From Sales Order to req :' ||
597: to_char(l_suom_conversion_rate));

Line 656: PO_DEBUG.debug_stmt (

652:
653: -- Bug 3639067 START
654: ELSE -- l_drop_ship_flag is not Y
655: IF (g_debug_stmt) THEN
656: PO_DEBUG.debug_stmt (
657: p_log_head => l_log_head,
658: p_token => l_progress,
659: p_message => 'Skip this req line - drop_ship_flag is not Y: '
660: || p_req_line_id(i) );

Line 723: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

719: -- Set the org context back to the original operating unit.
720: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
721: WHEN OTHERS THEN
722: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
723: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
724: p_proc_name => l_api_name,
725: p_progress => l_progress );
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 933: PO_DEBUG.debug_stmt (

929:
930: -- Bug 3639067 START
931: ELSE -- l_drop_ship_flag is not Y
932: IF (g_debug_stmt) THEN
933: PO_DEBUG.debug_stmt (
934: p_log_head => l_log_head,
935: p_token => l_progress,
936: p_message => 'Skip this PO shipment - drop_ship_flag is not Y: '
937: || p_po_line_location_id(i) );

Line 985: PO_DEBUG.debug_var (

981: FROM po_session_gt GT
982: WHERE key = l_session_gt_key;
983:
984: IF (g_debug_stmt) THEN
985: PO_DEBUG.debug_var (
986: p_log_head => l_log_head,
987: p_progress => l_progress,
988: p_name => 'l_req_header_id',
989: p_value => l_req_header_id

Line 992: PO_DEBUG.debug_var (

988: p_name => 'l_req_header_id',
989: p_value => l_req_header_id
990: );
991:
992: PO_DEBUG.debug_var (
993: p_log_head => l_log_head,
994: p_progress => l_progress,
995: p_name => 'l_req_line_id',
996: p_value => l_req_line_id

Line 1000: PO_DEBUG.debug_stmt (

996: p_value => l_req_line_id
997: );
998:
999: IF (p_req_line_id.COUNT > l_req_line_id.COUNT) THEN
1000: PO_DEBUG.debug_stmt (
1001: p_log_head => l_log_head,
1002: p_token => l_progress,
1003: p_message => 'Skipped '||(p_req_line_id.COUNT - l_req_line_id.COUNT)
1004: ||' req lines whose drop_ship_flag is not Y' );

Line 1049: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Set the org context back to the original operating unit.
1047: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1048: WHEN OTHERS THEN
1049: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1050: p_proc_name => l_api_name,
1051: p_progress => l_progress );
1052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1150: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN OTHERS THEN
1150: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1151: p_proc_name => l_proc_name,
1152: p_progress => l_progress );
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: END call_po_change_api;

Line 1221: PO_DEBUG.debug_begin

1217:
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219:
1220: IF (g_fnd_debug = 'Y') THEN
1221: PO_DEBUG.debug_begin
1222: ( p_log_head => l_log_head
1223: );
1224: END IF;
1225:

Line 1246: PO_DEBUG.debug_stmt

1242: IF (p_entity_id_tbl IS NULL) THEN
1243: l_progress := '020';
1244:
1245: IF (g_fnd_debug = 'Y') THEN
1246: PO_DEBUG.debug_stmt
1247: ( p_log_head => l_log_head,
1248: p_token => l_progress,
1249: p_message => 'entity_id_tbl is empty. quitting'
1250: );

Line 1260: PO_DEBUG.debug_stmt

1256: IF (p_entity = 'PO_LINE_LOCATIONS') THEN
1257: l_progress := '030';
1258:
1259: IF (g_fnd_debug = 'Y') THEN
1260: PO_DEBUG.debug_stmt
1261: ( p_log_head => l_log_head,
1262: p_token => l_progress,
1263: p_message => 'p_entity_id_tbl.COUNT=' ||
1264: p_entity_id_tbl.COUNT

Line 1279: PO_DEBUG.debug_stmt

1275: SET drop_ship_flag = ''
1276: WHERE PLL.line_location_id = p_entity_id_tbl(i);
1277:
1278: IF (g_fnd_debug = 'Y') THEN
1279: PO_DEBUG.debug_stmt
1280: ( p_log_head => l_log_head,
1281: p_token => l_progress,
1282: p_message => '# of updated rows: ' || SQL%ROWCOUNT
1283: );

Line 1290: PO_DEBUG.debug_stmt

1286: ELSE
1287: l_progress := '050';
1288:
1289: IF (g_fnd_debug = 'Y') THEN
1290: PO_DEBUG.debug_stmt
1291: ( p_log_head => l_log_head,
1292: p_token => l_progress,
1293: p_message => 'Unknown entity: ' || p_entity
1294: );

Line 1317: PO_DEBUG.debug_end

1313:
1314: END IF;
1315:
1316: IF (g_fnd_debug = 'Y') THEN
1317: PO_DEBUG.debug_end
1318: ( p_log_head => l_log_head
1319: );
1320: END IF;
1321:

Line 1325: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1326: p_proc_name => l_api_name,
1327: p_progress => l_progress );
1328: FND_MSG_PUB.count_and_get
1329: ( p_encoded => 'F',

Line 1408: PO_DEBUG.debug_begin

1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407: IF (g_fnd_debug = 'Y') THEN
1408: PO_DEBUG.debug_begin
1409: ( p_log_head => l_log_head
1410: );
1411: END IF;
1412:

Line 1433: PO_DEBUG.debug_stmt

1429: IF (p_entity_id_tbl IS NULL) THEN
1430: l_progress := '020';
1431:
1432: IF (g_fnd_debug = 'Y') THEN
1433: PO_DEBUG.debug_stmt
1434: ( p_log_head => l_log_head,
1435: p_token => l_progress,
1436: p_message => 'entity_id_tbl is empty. quitting'
1437: );

Line 1450: PO_DEBUG.debug_stmt

1446: l_order_tbl(i) := i;
1447: END LOOP;
1448:
1449: IF (g_fnd_debug = 'Y') THEN
1450: PO_DEBUG.debug_stmt
1451: ( p_log_head => l_log_head,
1452: p_token => l_progress,
1453: p_message => 'l_order_tbl.count= ' || l_order_tbl.COUNT
1454: );

Line 1464: PO_DEBUG.debug_stmt

1460: INTO l_seq_id
1461: FROM DUAL;
1462:
1463: IF (g_fnd_debug = 'Y') THEN
1464: PO_DEBUG.debug_stmt
1465: ( p_log_head => l_log_head,
1466: p_token => l_progress,
1467: p_message => 'seq_id = ' || l_seq_id
1468: );

Line 1512: PO_DEBUG.debug_stmt

1508: AND PLL.po_header_id = PH.po_header_id (+)
1509: ORDER BY PSG.num2 asc;
1510:
1511: IF (g_fnd_debug = 'Y') THEN
1512: PO_DEBUG.debug_stmt
1513: ( p_log_head => l_log_head,
1514: p_token => l_progress,
1515: p_message => 'x_purge_allowed.COUNT = ' ||
1516: x_purge_allowed_tbl.COUNT

Line 1524: PO_DEBUG.debug_stmt

1520: ELSE
1521: l_progress := '060';
1522:
1523: IF (g_fnd_debug = 'Y') THEN
1524: PO_DEBUG.debug_stmt
1525: ( p_log_head => l_log_head,
1526: p_token => l_progress,
1527: p_message => 'Unknown entity: ' || p_entity
1528: );

Line 1552: PO_DEBUG.debug_end

1548:
1549: END IF;
1550:
1551: IF (g_fnd_debug = 'Y') THEN
1552: PO_DEBUG.debug_end
1553: ( p_log_head => l_log_head
1554: );
1555: END IF;
1556:

Line 1561: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,

1557:
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1562: p_proc_name => l_api_name,
1563: p_progress => l_progress );
1564: FND_MSG_PUB.count_and_get
1565: ( p_encoded => 'F',