[Home] [Help]
1: PACKAGE BODY GMP_BOM_ROUTING_PKG AS
2: /* $Header: GMPBMRTB.pls 120.67.12020000.13 2013/05/15 10:19:35 vkinduri ship $ */
3:
4: /*
5: REM+==========================================================================+
6164: log_message('Effectivity export failed');
6165: return_status := FALSE;
6166:
6167: WHEN NO_DATA_FOUND THEN /* B3577871 */
6168: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_bom_routing_pkg.Extract_effectivities ' );
6169: return_status := TRUE;
6170: WHEN OTHERS THEN
6171: log_message('Untrapped effectivity extraction error');
6172: log_message(sqlerrm);
7886:
7887: RETURN -1;
7888:
7889: EXCEPTION WHEN OTHERS THEN
7890: log_message(' Error in gmp_bom_routing_pkg.enh_bsearch_stpno: '||SQLERRM);
7891: RETURN -1;
7892: END enh_bsearch_stpno ;
7893:
7894:
8122: WHEN invalid_string_value THEN
8123: log_message('Organization string is Invalid ' );
8124: return_status := FALSE;
8125: WHEN NO_DATA_FOUND THEN /* B3577871 */
8126: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_bom_routing_pkg.Extract_Items ' );
8127: return_status := TRUE;
8128: WHEN OTHERS THEN
8129: log_message('Item extraction failed with error '||sqlerrm);
8130: return_status := FALSE;
8148: uom_code_dblink VARCHAR2(32767) ; /* bug: 6710684 Vpedarla */
8149: uom_code_ref ref_cursor_typ ;
8150: l_gmp_um_code VARCHAR2(32767);
8151: BEGIN
8152: LOG_MESSAGE(' GMP_BOM_ROUTING_PKG.get_profile_value called for profile '||profile_name||' with dblink '||pdblink);
8153:
8154: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';
8155:
8156: OPEN uom_code_ref for uom_code_dblink ;
8216: LOG_MESSAGE(pBUFF);
8217: END IF;
8218: END gmp_debug_message;
8219:
8220: END GMP_BOM_ROUTING_PKG;