APPS.ICX_POR_CTX_DESC dependencies on ICX_POR_CTX_DESC

Line 1: PACKAGE BODY ICX_POR_CTX_DESC AS

1: PACKAGE BODY ICX_POR_CTX_DESC AS
2: -- $Header: ICXCGCDB.pls 115.22 2004/07/14 13:17:41 sosingha ship $
3:
4: -- Previous releases of iProcurement had p_rebuildAll meaning, to rebuild
5: -- ctx column for all language or just the language for which item was

Line 110: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||

106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: icx_por_ext_utl.debug(icx_por_ext_utl.DEBUG_LEVEL,
110: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||
111: xErrLoc || '), ' || SQLERRM);
112: rollback;
113: ICX_POR_EXT_UTL.printStackTrace;
114: ICX_POR_EXT_UTL.closeLog;

Line 121: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||xErrLoc|| '), '||SQLERRM );

117: CLOSE items_tl_cv;
118: END IF;
119:
120: RAISE_APPLICATION_ERROR (-20000,
121: 'Exception at ICX_POR_CTX_DESC.populateCtxDescAll('||xErrLoc|| '), '||SQLERRM );
122: END populateCtxDescAll;
123:
124: PROCEDURE populateDescAll(errbuf OUT NOCOPY VARCHAR2,
125: retcode OUT NOCOPY VARCHAR2,

Line 248: 'Exception at ICX_POR_CTX_DESC.populateBaseAttributes('||xErrLoc|| '), '||SQLERRM );

244: CLOSE items_tl_csr;
245: END IF;
246:
247: RAISE_APPLICATION_ERROR (-20000,
248: 'Exception at ICX_POR_CTX_DESC.populateBaseAttributes('||xErrLoc|| '), '||SQLERRM );
249:
250: END populateBaseAttributes;
251:
252: PROCEDURE populateCategoryAttribsByJob( pJobNum IN INTEGER DEFAULT 0,

Line 340: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttribsByJob('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );

336: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
337: END IF;
338:
339: RAISE_APPLICATION_ERROR (-20000,
340: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttribsByJob('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );
341: END populateCategoryAttribsByJob;
342:
343: PROCEDURE populateCategoryAttributes( pDeleteYN IN VARCHAR2 DEFAULT 'Y',
344: pUpdateYN IN VARCHAR2 DEFAULT 'Y',

Line 423: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttributes('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );

419: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
420: END IF;
421:
422: RAISE_APPLICATION_ERROR (-20000,
423: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttributes('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );
424: END populateCategoryAttributes;
425:
426: /* The calling procedure is responsible for opening and closing the cursor*/
427: PROCEDURE populateCtxDescBaseAtt(pItemSourceCv IN item_source_cv_type,

Line 552: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBaseAtt('||xErrLoc||

548: DBMS_SQL.CLOSE_CURSOR(c_handle);
549: END IF;
550:
551: RAISE_APPLICATION_ERROR (-20000,
552: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBaseAtt('||xErrLoc||
553: '), '||SQLERRM );
554: END populateCtxDescBaseAtt;
555:
556: /* The calling procedure is responsible for opening and closing the cursor.

Line 755: 'Exception at ICX_POR_CTX_DESC.populateCtxDescCatAtt('||xErrLoc||

751: DBMS_SQL.CLOSE_CURSOR(c_handle);
752: END IF;
753:
754: RAISE_APPLICATION_ERROR (-20000,
755: 'Exception at ICX_POR_CTX_DESC.populateCtxDescCatAtt('||xErrLoc||
756: '), '||SQLERRM );
757: END populateCtxDescCatAtt;
758: /*
759: ** -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Line 904: 'Exception at ICX_POR_CTX_DESC.populateCtxDescLang('||xErrLoc||

900: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
901: END IF;
902:
903: RAISE_APPLICATION_ERROR (-20000,
904: 'Exception at ICX_POR_CTX_DESC.populateCtxDescLang('||xErrLoc||
905: '), '||SQLERRM );
906: END populateCtxDescLang;
907:
908: -- sosingha Bug#3460478: 10g fix for getting the major and minor db version

Line 978: 'Exception at ICX_POR_CTX_DESC.rebuild_indexes(' ||

974:
975: EXCEPTION
976: WHEN OTHERS THEN
977: RAISE_APPLICATION_ERROR(-20000,
978: 'Exception at ICX_POR_CTX_DESC.rebuild_indexes(' ||
979: xErrLoc||'), '|| SQLERRM || ' #### VARIABLES ####' ||
980: ' versionString = ' || versionString ||
981: ' majorVersion = ' || majorVersion ||
982: ' minorVersion = ' || minorVersion ||

Line 1026: 'Exception at ICX_POR_CTX_DESC.populateBuyerInfo('||xErrLoc||'

1022: CLOSE getItemsTlCur;
1023: END IF;
1024:
1025: RAISE_APPLICATION_ERROR (-20000,
1026: 'Exception at ICX_POR_CTX_DESC.populateBuyerInfo('||xErrLoc||'
1027: ), '||SQLERRM );
1028: END populateBuyerInfo;
1029:
1030: /* The calling procedure is responsible for opening and closing the cursor*/

Line 1135: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBuyerInfo('||xErrLoc || '), '||SQLERRM );

1131: DBMS_SQL.CLOSE_CURSOR(c_handle);
1132: END IF;
1133:
1134: RAISE_APPLICATION_ERROR (-20000,
1135: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBuyerInfo('||xErrLoc || '), '||SQLERRM );
1136: END populateCtxDescBuyerInfo;
1137:
1138:
1139: END ICX_POR_CTX_DESC;

Line 1139: END ICX_POR_CTX_DESC;

1135: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBuyerInfo('||xErrLoc || '), '||SQLERRM );
1136: END populateCtxDescBuyerInfo;
1137:
1138:
1139: END ICX_POR_CTX_DESC;