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_REQTMPL_PVT dependencies on ICX_CAT_UTIL_PVT

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

16: BEGIN
17: l_err_loc := 100;
18: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
20: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
21: 'Processing cursor:' || l_api_name ||
22: ', g_upgrade_last_run_date:' || g_upgrade_last_run_date ||
23: ', g_start_rowid:' || g_start_rowid ||
24: ', g_end_rowid:' || g_end_rowid );

Line 247: populateReqTemplates(l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);

243: AND doc.language = ctx.language (+);
244: END IF;
245:
246: l_err_loc := 700;
247: populateReqTemplates(l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);
248:
249: l_err_loc := 800;
250: CLOSE l_reqTemplate_csr;
251:

Line 255: ICX_CAT_UTIL_PVT.logUnexpectedException(

251:
252: l_err_loc := 900;
253: EXCEPTION
254: WHEN OTHERS THEN
255: ICX_CAT_UTIL_PVT.logUnexpectedException(
256: G_PKG_NAME, l_api_name,
257: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
258: RAISE;
259: END openR12UpgradeReqTmpltsCursor;

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

268: BEGIN
269: l_err_loc := 100;
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
272: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
273: 'Processing cursor:' || l_api_name ||
274: ', p_key:' || p_key );
275: END IF;
276:

Line 385: populateReqTemplates(l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_online_const);

381: AND doc.org_id = ctx.org_id (+)
382: AND doc.language = ctx.language (+);
383:
384: l_err_loc := 500;
385: populateReqTemplates(l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_online_const);
386:
387: l_err_loc := 600;
388: CLOSE l_reqTemplate_csr;
389:

Line 393: ICX_CAT_UTIL_PVT.logUnexpectedException(

389:
390: l_err_loc := 700;
391: EXCEPTION
392: WHEN OTHERS THEN
393: ICX_CAT_UTIL_PVT.logUnexpectedException(
394: G_PKG_NAME, l_api_name,
395: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
396: RAISE;
397: END openReqTmpltsCursor;

Line 399: -- l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

395: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
396: RAISE;
397: END openReqTmpltsCursor;
398:
399: -- l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
400: PROCEDURE populateReqTemplates
401: ( p_reqTemplate_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
402: p_current_mode IN VARCHAR2
403: )

Line 607: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

603: l_ctx_ip_category_id_tbl,
604: l_ctx_po_category_id_tbl,
605: l_ctx_item_revision_tbl,
606: l_ctx_rowid_tbl
607: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;
608: l_err_loc := 400;
609: EXIT WHEN l_inv_item_id_tbl.COUNT = 0;
610:
611: l_err_loc := 500;

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

614: l_err_loc := 600;
615: l_count := l_inv_item_id_tbl.COUNT;
616: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
618: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
619: 'Num. of rows returned from the cursor:' || l_count);
620: END IF;
621: l_row_count := l_row_count + l_count;
622:

Line 648: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);

644: l_ReqTmplt_line_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE)
645: THEN
646: l_err_loc := 1100;
647: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
648: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);
649: l_current_ctx_item_rec.req_template_name := l_req_template_name_tbl(i);
650: l_current_ctx_item_rec.req_template_line_num := l_req_template_line_num_tbl(i);
651: l_current_ctx_item_rec.org_id := l_org_id_tbl(i);
652: l_current_ctx_item_rec.language := l_language_tbl(i);

Line 707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);

703: l_err_loc := 1200;
704: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
705:
706: l_err_loc := 1300;
707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

705:
706: l_err_loc := 1300;
707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
712: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
713: 'Row #:' || i ||

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

708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
712: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
713: 'Row #:' || i ||
714: ', with req_template_line:(' || l_req_template_name_tbl(i) ||
715: ', ' || l_req_template_line_num_tbl(i) ||
716: ', ' || l_org_id_tbl(i) ||'), not processed' ||

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

730: END IF;
731: ELSE
732: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
734: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
735: 'Row #:' || i ||
736: ', with req_template_line:(' || l_req_template_name_tbl(i) ||
737: ', ' || l_req_template_line_num_tbl(i) ||
738: ', ' || l_org_id_tbl(i) ||'), not processed' ||

Line 758: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;

754: END IF;
755: END LOOP; --FOR LOOP of l_inv_item_id_tbl
756:
757: l_err_loc := 1400;
758: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
759: EXCEPTION
760: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc
762: ||', Total processeded batches:' ||l_batch_count

Line 760: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

756:
757: l_err_loc := 1400;
758: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
759: EXCEPTION
760: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc
762: ||', Total processeded batches:' ||l_batch_count
763: ||', Cursor will be reopened with TBD TBD:' ;
764: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

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

760: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc
762: ||', Total processeded batches:' ||l_batch_count
763: ||', Cursor will be reopened with TBD TBD:' ;
764: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
765: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
766: --Closing and reopen of cursor will be done by called procedures
767: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
768: l_err_loc := 1500;

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

761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc
762: ||', Total processeded batches:' ||l_batch_count
763: ||', Cursor will be reopened with TBD TBD:' ;
764: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
765: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
766: --Closing and reopen of cursor will be done by called procedures
767: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
768: l_err_loc := 1500;
769: openR12UpgradeReqTmpltsCursor;

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

763: ||', Cursor will be reopened with TBD TBD:' ;
764: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
765: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
766: --Closing and reopen of cursor will be done by called procedures
767: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
768: l_err_loc := 1500;
769: openR12UpgradeReqTmpltsCursor;
770: ELSE
771: l_err_loc := 1600;

Line 781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);

777: END;
778: END LOOP; --Cursor loop
779:
780: l_err_loc := 1700;
781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
782:
783: l_err_loc := 1800;
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

782:
783: l_err_loc := 1800;
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
786: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
787: 'populateReqTemplates done; '||
788: 'Total num. of batches processed:' ||l_batch_count ||
789: ', Total num. of rows processed:' ||l_row_count);
790: END IF;

Line 794: ICX_CAT_UTIL_PVT.logUnexpectedException(

790: END IF;
791: l_err_loc := 1900;
792: EXCEPTION
793: WHEN OTHERS THEN
794: ICX_CAT_UTIL_PVT.logUnexpectedException(
795: G_PKG_NAME, l_api_name,
796: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
797: RAISE;
798: END populateReqTemplates;

Line 822: ICX_CAT_UTIL_PVT.logUnexpectedException(

818:
819: l_err_loc := 400;
820: EXCEPTION
821: WHEN OTHERS THEN
822: ICX_CAT_UTIL_PVT.logUnexpectedException(
823: G_PKG_NAME, l_api_name,
824: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
825: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;
826: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

Line 825: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;

821: WHEN OTHERS THEN
822: ICX_CAT_UTIL_PVT.logUnexpectedException(
823: G_PKG_NAME, l_api_name,
824: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
825: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;
826: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
827: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
828: RAISE;
829: END upgradeR12ReqTemplates;

Line 826: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

822: ICX_CAT_UTIL_PVT.logUnexpectedException(
823: G_PKG_NAME, l_api_name,
824: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
825: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;
826: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
827: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
828: RAISE;
829: END upgradeR12ReqTemplates;
830:

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

823: G_PKG_NAME, l_api_name,
824: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
825: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;
826: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;
827: ICX_CAT_UTIL_PVT.g_job_current_status := ICX_CAT_UTIL_PVT.g_job_failed_status;
828: RAISE;
829: END upgradeR12ReqTemplates;
830:
831: PROCEDURE populateOnlineReqTemplates

Line 840: ICX_CAT_UTIL_PVT.setBatchSize;

836: l_err_loc PLS_INTEGER;
837: BEGIN
838: l_err_loc := 100;
839: -- Set the batch_size
840: ICX_CAT_UTIL_PVT.setBatchSize;
841:
842: l_err_loc := 200;
843: -- Set the who columns
844: ICX_CAT_UTIL_PVT.setWhoColumns(null);

Line 844: ICX_CAT_UTIL_PVT.setWhoColumns(null);

840: ICX_CAT_UTIL_PVT.setBatchSize;
841:
842: l_err_loc := 200;
843: -- Set the who columns
844: ICX_CAT_UTIL_PVT.setWhoColumns(null);
845:
846: l_err_loc := 300;
847: g_key := p_key;
848:

Line 851: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

847: g_key := p_key;
848:
849: l_err_loc := 350;
850: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);
852: END IF;
853:
854: l_err_loc := 400;
855: openReqTmpltsCursor(p_key);

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

854: l_err_loc := 400;
855: openReqTmpltsCursor(p_key);
856:
857: l_err_loc := 500;
858: ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxCatgAtt(ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id);
859:
860: l_err_loc := 600;
861: g_metadataTblFormed := FALSE;
862: g_CtxSqlForPODocsFormed := FALSE;

Line 867: ICX_CAT_UTIL_PVT.logUnexpectedException(

863:
864: l_err_loc := 700;
865: EXCEPTION
866: WHEN OTHERS THEN
867: ICX_CAT_UTIL_PVT.logUnexpectedException(
868: G_PKG_NAME, l_api_name,
869: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
870: RAISE;
871: END populateOnlineReqTemplates;

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

881: l_err_loc := 100;
882: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
886: 'about to call buildmetadatinfo');
887: END IF;
888:
889: l_err_loc := 200;

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

897: l_err_loc := 400;
898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN
899: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
901: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
902: 'about to call buildctxsql');
903: END IF;
904:
905: l_err_loc := 500;

Line 907: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'NOTROWID', g_special_metadata_tbl,

903: END IF;
904:
905: l_err_loc := 500;
906: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
907: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'NOTROWID', g_special_metadata_tbl,
908: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
909: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
910:
911: l_err_loc := 600;

Line 922: ICX_CAT_UTIL_PVT.logUnexpectedException(

918:
919: l_err_loc := 800;
920: EXCEPTION
921: WHEN OTHERS THEN
922: ICX_CAT_UTIL_PVT.logUnexpectedException(
923: G_PKG_NAME, l_api_name,
924: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
925: RAISE;
926: END buildCtxSqlForRTs;