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 565: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 668: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

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

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

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

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

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

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

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

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

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

Line 702: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

896: AND doc.language = ctx.language (+);
897: END IF;
898:
899: l_err_loc := 600;
900: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
901:
902: l_err_loc := 700;
903: CLOSE l_gbpa_csr;
904: EXCEPTION

Line 906: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

1018: AND doc.language = ctx.language (+)
1019: ORDER BY doc.po_line_id;
1020:
1021: l_err_loc := 500;
1022: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
1023:
1024: l_err_loc := 600;
1025: CLOSE l_gbpa_csr;
1026: EXCEPTION

Line 1028: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

1137: AND doc.language = ctx.language (+)
1138: ORDER BY doc.po_line_id;
1139:
1140: l_err_loc := 500;
1141: populateGBPAs(l_gbpa_csr, ICX_CAT_UTIL_PVT.g_online_const);
1142:
1143: l_err_loc := 600;
1144: CLOSE l_gbpa_csr;
1145: EXCEPTION

Line 1147: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

Line 1153: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

1149: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1150: RAISE;
1151: END openGBPAOrgAssignmentCursor;
1152:
1153: --l_gbpa_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
1154: PROCEDURE populateGBPAs
1155: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
1156: p_current_mode IN VARCHAR2
1157: )

Line 1327: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

1323: l_ctx_ip_category_id_tbl,
1324: l_ctx_po_category_id_tbl,
1325: l_ctx_item_revision_tbl,
1326: l_ctx_rowid_tbl
1327: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
1328:
1329: l_err_loc := 400;
1330: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
1331:

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

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

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

1364: THEN
1365: l_err_loc := 900;
1366: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
1367: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
1368: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1369: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1370: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1371: l_current_ctx_item_rec.language := l_language_tbl(i);
1372: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

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

1365: l_err_loc := 900;
1366: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
1367: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
1368: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1369: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1370: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1371: l_current_ctx_item_rec.language := l_language_tbl(i);
1372: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1373: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

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

1369: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
1370: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
1371: l_current_ctx_item_rec.language := l_language_tbl(i);
1372: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
1373: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
1374: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
1375: l_current_ctx_item_rec.owning_org_id := l_owning_org_id_tbl(i);
1376: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
1377: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

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

1422: l_err_loc := 1300;
1423: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, g_current_cursor, p_current_mode);
1424:
1425: l_err_loc := 1400;
1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

1424:
1425: l_err_loc := 1400;
1426: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1431: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1432: 'Row #:' || i ||

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

1427: ELSE
1428: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1431: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1432: 'Row #:' || i ||
1433: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1434: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1435: ', status: ' || l_GBPA_line_status);

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

1436: END IF;
1437: ELSE
1438: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1440: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1441: 'Row #:' || i ||
1442: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
1443: ', l_enabled_flag_tbl:' || l_enabled_flag_tbl(i) ||
1444: ', status: ' || l_GBPA_line_status);

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

1447: END IF;
1448: END LOOP; -- FOR LOOP of l_po_line_id_tbl
1449:
1450: l_err_loc := 1500;
1451: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1455: ||', Total processed batches:' ||l_batch_count

Line 1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

1449:
1450: l_err_loc := 1500;
1451: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1455: ||', Total processed batches:' ||l_batch_count
1456: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1457: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

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

1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1455: ||', Total processed batches:' ||l_batch_count
1456: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1457: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1458: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1459: -- Closing and reopen of cursor will be done by called procedures
1460: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1461: l_err_loc := 1600;

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

1454: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateGBPAs' ||l_err_loc
1455: ||', Total processed batches:' ||l_batch_count
1456: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1457: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1458: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1459: -- Closing and reopen of cursor will be done by called procedures
1460: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1461: l_err_loc := 1600;
1462: openR12UpgradeGBPACursor;

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

1456: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
1457: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
1458: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1459: -- Closing and reopen of cursor will be done by called procedures
1460: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
1461: l_err_loc := 1600;
1462: openR12UpgradeGBPACursor;
1463: ELSE
1464: l_err_loc := 1700;

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

1476: END;
1477: END LOOP; -- Cursor loop
1478:
1479: l_err_loc := 2000;
1480: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_GBPACsr_const);
1481:
1482: l_err_loc := 2100;
1483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

1481:
1482: l_err_loc := 2100;
1483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1485: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1486: 'populateGBPAs in mode:'|| p_current_mode ||' done; '||
1487: 'Total num. of batches processed:' ||l_batch_count ||
1488: ', Total num. of rows fetched:' ||l_row_count);
1489: END IF;

Line 1492: ICX_CAT_UTIL_PVT.logUnexpectedException(

1488: ', Total num. of rows fetched:' ||l_row_count);
1489: END IF;
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: ICX_CAT_UTIL_PVT.logUnexpectedException(
1493: G_PKG_NAME, l_api_name,
1494: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1495: RAISE;
1496: END populateGBPAs;

Line 1512: ICX_CAT_UTIL_PVT.setBatchSize;

1508: l_err_loc PLS_INTEGER;
1509: BEGIN
1510: l_err_loc := 100;
1511: -- Set the batch_size
1512: ICX_CAT_UTIL_PVT.setBatchSize;
1513:
1514: l_err_loc := 200;
1515: -- Set the who columns
1516: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 1516: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1512: ICX_CAT_UTIL_PVT.setBatchSize;
1513:
1514: l_err_loc := 200;
1515: -- Set the who columns
1516: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1517:
1518: l_err_loc := 250;
1519: g_current_cursor := 'GBPA_CSR';
1520:

Line 1526: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

1522: g_key := p_key;
1523:
1524: l_err_loc := 350;
1525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1526: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1527: END IF;
1528:
1529: l_err_loc := 400;
1530: openBPACursor(p_key, 0);

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

1536: g_metadataTblFormed := FALSE;
1537: g_CtxSqlForPODocsFormed := FALSE;
1538:
1539: l_err_loc := 700;
1540: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
1541:
1542: l_err_loc := 800;
1543: EXCEPTION
1544: WHEN OTHERS THEN

Line 1545: ICX_CAT_UTIL_PVT.logUnexpectedException(

1541:
1542: l_err_loc := 800;
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: ICX_CAT_UTIL_PVT.logUnexpectedException(
1546: G_PKG_NAME, l_api_name,
1547: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1548: RAISE;
1549: END populateOnlineBlankets;

Line 1560: ICX_CAT_UTIL_PVT.setBatchSize;

1556: l_err_loc PLS_INTEGER;
1557: BEGIN
1558: l_err_loc := 100;
1559: -- Set the batch_size
1560: ICX_CAT_UTIL_PVT.setBatchSize;
1561:
1562: l_err_loc := 200;
1563: -- Set the who columns
1564: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 1564: ICX_CAT_UTIL_PVT.setWhoColumns(null);

1560: ICX_CAT_UTIL_PVT.setBatchSize;
1561:
1562: l_err_loc := 200;
1563: -- Set the who columns
1564: ICX_CAT_UTIL_PVT.setWhoColumns(null);
1565:
1566: l_err_loc := 300;
1567: g_current_cursor := 'ORG_ASSIGNMENT_CSR';
1568: g_key := p_key;

Line 1572: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

1568: g_key := p_key;
1569:
1570: l_err_loc := 350;
1571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
1573: END IF;
1574:
1575: l_err_loc := 400;
1576: openBPAOrgAssignmentCursor(p_key, 0);

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

1585: l_err_loc := 600;
1586: -- No need of to re-populate category attributes
1587: -- i.e. call ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt
1588: -- because the changes are only in the org assignments.
1589: -- ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
1590:
1591: l_err_loc := 700;
1592: EXCEPTION
1593: WHEN OTHERS THEN

Line 1594: ICX_CAT_UTIL_PVT.logUnexpectedException(

1590:
1591: l_err_loc := 700;
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: ICX_CAT_UTIL_PVT.logUnexpectedException(
1595: G_PKG_NAME, l_api_name,
1596: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1597: RAISE;
1598: END populateOnlineOrgAssgnmnts;

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

1610: BEGIN
1611: l_err_loc := 100;
1612: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1614: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1615: 'Processing cursor:' || l_api_name ||
1616: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
1617: ', g_start_rowid:' || g_start_rowid ||
1618: ', g_end_rowid:' || g_end_rowid );

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

1839: OR (ctx.rowid IS NOT NULL OR doc.quote_status = 0));
1840: END IF;
1841:
1842: l_err_loc := 700;
1843: populateBPAandQuotes(l_bpa_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
1844:
1845: l_err_loc := 800;
1846: CLOSE l_bpa_quote_csr;
1847: EXCEPTION

Line 1849: ICX_CAT_UTIL_PVT.logUnexpectedException(

1845: l_err_loc := 800;
1846: CLOSE l_bpa_quote_csr;
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: ICX_CAT_UTIL_PVT.logUnexpectedException(
1850: G_PKG_NAME, l_api_name,
1851: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
1852: RAISE;
1853: END openR12UpgradeBPAQuoteCursor;

Line 2055: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

2051: l_ctx_ip_category_id_tbl,
2052: l_ctx_po_category_id_tbl,
2053: l_ctx_item_revision_tbl,
2054: l_ctx_rowid_tbl
2055: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
2056:
2057: l_err_loc := 300;
2058: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
2059:

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

2063: l_err_loc := 500;
2064: l_count := l_po_line_id_tbl.COUNT;
2065: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2066: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2067: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2068: 'Num. of rows returned from the cursor:' || l_count);
2069: END IF;
2070:
2071: l_row_count := l_row_count + l_count;

Line 2077: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND

2073: FOR i in 1..l_po_line_id_tbl.COUNT LOOP
2074: l_err_loc := 600;
2075: IF (l_source_type_tbl(i) = 'BLANKET') THEN
2076: --First get the status of the current BPA line
2077: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
2078: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
2079: THEN
2080: l_err_loc := 700;
2081: -- The GBPAs created for bulkload items will not be in approved

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

2074: l_err_loc := 600;
2075: IF (l_source_type_tbl(i) = 'BLANKET') THEN
2076: --First get the status of the current BPA line
2077: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const AND
2078: l_created_by_tbl(i) = ICX_CAT_UTIL_PVT.g_upgrade_user)
2079: THEN
2080: l_err_loc := 700;
2081: -- The GBPAs created for bulkload items will not be in approved
2082: -- status during upgrade, so treat them as valid during upgrade.

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

2082: -- status during upgrade, so treat them as valid during upgrade.
2083: l_podoc_status := ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE;
2084: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2085: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2086: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2087: 'bpa status is hard-coded to valid for' ||
2088: ', p_current_mode:' || p_current_mode ||
2089: ', l_created_by_tbl(i):' || l_created_by_tbl(i) );
2090: END IF;

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

2114: THEN
2115: l_err_loc := 1100;
2116: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2117: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2118: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2119: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2120: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2121: l_current_ctx_item_rec.language := l_language_tbl(i);
2122: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

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

2115: l_err_loc := 1100;
2116: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2117: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2118: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2119: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2120: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2121: l_current_ctx_item_rec.language := l_language_tbl(i);
2122: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2123: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

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

2119: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2120: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2121: l_current_ctx_item_rec.language := l_language_tbl(i);
2122: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2123: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
2124: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
2125: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
2126: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
2127: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

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

2171: l_err_loc := 1300;
2172: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2173:
2174: l_err_loc := 1400;
2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

2173:
2174: l_err_loc := 1400;
2175: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2181: 'Row #:' || i ||

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

2176: ELSE
2177: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2178: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2180: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2181: 'Row #:' || i ||
2182: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2183: ', l_source_type_tbl:' || l_source_type_tbl(i) ||
2184: ', l_approved_date_tbl:' || l_approved_date_tbl(i) ||

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

2197: END IF;
2198: END LOOP; --FOR LOOP of l_po_line_id_tbl
2199:
2200: l_err_loc := 1500;
2201: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2202: EXCEPTION
2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count

Line 2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

2199:
2200: l_err_loc := 1500;
2201: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2202: EXCEPTION
2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count
2206: ||', Cursor will be reopened;';
2207: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

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

2200: l_err_loc := 1500;
2201: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2202: EXCEPTION
2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count
2206: ||', Cursor will be reopened;';
2207: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2208: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

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

2203: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count
2206: ||', Cursor will be reopened;';
2207: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2208: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2209: --Closing and reopen of cursor will be done by called procedures
2210: l_err_loc := 1600;
2211: openR12UpgradeBPAQuoteCursor;

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

2204: l_err_string := ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name) || l_err_loc
2205: ||', Total processed batches:' ||l_batch_count
2206: ||', Cursor will be reopened;';
2207: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2208: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2209: --Closing and reopen of cursor will be done by called procedures
2210: l_err_loc := 1600;
2211: openR12UpgradeBPAQuoteCursor;
2212: ELSE

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

2215: END;
2216: END LOOP; --Cursor loop
2217:
2218: l_err_loc := 1800;
2219: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_BPACsr_const);
2220:
2221: l_err_loc := 1900;
2222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

2220:
2221: l_err_loc := 1900;
2222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2224: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2225: 'in mode:'|| p_current_mode ||' done; '||
2226: 'Total num. of batches processed:' ||l_batch_count ||
2227: ', Total num. of rows processed:' ||l_row_count);
2228: END IF;

Line 2231: ICX_CAT_UTIL_PVT.logUnexpectedException(

2227: ', Total num. of rows processed:' ||l_row_count);
2228: END IF;
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: ICX_CAT_UTIL_PVT.logUnexpectedException(
2232: G_PKG_NAME, l_api_name,
2233: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2234: RAISE;
2235: END populateBPAandQuotes;

Line 2262: ICX_CAT_UTIL_PVT.logUnexpectedException(

2258:
2259: l_err_loc := 500;
2260: EXCEPTION
2261: WHEN OTHERS THEN
2262: ICX_CAT_UTIL_PVT.logUnexpectedException(
2263: G_PKG_NAME, l_api_name,
2264: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;

Line 2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

2261: WHEN OTHERS THEN
2262: ICX_CAT_UTIL_PVT.logUnexpectedException(
2263: G_PKG_NAME, l_api_name,
2264: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2267: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2268: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2269: RAISE;

Line 2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;

2262: ICX_CAT_UTIL_PVT.logUnexpectedException(
2263: G_PKG_NAME, l_api_name,
2264: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2267: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2268: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2269: RAISE;
2270: END upgradeR12PODocs;

Line 2267: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;

2263: G_PKG_NAME, l_api_name,
2264: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2267: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2268: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2269: RAISE;
2270: END upgradeR12PODocs;
2271:

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

2264: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2265: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
2266: ICX_CAT_UTIL_PVT.g_job_bpa_complete_date := NULL;
2267: ICX_CAT_UTIL_PVT.g_job_quote_complete_date := NULL;
2268: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
2269: RAISE;
2270: END upgradeR12PODocs;
2271:
2272: ----------------------------------------------------------------------

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

2285: BEGIN
2286: l_err_loc := 100;
2287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2289: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2290: 'Processing cursor:' || l_api_name ||
2291: ', p_key:' || p_key ||
2292: ', p_po_line_id:' || p_po_line_id );
2293: END IF;

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

2385: -- AND (ctx.rowid IS NOT NULL OR doc.status = 0)
2386: ORDER BY doc.po_line_id;
2387:
2388: l_err_loc := 500;
2389: populateQuotes(l_quote_csr, ICX_CAT_UTIL_PVT.g_online_const);
2390:
2391: l_err_loc := 600;
2392: CLOSE l_quote_csr;
2393: EXCEPTION

Line 2395: ICX_CAT_UTIL_PVT.logUnexpectedException(

2391: l_err_loc := 600;
2392: CLOSE l_quote_csr;
2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: ICX_CAT_UTIL_PVT.logUnexpectedException(
2396: G_PKG_NAME, l_api_name,
2397: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2398: RAISE;
2399: END openQuotesCursor;

Line 2401: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

2397: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2398: RAISE;
2399: END openQuotesCursor;
2400:
2401: -- l_quote_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
2402: PROCEDURE populateQuotes
2403: ( p_podocs_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
2404: p_current_mode IN VARCHAR2
2405: )

Line 2563: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

2559: l_ctx_ip_category_id_tbl,
2560: l_ctx_po_category_id_tbl,
2561: l_ctx_item_revision_tbl,
2562: l_ctx_rowid_tbl
2563: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
2564: l_err_loc := 400;
2565:
2566: EXIT WHEN l_po_line_id_tbl.COUNT = 0;
2567:

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

2571: l_err_loc := 600;
2572: l_count := l_po_line_id_tbl.COUNT;
2573: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2574: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2575: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2576: 'Num. of rows returned from the cursor:' || l_count);
2577: END IF;
2578:
2579: --Save the last po_line_id processed, so that re-open of cursor will start from the saved id.

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

2588: THEN
2589: l_err_loc := 800;
2590: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2591: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2592: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2593: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2594: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2595: l_current_ctx_item_rec.language := l_language_tbl(i);
2596: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);

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

2589: l_err_loc := 800;
2590: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
2591: l_current_ctx_item_rec.po_line_id := l_po_line_id_tbl(i);
2592: l_current_ctx_item_rec.req_template_name := TO_CHAR(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2593: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2594: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2595: l_current_ctx_item_rec.language := l_language_tbl(i);
2596: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2597: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;

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

2593: l_current_ctx_item_rec.req_template_line_num := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
2594: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
2595: l_current_ctx_item_rec.language := l_language_tbl(i);
2596: l_current_ctx_item_rec.source_type := l_source_type_tbl(i);
2597: l_current_ctx_item_rec.item_type := ICX_CAT_UTIL_PVT.g_purchase_item_type;
2598: l_current_ctx_item_rec.purchasing_org_id := l_purchasing_org_id_tbl(i);
2599: l_current_ctx_item_rec.owning_org_id := l_org_id_tbl(i);
2600: l_current_ctx_item_rec.po_category_id := l_po_category_id_tbl(i);
2601: l_current_ctx_item_rec.supplier_id := l_supplier_id_tbl(i);

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

2646: l_err_loc := 900;
2647: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
2648:
2649: l_err_loc := 1000;
2650: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2651: ELSE
2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2649: l_err_loc := 1000;
2650: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2651: ELSE
2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2656: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2657: 'Row #:' || i ||

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

2652: l_err_loc := 1100;
2653: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2656: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2657: 'Row #:' || i ||
2658: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2659: ', status: ' || l_status_tbl(i));
2660: END IF;

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

2660: END IF;
2661: ELSE
2662: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2663: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2664: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2665: 'Row #:' || i ||
2666: ', with po_line_id:' || l_po_line_id_tbl(i) ||', not processed' ||
2667: ', status: ' || l_status_tbl(i));
2668: END IF;

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

2670: END IF;
2671: END LOOP; --FOR LOOP of l_po_line_id_tbl
2672:
2673: l_err_loc := 1200;
2674: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2675: EXCEPTION
2676: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2677: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2678: ||', Total processed batches:' ||l_batch_count

Line 2676: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

2672:
2673: l_err_loc := 1200;
2674: EXIT WHEN l_po_line_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
2675: EXCEPTION
2676: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2677: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2678: ||', Total processed batches:' ||l_batch_count
2679: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2680: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

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

2676: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
2677: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2678: ||', Total processed batches:' ||l_batch_count
2679: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2680: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2681: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2682: --Closing and reopen of cursor will be done by called procedures
2683: openQuotesCursor(g_key, l_start_po_line_id);
2684: ELSE

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

2677: l_err_string := 'ICX_CAT_POPULATE_PODOCS_PVT.populateQuotes' ||l_err_loc
2678: ||', Total processed batches:' ||l_batch_count
2679: ||', Cursor will be reopened with po_line_id:' ||l_start_po_line_id;
2680: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
2681: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
2682: --Closing and reopen of cursor will be done by called procedures
2683: openQuotesCursor(g_key, l_start_po_line_id);
2684: ELSE
2685: RAISE;

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

2687: END;
2688: END LOOP; --Cursor loop
2689:
2690: l_err_loc := 1500;
2691: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_QuoteCsr_const);
2692:
2693: l_err_loc := 1600;
2694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

2692:
2693: l_err_loc := 1600;
2694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2696: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2697: 'populateQuotes in mode:'|| p_current_mode ||' done; '||
2698: 'Total num. of batches processed:' ||l_batch_count ||
2699: ', Total num. of rows processed:' ||l_row_count);
2700: END IF;

Line 2703: ICX_CAT_UTIL_PVT.logUnexpectedException(

2699: ', Total num. of rows processed:' ||l_row_count);
2700: END IF;
2701: EXCEPTION
2702: WHEN OTHERS THEN
2703: ICX_CAT_UTIL_PVT.logUnexpectedException(
2704: G_PKG_NAME, l_api_name,
2705: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2706: RAISE;
2707: END populateQuotes;

Line 2718: ICX_CAT_UTIL_PVT.setBatchSize;

2714: l_err_loc PLS_INTEGER;
2715: BEGIN
2716: l_err_loc := 100;
2717: -- Set the batch_size
2718: ICX_CAT_UTIL_PVT.setBatchSize;
2719:
2720: l_err_loc := 200;
2721: -- Set the who columns
2722: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 2722: ICX_CAT_UTIL_PVT.setWhoColumns(null);

2718: ICX_CAT_UTIL_PVT.setBatchSize;
2719:
2720: l_err_loc := 200;
2721: -- Set the who columns
2722: ICX_CAT_UTIL_PVT.setWhoColumns(null);
2723:
2724: l_err_loc := 300;
2725: g_key := p_key;
2726:

Line 2729: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

2725: g_key := p_key;
2726:
2727: l_err_loc := 350;
2728: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
2730: END IF;
2731:
2732: l_err_loc := 400;
2733: openQuotesCursor(p_key, 0);

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

2736: g_metadataTblFormed := FALSE;
2737: g_CtxSqlForPODocsFormed := FALSE;
2738:
2739: l_err_loc := 600;
2740: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
2741:
2742: l_err_loc := 700;
2743: EXCEPTION
2744: WHEN OTHERS THEN

Line 2745: ICX_CAT_UTIL_PVT.logUnexpectedException(

2741:
2742: l_err_loc := 700;
2743: EXCEPTION
2744: WHEN OTHERS THEN
2745: ICX_CAT_UTIL_PVT.logUnexpectedException(
2746: G_PKG_NAME, l_api_name,
2747: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2748: RAISE;
2749: END populateOnlineQuotes;

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

2764: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_metadataTblFormed) THEN
2765: l_err_loc := 200;
2766: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2767: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2768: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2769: 'about to call buildmetadatinfo');
2770: END IF;
2771:
2772: l_err_loc := 200;

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

2781: IF (NOT ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed) THEN
2782: l_err_loc := 500;
2783: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2784: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2785: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2786: 'about to call buildctxsql');
2787: END IF;
2788:
2789: l_err_loc := 600;

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

2787: END IF;
2788:
2789: l_err_loc := 600;
2790: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
2791: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'NOTROWID', g_special_metadata_tbl,
2792: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
2793: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
2794: ICX_CAT_POPULATE_PODOCS_PVT.g_CtxSqlForPODocsFormed := TRUE;
2795: END IF;

Line 2805: ICX_CAT_UTIL_PVT.logUnexpectedException(

2801: l_err_loc := 800;
2802:
2803: EXCEPTION
2804: WHEN OTHERS THEN
2805: ICX_CAT_UTIL_PVT.logUnexpectedException(
2806: G_PKG_NAME, l_api_name,
2807: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
2808: RAISE;
2809: END buildCtxSqlForPODocs;