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 249: populateReqTemplates(l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const);

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

Line 257: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

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

Line 396: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

Line 402: -- l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const

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

Line 610: LIMIT ICX_CAT_UTIL_PVT.g_batch_size;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 763: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN

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

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

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

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

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

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

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

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

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

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

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

Line 797: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

Line 825: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

Line 828: ICX_CAT_UTIL_PVT.g_job_reqtmplt_complete_date := NULL;

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

Line 829: ICX_CAT_UTIL_PVT.g_job_complete_date := NULL;

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

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

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

Line 843: ICX_CAT_UTIL_PVT.setBatchSize;

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

Line 847: ICX_CAT_UTIL_PVT.setWhoColumns(null);

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

Line 854: ICX_CAT_UTIL_PVT.logPOSessionGTData(p_key);

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

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

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

Line 870: ICX_CAT_UTIL_PVT.logUnexpectedException(

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

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

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

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

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

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

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

Line 925: ICX_CAT_UTIL_PVT.logUnexpectedException(

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