DBA Data[Home] [Help]

APPS.PO_AP_MERGE_GRP dependencies on PO_DEBUG

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_AP_MERGE_GRP';
5:
6: G_MODULE_PREFIX CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME|| '.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12: PO_INVALID_VENDOR_SITE_ID EXCEPTION;

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

5:
6: G_MODULE_PREFIX CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME|| '.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12: PO_INVALID_VENDOR_SITE_ID EXCEPTION;
13: PO_GA_REFERENCING_DOCS_EXIST EXCEPTION;

Line 158: PO_DEBUG.debug_begin

154: l_progress VARCHAR2(3);
155: BEGIN
156:
157: IF (g_debug_stmt) THEN
158: PO_DEBUG.debug_begin
159: ( p_log_head => l_module
160: );
161: END IF;
162:

Line 189: PO_DEBUG.debug_stmt

185: x_vendor_site_code => l_from_site_code
186: );
187:
188: IF (g_debug_stmt) THEN
189: PO_DEBUG.debug_stmt
190: ( p_log_head => l_module,
191: p_token => l_progress,
192: p_message => l_progress || ': vdrname = ' || l_from_vendor_name ||
193: ', sitecode = ' || l_from_site_code

Line 233: PO_DEBUG.debug_stmt

229: NULL;
230: END;
231:
232: IF (g_debug_stmt) THEN
233: PO_DEBUG.debug_stmt
234: ( p_log_head => l_module,
235: p_token => l_progress,
236: p_message => l_progress || ': passed check 1'
237: );

Line 271: PO_DEBUG.debug_stmt

267: NULL;
268: END;
269:
270: IF (g_debug_stmt) THEN
271: PO_DEBUG.debug_stmt
272: ( p_log_head => l_module,
273: p_token => l_progress,
274: p_message => l_progress || ': passed check 2'
275: );

Line 312: PO_DEBUG.debug_stmt

308: NULL;
309: END;
310:
311: IF (g_debug_stmt) THEN
312: PO_DEBUG.debug_stmt
313: ( p_log_head => l_module,
314: p_token => l_progress,
315: p_message => l_progress || ': passed check 3'
316: );

Line 349: PO_DEBUG.debug_stmt

345: NULL;
346: END;
347:
348: IF (g_debug_stmt) THEN
349: PO_DEBUG.debug_stmt
350: ( p_log_head => l_module,
351: p_token => l_progress,
352: p_message => l_progress || ': passed check 4'
353: );

Line 391: PO_DEBUG.debug_stmt

387: NULL;
388: END;
389:
390: IF (g_debug_stmt) THEN
391: PO_DEBUG.debug_stmt
392: ( p_log_head => l_module,
393: p_token => l_progress,
394: p_message => l_progress || ': passed check 5'
395: );

Line 428: PO_DEBUG.debug_stmt

424: NULL;
425: END;
426:
427: IF (g_debug_stmt) THEN
428: PO_DEBUG.debug_stmt
429: ( p_log_head => l_module,
430: p_token => l_progress,
431: p_message => l_progress || ': passed check 6'
432: );

Line 468: PO_DEBUG.debug_stmt

464: NULL;
465: END;
466:
467: IF (g_debug_stmt) THEN
468: PO_DEBUG.debug_stmt
469: ( p_log_head => l_module,
470: p_token => l_progress,
471: p_message => l_progress || ': passed check 7'
472: );

Line 507: PO_DEBUG.debug_stmt

503: NULL;
504: END;
505:
506: IF (g_debug_stmt) THEN
507: PO_DEBUG.debug_stmt
508: ( p_log_head => l_module,
509: p_token => l_progress,
510: p_message => l_progress || ': passed check 8'
511: );

Line 521: PO_DEBUG.debug_stmt

517:
518: l_progress := '100';
519:
520: IF (g_debug_stmt) THEN
521: PO_DEBUG.debug_stmt
522: ( p_log_head => l_module,
523: p_token => l_progress,
524: p_message => l_progress || ': checking consignments'
525: );

Line 554: PO_DEBUG.debug_end

550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: IF (g_debug_stmt) THEN
554: PO_DEBUG.debug_end
555: ( p_log_head => l_module
556: );
557: END IF;
558:

Line 569: PO_DEBUG.debug_stmt

565: x_result := FND_API.G_FALSE;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: IF (g_debug_stmt) THEN
569: PO_DEBUG.debug_stmt
570: ( p_log_head => l_module,
571: p_token => l_progress,
572: p_message => l_progress || ': violated rule 1'
573: );

Line 587: PO_DEBUG.debug_stmt

583: x_result := FND_API.G_FALSE;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585:
586: IF (g_debug_stmt) THEN
587: PO_DEBUG.debug_stmt
588: ( p_log_head => l_module,
589: p_token => l_progress,
590: p_message => l_progress || ': violated rule 2'
591: );

Line 605: PO_DEBUG.debug_stmt

601: x_result := FND_API.G_FALSE;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603:
604: IF (g_debug_stmt) THEN
605: PO_DEBUG.debug_stmt
606: ( p_log_head => l_module,
607: p_token => l_progress,
608: p_message => l_progress || ': violated rule 3'
609: );

Line 623: PO_DEBUG.debug_stmt

619: x_result := FND_API.G_FALSE;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621:
622: IF (g_debug_stmt) THEN
623: PO_DEBUG.debug_stmt
624: ( p_log_head => l_module,
625: p_token => l_progress,
626: p_message => l_progress || ': violated rule 4'
627: );

Line 640: PO_DEBUG.debug_stmt

636: x_result := FND_API.G_FALSE;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638:
639: IF (g_debug_stmt) THEN
640: PO_DEBUG.debug_stmt
641: ( p_log_head => l_module,
642: p_token => l_progress,
643: p_message => l_progress || ': violated rule 5'
644: );

Line 658: PO_DEBUG.debug_stmt

654: x_result := FND_API.G_FALSE;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: IF (g_debug_stmt) THEN
658: PO_DEBUG.debug_stmt
659: ( p_log_head => l_module,
660: p_token => l_progress,
661: p_message => l_progress || ': violated rule 6'
662: );

Line 675: PO_DEBUG.debug_stmt

671: x_result := FND_API.G_FALSE;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673:
674: IF (g_debug_stmt) THEN
675: PO_DEBUG.debug_stmt
676: ( p_log_head => l_module,
677: p_token => l_progress,
678: p_message => l_progress || ': violated rule 7'
679: );

Line 693: PO_DEBUG.debug_stmt

689: x_result := FND_API.G_FALSE;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691:
692: IF (g_debug_stmt) THEN
693: PO_DEBUG.debug_stmt
694: ( p_log_head => l_module,
695: p_token => l_progress,
696: p_message => l_progress || ': violated rule 8'
697: );

Line 782: PO_DEBUG.debug_begin

778:
779: BEGIN
780:
781: IF (g_debug_stmt) THEN
782: PO_DEBUG.debug_begin
783: ( p_log_head => l_module
784: );
785: END IF;
786:

Line 871: PO_DEBUG.debug_end

867: x_return_status
868: );
869:
870: IF (g_debug_stmt) THEN
871: PO_DEBUG.debug_end
872: ( p_log_head => l_module
873: );
874: END IF;
875:

Line 995: PO_DEBUG.debug_begin

991: l_progress VARCHAR2(3);
992: BEGIN
993:
994: IF (g_debug_stmt) THEN
995: PO_DEBUG.debug_begin
996: ( p_log_head => l_module
997: );
998: END IF;
999:

Line 1026: PO_DEBUG.debug_stmt

1022: WHERE vendor_id = p_from_vendor_id
1023: AND vendor_site_id = p_from_site_id;
1024:
1025: IF (g_debug_stmt) THEN
1026: PO_DEBUG.debug_stmt
1027: ( p_log_head => l_module,
1028: p_token => l_progress,
1029: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1030: );

Line 1059: PO_DEBUG.debug_stmt

1055: AND NVL(PV.end_date_active, SYSDATE+1) <= SYSDATE);
1056:
1057:
1058: IF (g_debug_stmt) THEN
1059: PO_DEBUG.debug_stmt
1060: ( p_log_head => l_module,
1061: p_token => l_progress,
1062: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1063: );

Line 1065: PO_DEBUG.debug_end

1061: p_token => l_progress,
1062: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1063: );
1064:
1065: PO_DEBUG.debug_end
1066: ( p_log_head => l_module
1067: );
1068: END IF;
1069:

Line 1073: PO_DEBUG.debug_exc

1069:
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: IF (g_debug_unexp) THEN
1073: PO_DEBUG.debug_exc
1074: ( p_log_head => l_module,
1075: p_progress => l_progress
1076: );
1077: END IF;

Line 1125: PO_DEBUG.debug_begin

1121: l_progress VARCHAR2(3);
1122: BEGIN
1123:
1124: IF (g_debug_stmt) THEN
1125: PO_DEBUG.debug_begin
1126: ( p_log_head => l_module
1127: );
1128: END IF;
1129:

Line 1145: PO_DEBUG.debug_stmt

1141: AND PRL.suggested_vendor_site_id = p_from_site_id;
1142:
1143:
1144: IF (g_debug_stmt) THEN
1145: PO_DEBUG.debug_stmt
1146: ( p_log_head => l_module,
1147: p_token => l_progress,
1148: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1149: );

Line 1175: PO_DEBUG.debug_stmt

1171: WHERE PV.vendor_id = p_from_vendor_id
1172: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
1173:
1174: IF (g_debug_stmt) THEN
1175: PO_DEBUG.debug_stmt
1176: ( p_log_head => l_module,
1177: p_token => l_progress,
1178: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1179: );

Line 1181: PO_DEBUG.debug_end

1177: p_token => l_progress,
1178: p_message => 'Updated rows: ' || SQL%ROWCOUNT
1179: );
1180:
1181: PO_DEBUG.debug_end
1182: ( p_log_head => l_module
1183: );
1184: END IF;
1185:

Line 1189: PO_DEBUG.debug_exc

1185:
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: IF (g_debug_unexp) THEN
1189: PO_DEBUG.debug_exc
1190: ( p_log_head => l_module,
1191: p_progress => l_progress
1192: );
1193: END IF;

Line 1248: PO_DEBUG.debug_begin

1244:
1245: BEGIN
1246:
1247: IF (g_debug_stmt) THEN
1248: PO_DEBUG.debug_begin
1249: ( p_log_head => l_module
1250: );
1251: END IF;
1252:

Line 1280: PO_DEBUG.debug_stmt

1276: l_progress := '020';
1277:
1278:
1279: IF (g_debug_stmt) THEN
1280: PO_DEBUG.debug_stmt
1281: ( p_log_head => l_module,
1282: p_token => l_progress,
1283: p_message => 'Called WSH Merge API. status = ' || l_return_status
1284: );

Line 1294: PO_DEBUG.debug_end

1290:
1291: l_progress := '030';
1292:
1293: IF (g_debug_stmt) THEN
1294: PO_DEBUG.debug_end
1295: ( p_log_head => l_module
1296: );
1297: END IF;
1298:

Line 1310: PO_DEBUG.debug_stmt

1306:
1307: l_msg_data := FND_MSG_PUB.get
1308: ( p_msg_index => i,
1309: p_encoded => 'F');
1310: PO_DEBUG.debug_stmt
1311: ( p_log_head => l_module,
1312: p_token => l_progress,
1313: p_message => l_msg_data
1314: );

Line 1318: PO_DEBUG.debug_exc

1314: );
1315: END LOOP;
1316: END IF;
1317:
1318: PO_DEBUG.debug_exc
1319: ( p_log_head => l_module,
1320: p_progress => l_progress
1321: );
1322: END IF;

Line 1374: PO_DEBUG.debug_begin

1370:
1371: BEGIN
1372:
1373: IF (g_debug_stmt) THEN
1374: PO_DEBUG.debug_begin
1375: ( p_log_head => l_module
1376: );
1377: END IF;
1378:

Line 1403: PO_DEBUG.debug_stmt

1399: l_progress := '010';
1400:
1401:
1402: IF (g_debug_stmt) THEN
1403: PO_DEBUG.debug_stmt
1404: ( p_log_head => l_module,
1405: p_token => l_progress,
1406: p_message => 'Called OKC Merge API. status = ' || l_return_status
1407: );

Line 1415: PO_DEBUG.debug_end

1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413:
1414: IF (g_debug_stmt) THEN
1415: PO_DEBUG.debug_end
1416: ( p_log_head => l_module
1417: );
1418: END IF;
1419:

Line 1431: PO_DEBUG.debug_stmt

1427:
1428: l_msg_data := FND_MSG_PUB.get
1429: ( p_msg_index => i,
1430: p_encoded => 'F');
1431: PO_DEBUG.debug_stmt
1432: ( p_log_head => l_module,
1433: p_token => l_progress,
1434: p_message => l_msg_data
1435: );

Line 1439: PO_DEBUG.debug_exc

1435: );
1436: END LOOP;
1437: END IF;
1438:
1439: PO_DEBUG.debug_exc
1440: ( p_log_head => l_module,
1441: p_progress => l_progress
1442: );
1443: END IF;