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.ICX_CAT_POPULATE_PODOCS_PVT dependencies on ICX_CAT_UTIL_PVT

Line 35: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

31: BEGIN
32: l_err_loc := 100;
33: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
35: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
36: 'Processing cursor:' || l_api_name ||
37: ', p_key:' || p_key ||
38: ', p_po_line_id:' || p_po_line_id );
39: END IF;

Line 153: populateBPAs(l_bpa_csr, ICX_CAT_UTIL_PVT.g_online_const);

149: AND doc.language = ctx.language (+)
150: ORDER BY doc.po_line_id;
151:
152: l_err_loc := 600;
153: populateBPAs(l_bpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
154:
155: l_err_loc := 700;
156: CLOSE l_bpa_csr;
157: EXCEPTION

Line 159: ICX_CAT_UTIL_PVT.logUnexpectedException(

155: l_err_loc := 700;
156: CLOSE l_bpa_csr;
157: EXCEPTION
158: WHEN OTHERS THEN
159: ICX_CAT_UTIL_PVT.logUnexpectedException(
160: G_PKG_NAME, l_api_name,
161: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
162: RAISE;
163: END openBPACursor;

Line 177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

173: BEGIN
174: l_err_loc := 100;
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
177: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
178: 'Processing cursor:' || l_api_name ||
179: ', p_key:' || p_key ||
180: ', p_po_line_id:' || p_po_line_id );
181: END IF;

Line 286: populateBPAs(l_bpa_csr, ICX_CAT_UTIL_PVT.g_online_const);

282: AND doc.language = ctx.language (+)
283: ORDER BY doc.po_line_id;
284:
285: l_err_loc := 600;
286: populateBPAs(l_bpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
287:
288: l_err_loc := 700;
289: CLOSE l_bpa_csr;
290: EXCEPTION

Line 292: ICX_CAT_UTIL_PVT.logUnexpectedException(

288: l_err_loc := 700;
289: CLOSE l_bpa_csr;
290: EXCEPTION
291: WHEN OTHERS THEN
292: ICX_CAT_UTIL_PVT.logUnexpectedException(
293: G_PKG_NAME, l_api_name,
294: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
295: RAISE;
296: END openBPAOrgAssignmentCursor;

Line 298: --l_bpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

294: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
295: RAISE;
296: END openBPAOrgAssignmentCursor;
297:
298: --l_bpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
299: PROCEDURE populateBPAs
300: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
301: p_current_mode IN VARCHAR2
302: )

Line 499: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

495: l_ctx_ip_category_id_tbl,
496: l_ctx_po_category_id_tbl,
497: l_ctx_item_revision_tbl,
498: l_ctx_rowid_tbl
499: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
500:
501: l_err_loc := 300;
502: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
503:

Line 511: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

507: l_err_loc := 500;
508: l_count := l_po_line_id_tbl.COUNT;
509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
511: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
512: 'Num. of rows returned from the cursor:' || l_count);
513: END IF;
514:
515: --Save the last po_line_id processed, so that re-open of cursor will start from the saved id.

Line 523: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND

519:
520: FOR i in 1..l_po_line_id_tbl.COUNT LOOP
521: l_err_loc := 600;
522: --First get the status of the current BPA line
523: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
524: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
525: THEN
526: l_err_loc := 700;
527: -- The GBPAs created for bulkload items will not be in approved

Line 524: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)

520: FOR i in 1..l_po_line_id_tbl.COUNT LOOP
521: l_err_loc := 600;
522: --First get the status of the current BPA line
523: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
524: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
525: THEN
526: l_err_loc := 700;
527: -- The GBPAs created for bulkload items will not be in approved
528: -- status during upgrade, so treat them as valid during upgrade.

Line 532: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

528: -- status during upgrade, so treat them as valid during upgrade.
529: l_BPA_line_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
530: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
532: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
533: 'bpa status is hard-coded to valid for' ||
534: ', p_current_mode:' || p_current_mode ||
535: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );
536: END IF;

Line 561: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

557: THEN
558: l_err_loc := 1100;
559: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
560: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
561: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
562: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
563: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
564: l_current_ctx_item_rec.language := l_language_tbl(i);
565: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

Line 562: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

558: l_err_loc := 1100;
559: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
560: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
561: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
562: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
563: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
564: l_current_ctx_item_rec.language := l_language_tbl(i);
565: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
566: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

Line 566: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

562: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
563: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
564: l_current_ctx_item_rec.language := l_language_tbl(i);
565: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
566: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
567: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
568: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
569: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
570: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

Line 619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

615: l_err_loc := 1300;
616: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
617:
618: l_err_loc := 1400;
619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

617:
618: l_err_loc := 1400;
619: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
625: 'Row #:' || i ||

Line 624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

620: ELSE
621: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
622: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
624: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
625: 'Row #:' || i ||
626: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
627: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||
628: ', l_authorization_status_tbl:' || l_authorization_status_tbl(i) ||

Line 642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

638: END IF;
639: ELSE
640: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
643: 'Row #:' || i ||
644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
645: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||
646: ', l_authorization_status_tbl:' || l_authorization_status_tbl(i) ||

Line 662: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

658: END IF;
659: END LOOP; --FOR LOOP of l_po_line_id_tbl
660:
661: l_err_loc := 1500;
662: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
663: EXCEPTION
664: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
666: ||', Total processeded batches:' ||l_batch_count

Line 664: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

660:
661: l_err_loc := 1500;
662: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
663: EXCEPTION
664: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
666: ||', Total processeded batches:' ||l_batch_count
667: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
668: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 668: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

664: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
666: ||', Total processeded batches:' ||l_batch_count
667: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
668: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
669: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
670: --Closing and reopen of cursor will be done by called procedures
671: l_err_loc := 1700;
672: IF (g_current_cursor = 'ORG_ASSIGNMENT_CSR') THEN

Line 669: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

665: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateBPAs' ||l_err_loc
666: ||', Total processeded batches:' ||l_batch_count
667: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
668: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
669: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
670: --Closing and reopen of cursor will be done by called procedures
671: l_err_loc := 1700;
672: IF (g_current_cursor = 'ORG_ASSIGNMENT_CSR') THEN
673: l_err_loc := 1720;

Line 686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

682: END;
683: END LOOP; --Cursor loop
684:
685: l_err_loc := 1800;
686: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
687:
688: l_err_loc := 1900;
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

687:
688: l_err_loc := 1900;
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
691: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
692: 'populateBPAs in mode:'|| p_current_mode ||' done; '||
693: 'Total num. of batches processed:' ||l_batch_count ||
694: ', Total num. of rows processed:' ||l_row_count);
695: END IF;

Line 698: ICX_CAT_UTIL_PVT.logUnexpectedException(

694: ', Total num. of rows processed:' ||l_row_count);
695: END IF;
696: EXCEPTION
697: WHEN OTHERS THEN
698: ICX_CAT_UTIL_PVT.logUnexpectedException(
699: G_PKG_NAME, l_api_name,
700: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
701: RAISE;
702: END populateBPAs;

Line 718: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

714: BEGIN
715: l_err_loc := 100;
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
718: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
719: 'Processing cursor:' || l_api_name ||
720: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
721: ', g_start_rowid:' || g_start_rowid ||
722: ', g_end_rowid:' || g_end_rowid );

Line 896: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);

892: AND doc.language = ctx.language (+);
893: END IF;
894:
895: l_err_loc := 600;
896: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
897:
898: l_err_loc := 700;
899: CLOSE l_gbpa_csr;
900: EXCEPTION

Line 902: ICX_CAT_UTIL_PVT.logUnexpectedException(

898: l_err_loc := 700;
899: CLOSE l_gbpa_csr;
900: EXCEPTION
901: WHEN OTHERS THEN
902: ICX_CAT_UTIL_PVT.logUnexpectedException(
903: G_PKG_NAME, l_api_name,
904: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
905: RAISE;
906: END openR12UpgradeGBPACursor;

Line 920: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

916: BEGIN
917: l_err_loc := 100;
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
920: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
921: 'Processing cursor:' || l_api_name ||
922: ', p_key:' || p_key ||
923: ', p_po_line_id:' || p_po_line_id );
924: END IF;

Line 1018: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);

1014: AND doc.language = ctx.language (+)
1015: ORDER BY doc.po_line_id;
1016:
1017: l_err_loc := 500;
1018: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
1019:
1020: l_err_loc := 600;
1021: CLOSE l_gbpa_csr;
1022: EXCEPTION

Line 1024: ICX_CAT_UTIL_PVT.logUnexpectedException(

1020: l_err_loc := 600;
1021: CLOSE l_gbpa_csr;
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: ICX_CAT_UTIL_PVT.logUnexpectedException(
1025: G_PKG_NAME, l_api_name,
1026: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1027: RAISE;
1028: END openGBPACursor;

Line 1042: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1038: BEGIN
1039: l_err_loc := 100;
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1042: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1043: 'Processing cursor:' || l_api_name ||
1044: ', p_key:' || p_key ||
1045: ', p_po_line_id:' || p_po_line_id );
1046: END IF;

Line 1137: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);

1133: AND doc.language = ctx.language (+)
1134: ORDER BY doc.po_line_id;
1135:
1136: l_err_loc := 500;
1137: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
1138:
1139: l_err_loc := 600;
1140: CLOSE l_gbpa_csr;
1141: EXCEPTION

Line 1143: ICX_CAT_UTIL_PVT.logUnexpectedException(

1139: l_err_loc := 600;
1140: CLOSE l_gbpa_csr;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: ICX_CAT_UTIL_PVT.logUnexpectedException(
1144: G_PKG_NAME, l_api_name,
1145: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1146: RAISE;
1147: END openGBPAOrgAssignmentCursor;

Line 1149: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

1145: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1146: RAISE;
1147: END openGBPAOrgAssignmentCursor;
1148:
1149: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
1150: PROCEDURE populateGBPAs
1151: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1152: p_current_mode IN VARCHAR2
1153: )

Line 1322: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1318: l_ctx_ip_category_id_tbl,
1319: l_ctx_po_category_id_tbl,
1320: l_ctx_item_revision_tbl,
1321: l_ctx_rowid_tbl
1322: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1323:
1324: l_err_loc := 400;
1325: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
1326:

Line 1334: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1330: l_err_loc := 600;
1331: l_count := l_po_line_id_tbl.COUNT;
1332: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1334: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1335: 'Num. of rows returned from the cursor:' || l_count);
1336: END IF;
1337: --Save the last po_line_id processed, so that re-open of cursor will start from the saved id.
1338: l_start_po_line_id := l_po_line_id_tbl(l_count);

Line 1354: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1350: THEN
1351: l_err_loc := 900;
1352: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
1353: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
1354: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1355: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1356: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1357: l_current_ctx_item_rec.language := l_language_tbl(i);
1358: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

Line 1355: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

1351: l_err_loc := 900;
1352: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
1353: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
1354: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1355: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1356: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1357: l_current_ctx_item_rec.language := l_language_tbl(i);
1358: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1359: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

Line 1359: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

1355: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1356: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1357: l_current_ctx_item_rec.language := l_language_tbl(i);
1358: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1359: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
1360: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
1361: l_current_ctx_item_rec.owning_org_id := l_owning_org_id_tbl(i);
1362: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
1363: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

Line 1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);

1408: l_err_loc := 1300;
1409: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1410:
1411: l_err_loc := 1400;
1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

1410:
1411: l_err_loc := 1400;
1412: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1417: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1418: 'Row #:' || i ||

Line 1417: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1413: ELSE
1414: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1415: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1417: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1418: 'Row #:' || i ||
1419: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1420: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1421: ', status: ' || l_GBPA_line_status);

Line 1426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1422: END IF;
1423: ELSE
1424: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1426: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1427: 'Row #:' || i ||
1428: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1429: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1430: ', status: ' || l_GBPA_line_status);

Line 1437: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

1433: END IF;
1434: END LOOP; -- FOR LOOP of l_po_line_id_tbl
1435:
1436: l_err_loc := 1500;
1437: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1438: EXCEPTION
1439: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1441: ||', Total processed batches:' ||l_batch_count

Line 1439: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1435:
1436: l_err_loc := 1500;
1437: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1438: EXCEPTION
1439: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1441: ||', Total processed batches:' ||l_batch_count
1442: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

1439: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1441: ||', Total processed batches:' ||l_batch_count
1442: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1444: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1445: -- Closing and reopen of cursor will be done by called procedures
1446: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1447: l_err_loc := 1600;

Line 1444: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

1440: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1441: ||', Total processed batches:' ||l_batch_count
1442: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1444: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1445: -- Closing and reopen of cursor will be done by called procedures
1446: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1447: l_err_loc := 1600;
1448: openR12UpgradeGBPACursor;

Line 1446: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

1442: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1443: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1444: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1445: -- Closing and reopen of cursor will be done by called procedures
1446: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1447: l_err_loc := 1600;
1448: openR12UpgradeGBPACursor;
1449: ELSE
1450: l_err_loc := 1700;

Line 1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);

1462: END;
1463: END LOOP; -- Cursor loop
1464:
1465: l_err_loc := 2000;
1466: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1467:
1468: l_err_loc := 2100;
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 1471: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1467:
1468: l_err_loc := 2100;
1469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1471: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1472: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1473: 'Total num. of batches processed:' ||l_batch_count ||
1474: ', Total num. of rows fetched:' ||l_row_count);
1475: END IF;

Line 1478: ICX_CAT_UTIL_PVT.logUnexpectedException(

1474: ', Total num. of rows fetched:' ||l_row_count);
1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: ICX_CAT_UTIL_PVT.logUnexpectedException(
1479: G_PKG_NAME, l_api_name,
1480: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1481: RAISE;
1482: END populateGBPAs;

Line 1498: ICX_CAT_UTIL_PVT.setBatchSize;

1494: l_err_loc PLS_INTEGER;
1495: BEGIN
1496: l_err_loc := 100;
1497: -- Set the batch_size
1498: ICX_CAT_UTIL_PVT.setBatchSize;
1499:
1500: l_err_loc := 200;
1501: -- Set the who columns
1502: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 1502: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1498: ICX_CAT_UTIL_PVT.setBatchSize;
1499:
1500: l_err_loc := 200;
1501: -- Set the who columns
1502: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1503:
1504: l_err_loc := 250;
1505: g_current_cursor := 'GBPA_CSR';
1506:

Line 1512: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

1508: g_key := p_key;
1509:
1510: l_err_loc := 350;
1511: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1513: END IF;
1514:
1515: l_err_loc := 400;
1516: openBPACursor(p_key, 0);

Line 1526: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);

1522: g_metadataTblFormed := FALSE;
1523: g_CtxSqlForPODocsFormed := FALSE;
1524:
1525: l_err_loc := 700;
1526: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
1527:
1528: l_err_loc := 800;
1529: EXCEPTION
1530: WHEN OTHERS THEN

Line 1531: ICX_CAT_UTIL_PVT.logUnexpectedException(

1527:
1528: l_err_loc := 800;
1529: EXCEPTION
1530: WHEN OTHERS THEN
1531: ICX_CAT_UTIL_PVT.logUnexpectedException(
1532: G_PKG_NAME, l_api_name,
1533: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1534: RAISE;
1535: END populateOnlineBlankets;

Line 1546: ICX_CAT_UTIL_PVT.setBatchSize;

1542: l_err_loc PLS_INTEGER;
1543: BEGIN
1544: l_err_loc := 100;
1545: -- Set the batch_size
1546: ICX_CAT_UTIL_PVT.setBatchSize;
1547:
1548: l_err_loc := 200;
1549: -- Set the who columns
1550: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 1550: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1546: ICX_CAT_UTIL_PVT.setBatchSize;
1547:
1548: l_err_loc := 200;
1549: -- Set the who columns
1550: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1551:
1552: l_err_loc := 300;
1553: g_current_cursor := 'ORG_ASSIGNMENT_CSR';
1554: g_key := p_key;

Line 1558: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

1554: g_key := p_key;
1555:
1556: l_err_loc := 350;
1557: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1559: END IF;
1560:
1561: l_err_loc := 400;
1562: openBPAOrgAssignmentCursor(p_key, 0);

Line 1575: -- ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);

1571: l_err_loc := 600;
1572: -- No need of to re-populate category attributes
1573: -- i.e. call ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt
1574: -- because the changes are only in the org assignments.
1575: -- ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
1576:
1577: l_err_loc := 700;
1578: EXCEPTION
1579: WHEN OTHERS THEN

Line 1580: ICX_CAT_UTIL_PVT.logUnexpectedException(

1576:
1577: l_err_loc := 700;
1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: ICX_CAT_UTIL_PVT.logUnexpectedException(
1581: G_PKG_NAME, l_api_name,
1582: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1583: RAISE;
1584: END populateOnlineOrgAssgnmnts;

Line 1600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

1596: BEGIN
1597: l_err_loc := 100;
1598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1600: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1601: 'Processing cursor:' || l_api_name ||
1602: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
1603: ', g_start_rowid:' || g_start_rowid ||
1604: ', g_end_rowid:' || g_end_rowid );

Line 1829: populateBPAandQuotes(l_bpa_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);

1825: OR (ctx.rowid IS NOT NULL OR doc.quote_status = 0));
1826: END IF;
1827:
1828: l_err_loc := 700;
1829: populateBPAandQuotes(l_bpa_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
1830:
1831: l_err_loc := 800;
1832: CLOSE l_bpa_quote_csr;
1833: EXCEPTION

Line 1835: ICX_CAT_UTIL_PVT.logUnexpectedException(

1831: l_err_loc := 800;
1832: CLOSE l_bpa_quote_csr;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: ICX_CAT_UTIL_PVT.logUnexpectedException(
1836: G_PKG_NAME, l_api_name,
1837: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1838: RAISE;
1839: END openR12UpgradeBPAQuoteCursor;

Line 2041: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

2037: l_ctx_ip_category_id_tbl,
2038: l_ctx_po_category_id_tbl,
2039: l_ctx_item_revision_tbl,
2040: l_ctx_rowid_tbl
2041: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
2042:
2043: l_err_loc := 300;
2044: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
2045:

Line 2053: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2049: l_err_loc := 500;
2050: l_count := l_po_line_id_tbl.COUNT;
2051: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2053: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2054: 'Num. of rows returned from the cursor:' || l_count);
2055: END IF;
2056:
2057: l_row_count := l_row_count + l_count;

Line 2063: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND

2059: FOR i in 1..l_po_line_id_tbl.COUNT LOOP
2060: l_err_loc := 600;
2061: IF (l_source_type_tbl(i) = 'BLANKET') THEN
2062: --First get the status of the current BPA line
2063: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
2064: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
2065: THEN
2066: l_err_loc := 700;
2067: -- The GBPAs created for bulkload items will not be in approved

Line 2064: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)

2060: l_err_loc := 600;
2061: IF (l_source_type_tbl(i) = 'BLANKET') THEN
2062: --First get the status of the current BPA line
2063: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
2064: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
2065: THEN
2066: l_err_loc := 700;
2067: -- The GBPAs created for bulkload items will not be in approved
2068: -- status during upgrade, so treat them as valid during upgrade.

Line 2072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2068: -- status during upgrade, so treat them as valid during upgrade.
2069: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2071: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2072: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2073: 'bpa status is hard-coded to valid for' ||
2074: ', p_current_mode:' || p_current_mode ||
2075: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );
2076: END IF;

Line 2104: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

2100: THEN
2101: l_err_loc := 1100;
2102: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2103: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2104: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2105: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2106: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2107: l_current_ctx_item_rec.language := l_language_tbl(i);
2108: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

Line 2105: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

2101: l_err_loc := 1100;
2102: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2103: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2104: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2105: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2106: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2107: l_current_ctx_item_rec.language := l_language_tbl(i);
2108: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2109: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

Line 2109: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

2105: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2106: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2107: l_current_ctx_item_rec.language := l_language_tbl(i);
2108: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2109: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
2110: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
2111: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
2112: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
2113: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

Line 2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

2157: l_err_loc := 1300;
2158: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2159:
2160: l_err_loc := 1400;
2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

2159:
2160: l_err_loc := 1400;
2161: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2166: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2167: 'Row #:' || i ||

Line 2166: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2162: ELSE
2163: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2165: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2166: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2167: 'Row #:' || i ||
2168: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2169: ', l_source_type_tbl:' || l_source_type_tbl(i) ||
2170: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||

Line 2187: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

2183: END IF;
2184: END LOOP; --FOR LOOP of l_po_line_id_tbl
2185:
2186: l_err_loc := 1500;
2187: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2188: EXCEPTION
2189: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2191: ||', Total processed batches:' ||l_batch_count

Line 2189: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

2185:
2186: l_err_loc := 1500;
2187: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2188: EXCEPTION
2189: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2191: ||', Total processed batches:' ||l_batch_count
2192: ||', Cursor will be reopened;';
2193: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc

2186: l_err_loc := 1500;
2187: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2188: EXCEPTION
2189: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2191: ||', Total processed batches:' ||l_batch_count
2192: ||', Cursor will be reopened;';
2193: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2194: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 2193: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

2189: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2191: ||', Total processed batches:' ||l_batch_count
2192: ||', Cursor will be reopened;';
2193: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2194: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2195: --Closing and reopen of cursor will be done by called procedures
2196: l_err_loc := 1600;
2197: openR12UpgradeBPAQuoteCursor;

Line 2194: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

2190: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2191: ||', Total processed batches:' ||l_batch_count
2192: ||', Cursor will be reopened;';
2193: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2194: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2195: --Closing and reopen of cursor will be done by called procedures
2196: l_err_loc := 1600;
2197: openR12UpgradeBPAQuoteCursor;
2198: ELSE

Line 2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);

2201: END;
2202: END LOOP; --Cursor loop
2203:
2204: l_err_loc := 1800;
2205: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2206:
2207: l_err_loc := 1900;
2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2210: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2206:
2207: l_err_loc := 1900;
2208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2210: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2211: 'in mode:'|| p_current_mode ||' done; '||
2212: 'Total num. of batches processed:' ||l_batch_count ||
2213: ', Total num. of rows processed:' ||l_row_count);
2214: END IF;

Line 2217: ICX_CAT_UTIL_PVT.logUnexpectedException(

2213: ', Total num. of rows processed:' ||l_row_count);
2214: END IF;
2215: EXCEPTION
2216: WHEN OTHERS THEN
2217: ICX_CAT_UTIL_PVT.logUnexpectedException(
2218: G_PKG_NAME, l_api_name,
2219: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2220: RAISE;
2221: END populateBPAandQuotes;

Line 2248: ICX_CAT_UTIL_PVT.logUnexpectedException(

2244:
2245: l_err_loc := 500;
2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: ICX_CAT_UTIL_PVT.logUnexpectedException(
2249: G_PKG_NAME, l_api_name,
2250: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;

Line 2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

2247: WHEN OTHERS THEN
2248: ICX_CAT_UTIL_PVT.logUnexpectedException(
2249: G_PKG_NAME, l_api_name,
2250: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2253: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2254: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2255: RAISE;

Line 2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;

2248: ICX_CAT_UTIL_PVT.logUnexpectedException(
2249: G_PKG_NAME, l_api_name,
2250: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2253: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2254: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2255: RAISE;
2256: END upgradeR12PODocs;

Line 2253: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;

2249: G_PKG_NAME, l_api_name,
2250: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2253: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2254: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2255: RAISE;
2256: END upgradeR12PODocs;
2257:

Line 2254: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;

2250: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2251: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2252: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2253: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2254: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2255: RAISE;
2256: END upgradeR12PODocs;
2257:
2258: ----------------------------------------------------------------------

Line 2275: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2271: BEGIN
2272: l_err_loc := 100;
2273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2275: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2276: 'Processing cursor:' || l_api_name ||
2277: ', p_key:' || p_key ||
2278: ', p_po_line_id:' || p_po_line_id );
2279: END IF;

Line 2375: populateQuotes(l_quote_csr, ICX_CAT_UTIL_PVT.g_online_const);

2371: -- AND (ctx.rowid IS NOT NULL OR doc.status = 0)
2372: ORDER BY doc.po_line_id;
2373:
2374: l_err_loc := 500;
2375: populateQuotes(l_quote_csr, ICX_CAT_UTIL_PVT.g_online_const);
2376:
2377: l_err_loc := 600;
2378: CLOSE l_quote_csr;
2379: EXCEPTION

Line 2381: ICX_CAT_UTIL_PVT.logUnexpectedException(

2377: l_err_loc := 600;
2378: CLOSE l_quote_csr;
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: ICX_CAT_UTIL_PVT.logUnexpectedException(
2382: G_PKG_NAME, l_api_name,
2383: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2384: RAISE;
2385: END openQuotesCursor;

Line 2387: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

2383: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2384: RAISE;
2385: END openQuotesCursor;
2386:
2387: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
2388: PROCEDURE populateQuotes
2389: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
2390: p_current_mode IN VARCHAR2
2391: )

Line 2549: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

2545: l_ctx_ip_category_id_tbl,
2546: l_ctx_po_category_id_tbl,
2547: l_ctx_item_revision_tbl,
2548: l_ctx_rowid_tbl
2549: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
2550: l_err_loc := 400;
2551:
2552: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
2553:

Line 2561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2557: l_err_loc := 600;
2558: l_count := l_po_line_id_tbl.COUNT;
2559: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2561: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2562: 'Num. of rows returned from the cursor:' || l_count);
2563: END IF;
2564:
2565: --Save the last po_line_id processed, so that re-open of cursor will start from the saved id.

Line 2578: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

2574: THEN
2575: l_err_loc := 800;
2576: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2577: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2578: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2579: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2580: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2581: l_current_ctx_item_rec.language := l_language_tbl(i);
2582: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

Line 2579: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

2575: l_err_loc := 800;
2576: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2577: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2578: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2579: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2580: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2581: l_current_ctx_item_rec.language := l_language_tbl(i);
2582: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2583: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

Line 2583: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

2579: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2580: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2581: l_current_ctx_item_rec.language := l_language_tbl(i);
2582: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2583: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
2584: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
2585: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
2586: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
2587: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

Line 2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);

2632: l_err_loc := 900;
2633: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2634:
2635: l_err_loc := 1000;
2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2637: ELSE
2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN

2635: l_err_loc := 1000;
2636: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2637: ELSE
2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2643: 'Row #:' || i ||

Line 2642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2638: l_err_loc := 1100;
2639: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2640: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2642: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2643: 'Row #:' || i ||
2644: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2645: ', status: ' || l_status_tbl(i));
2646: END IF;

Line 2650: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2646: END IF;
2647: ELSE
2648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2649: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2650: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2651: 'Row #:' || i ||
2652: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2653: ', status: ' || l_status_tbl(i));
2654: END IF;

Line 2660: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

2656: END IF;
2657: END LOOP; --FOR LOOP of l_po_line_id_tbl
2658:
2659: l_err_loc := 1200;
2660: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2661: EXCEPTION
2662: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2664: ||', Total processed batches:' ||l_batch_count

Line 2662: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

2658:
2659: l_err_loc := 1200;
2660: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2661: EXCEPTION
2662: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2664: ||', Total processed batches:' ||l_batch_count
2665: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 2666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

2662: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2664: ||', Total processed batches:' ||l_batch_count
2665: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2667: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2668: --Closing and reopen of cursor will be done by called procedures
2669: openQuotesCursor(g_key, l_start_po_line_id);
2670: ELSE

Line 2667: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

2663: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2664: ||', Total processed batches:' ||l_batch_count
2665: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2666: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2667: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2668: --Closing and reopen of cursor will be done by called procedures
2669: openQuotesCursor(g_key, l_start_po_line_id);
2670: ELSE
2671: RAISE;

Line 2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);

2673: END;
2674: END LOOP; --Cursor loop
2675:
2676: l_err_loc := 1500;
2677: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2678:
2679: l_err_loc := 1600;
2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 2682: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2678:
2679: l_err_loc := 1600;
2680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2682: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2683: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2684: 'Total num. of batches processed:' ||l_batch_count ||
2685: ', Total num. of rows processed:' ||l_row_count);
2686: END IF;

Line 2689: ICX_CAT_UTIL_PVT.logUnexpectedException(

2685: ', Total num. of rows processed:' ||l_row_count);
2686: END IF;
2687: EXCEPTION
2688: WHEN OTHERS THEN
2689: ICX_CAT_UTIL_PVT.logUnexpectedException(
2690: G_PKG_NAME, l_api_name,
2691: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2692: RAISE;
2693: END populateQuotes;

Line 2704: ICX_CAT_UTIL_PVT.setBatchSize;

2700: l_err_loc PLS_INTEGER;
2701: BEGIN
2702: l_err_loc := 100;
2703: -- Set the batch_size
2704: ICX_CAT_UTIL_PVT.setBatchSize;
2705:
2706: l_err_loc := 200;
2707: -- Set the who columns
2708: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 2708: ICX_CAT_UTIL_PVT.setWhoColumns(null);

2704: ICX_CAT_UTIL_PVT.setBatchSize;
2705:
2706: l_err_loc := 200;
2707: -- Set the who columns
2708: ICX_CAT_UTIL_PVT.setWhoColumns(null);
2709:
2710: l_err_loc := 300;
2711: g_key := p_key;
2712:

Line 2715: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

2711: g_key := p_key;
2712:
2713: l_err_loc := 350;
2714: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
2716: END IF;
2717:
2718: l_err_loc := 400;
2719: openQuotesCursor(p_key, 0);

Line 2726: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);

2722: g_metadataTblFormed := FALSE;
2723: g_CtxSqlForPODocsFormed := FALSE;
2724:
2725: l_err_loc := 600;
2726: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
2727:
2728: l_err_loc := 700;
2729: EXCEPTION
2730: WHEN OTHERS THEN

Line 2731: ICX_CAT_UTIL_PVT.logUnexpectedException(

2727:
2728: l_err_loc := 700;
2729: EXCEPTION
2730: WHEN OTHERS THEN
2731: ICX_CAT_UTIL_PVT.logUnexpectedException(
2732: G_PKG_NAME, l_api_name,
2733: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2734: RAISE;
2735: END populateOnlineQuotes;

Line 2754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2750: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2751: l_err_loc := 200;
2752: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2754: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2755: 'about to call buildmetadatinfo');
2756: END IF;
2757:
2758: l_err_loc := 200;

Line 2771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),

2767: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2768: l_err_loc := 500;
2769: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2771: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2772: 'about to call buildctxsql');
2773: END IF;
2774:
2775: l_err_loc := 600;

Line 2777: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'NOTROWID', g_special_metadata_tbl,

2773: END IF;
2774:
2775: l_err_loc := 600;
2776: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
2777: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'NOTROWID', g_special_metadata_tbl,
2778: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
2779: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
2780: ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed := TRUE;
2781: END IF;

Line 2791: ICX_CAT_UTIL_PVT.logUnexpectedException(

2787: l_err_loc := 800;
2788:
2789: EXCEPTION
2790: WHEN OTHERS THEN
2791: ICX_CAT_UTIL_PVT.logUnexpectedException(
2792: G_PKG_NAME, l_api_name,
2793: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2794: RAISE;
2795: END buildCtxSqlForPODocs;