DBA Data[Home] [Help]

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 277: PO_DEBUG.debug_stmt (

273:
274: When OTHERS then
275:
276: IF (g_debug_stmt) THEN
277: PO_DEBUG.debug_stmt (
278: p_log_head => l_log_head,
279: p_token => l_progress,
280: p_message => 'Exception while retrieving drop ship row :' || p_po_line_location_id(i) );
281: END IF;

Line 287: PO_DEBUG.debug_stmt (

283: End;
284:
285:
286: IF (g_debug_stmt) THEN
287: PO_DEBUG.debug_stmt (
288: p_log_head => l_log_head,
289: p_token => l_progress,
290: p_message => 'Sales Order uom :' ||l_so_request_unit_of_measure||', Secondary UOM :'||l_so_request_secondary_uom);
291: END IF;

Line 307: PO_DEBUG.debug_stmt (

303: from po_lines_all
304: WHERE po_line_id = p_po_line_id(i);
305:
306: IF (g_debug_stmt) THEN
307: PO_DEBUG.debug_stmt (
308: p_log_head => l_log_head,
309: p_token => l_progress,
310: p_message => 'PO uom :' ||l_po_request_unit_of_measure||', Secondary UOM :'||l_po_request_secondary_uom);
311:

Line 324: PO_DEBUG.debug_stmt (

320: l_so_request_unit_of_measure,
321: l_po_request_unit_of_measure,
322: l_item_id),1);
323: IF (g_debug_stmt) THEN
324: PO_DEBUG.debug_stmt (
325: p_log_head => l_log_head,
326: p_token => l_progress,
327: p_message => 'PO UOM conversion rate :' ||to_char(l_uom_conversion_rate));
328: END IF;

Line 342: PO_DEBUG.debug_stmt (

338: l_so_request_secondary_uom,
339: l_po_request_secondary_uom,
340: l_item_id),1);
341: IF (g_debug_stmt) THEN
342: PO_DEBUG.debug_stmt (
343: p_log_head => l_log_head,
344: p_token => l_progress,
345: p_message => 'PO Secondary UOM conversion rate :' ||to_char(l_suom_conversion_rate));
346: END IF;

Line 412: PO_DEBUG.debug_stmt (

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

Line 530: PO_DEBUG.debug_stmt (

526:
527: -- Bug 3639067 START
528: ELSE -- l_drop_ship_flag is not Y
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 => 'Skip this req line - drop_ship_flag is not Y: '
534: || p_req_line_id(i) );

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

593: -- Set the org context back to the original operating unit.
594: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
595: WHEN OTHERS THEN
596: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
597: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
598: p_proc_name => l_api_name,
599: p_progress => l_progress );
600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 807: PO_DEBUG.debug_stmt (

803:
804: -- Bug 3639067 START
805: ELSE -- l_drop_ship_flag is not Y
806: IF (g_debug_stmt) THEN
807: PO_DEBUG.debug_stmt (
808: p_log_head => l_log_head,
809: p_token => l_progress,
810: p_message => 'Skip this PO shipment - drop_ship_flag is not Y: '
811: || p_po_line_location_id(i) );

Line 859: PO_DEBUG.debug_var (

855: FROM po_session_gt GT
856: WHERE key = l_session_gt_key;
857:
858: IF (g_debug_stmt) THEN
859: PO_DEBUG.debug_var (
860: p_log_head => l_log_head,
861: p_progress => l_progress,
862: p_name => 'l_req_header_id',
863: p_value => l_req_header_id

Line 866: PO_DEBUG.debug_var (

862: p_name => 'l_req_header_id',
863: p_value => l_req_header_id
864: );
865:
866: PO_DEBUG.debug_var (
867: p_log_head => l_log_head,
868: p_progress => l_progress,
869: p_name => 'l_req_line_id',
870: p_value => l_req_line_id

Line 874: PO_DEBUG.debug_stmt (

870: p_value => l_req_line_id
871: );
872:
873: IF (p_req_line_id.COUNT > l_req_line_id.COUNT) THEN
874: PO_DEBUG.debug_stmt (
875: p_log_head => l_log_head,
876: p_token => l_progress,
877: p_message => 'Skipped '||(p_req_line_id.COUNT - l_req_line_id.COUNT)
878: ||' req lines whose drop_ship_flag is not Y' );

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

919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: -- Set the org context back to the original operating unit.
921: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
922: WHEN OTHERS THEN
923: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
924: p_proc_name => l_api_name,
925: p_progress => l_progress );
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1020: END IF;
1021:
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1025: p_proc_name => l_proc_name,
1026: p_progress => l_progress );
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: END call_po_change_api;

Line 1095: PO_DEBUG.debug_begin

1091:
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: IF (g_fnd_debug = 'Y') THEN
1095: PO_DEBUG.debug_begin
1096: ( p_log_head => l_log_head
1097: );
1098: END IF;
1099:

Line 1120: PO_DEBUG.debug_stmt

1116: IF (p_entity_id_tbl IS NULL) THEN
1117: l_progress := '020';
1118:
1119: IF (g_fnd_debug = 'Y') THEN
1120: PO_DEBUG.debug_stmt
1121: ( p_log_head => l_log_head,
1122: p_token => l_progress,
1123: p_message => 'entity_id_tbl is empty. quitting'
1124: );

Line 1134: PO_DEBUG.debug_stmt

1130: IF (p_entity = 'PO_LINE_LOCATIONS') THEN
1131: l_progress := '030';
1132:
1133: IF (g_fnd_debug = 'Y') THEN
1134: PO_DEBUG.debug_stmt
1135: ( p_log_head => l_log_head,
1136: p_token => l_progress,
1137: p_message => 'p_entity_id_tbl.COUNT=' ||
1138: p_entity_id_tbl.COUNT

Line 1153: PO_DEBUG.debug_stmt

1149: SET drop_ship_flag = ''
1150: WHERE PLL.line_location_id = p_entity_id_tbl(i);
1151:
1152: IF (g_fnd_debug = 'Y') THEN
1153: PO_DEBUG.debug_stmt
1154: ( p_log_head => l_log_head,
1155: p_token => l_progress,
1156: p_message => '# of updated rows: ' || SQL%ROWCOUNT
1157: );

Line 1164: PO_DEBUG.debug_stmt

1160: ELSE
1161: l_progress := '050';
1162:
1163: IF (g_fnd_debug = 'Y') THEN
1164: PO_DEBUG.debug_stmt
1165: ( p_log_head => l_log_head,
1166: p_token => l_progress,
1167: p_message => 'Unknown entity: ' || p_entity
1168: );

Line 1191: PO_DEBUG.debug_end

1187:
1188: END IF;
1189:
1190: IF (g_fnd_debug = 'Y') THEN
1191: PO_DEBUG.debug_end
1192: ( p_log_head => l_log_head
1193: );
1194: END IF;
1195:

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

1195:
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1200: p_proc_name => l_api_name,
1201: p_progress => l_progress );
1202: FND_MSG_PUB.count_and_get
1203: ( p_encoded => 'F',

Line 1282: PO_DEBUG.debug_begin

1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281: IF (g_fnd_debug = 'Y') THEN
1282: PO_DEBUG.debug_begin
1283: ( p_log_head => l_log_head
1284: );
1285: END IF;
1286:

Line 1307: PO_DEBUG.debug_stmt

1303: IF (p_entity_id_tbl IS NULL) THEN
1304: l_progress := '020';
1305:
1306: IF (g_fnd_debug = 'Y') THEN
1307: PO_DEBUG.debug_stmt
1308: ( p_log_head => l_log_head,
1309: p_token => l_progress,
1310: p_message => 'entity_id_tbl is empty. quitting'
1311: );

Line 1324: PO_DEBUG.debug_stmt

1320: l_order_tbl(i) := i;
1321: END LOOP;
1322:
1323: IF (g_fnd_debug = 'Y') THEN
1324: PO_DEBUG.debug_stmt
1325: ( p_log_head => l_log_head,
1326: p_token => l_progress,
1327: p_message => 'l_order_tbl.count= ' || l_order_tbl.COUNT
1328: );

Line 1338: PO_DEBUG.debug_stmt

1334: INTO l_seq_id
1335: FROM DUAL;
1336:
1337: IF (g_fnd_debug = 'Y') THEN
1338: PO_DEBUG.debug_stmt
1339: ( p_log_head => l_log_head,
1340: p_token => l_progress,
1341: p_message => 'seq_id = ' || l_seq_id
1342: );

Line 1386: PO_DEBUG.debug_stmt

1382: AND PLL.po_header_id = PH.po_header_id (+)
1383: ORDER BY PSG.num2 asc;
1384:
1385: IF (g_fnd_debug = 'Y') THEN
1386: PO_DEBUG.debug_stmt
1387: ( p_log_head => l_log_head,
1388: p_token => l_progress,
1389: p_message => 'x_purge_allowed.COUNT = ' ||
1390: x_purge_allowed_tbl.COUNT

Line 1398: PO_DEBUG.debug_stmt

1394: ELSE
1395: l_progress := '060';
1396:
1397: IF (g_fnd_debug = 'Y') THEN
1398: PO_DEBUG.debug_stmt
1399: ( p_log_head => l_log_head,
1400: p_token => l_progress,
1401: p_message => 'Unknown entity: ' || p_entity
1402: );

Line 1426: PO_DEBUG.debug_end

1422:
1423: END IF;
1424:
1425: IF (g_fnd_debug = 'Y') THEN
1426: PO_DEBUG.debug_end
1427: ( p_log_head => l_log_head
1428: );
1429: END IF;
1430:

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

1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1436: p_proc_name => l_api_name,
1437: p_progress => l_progress );
1438: FND_MSG_PUB.count_and_get
1439: ( p_encoded => 'F',