[Home] [Help]
1: PACKAGE BODY GMP_BOM_ROUTING_PKG AS
2: /* $Header: GMPBMRTB.pls 120.32.12010000.2 2008/11/01 21:53:57 rpatangy ship $ */
3:
4: /*
5: REM+==========================================================================+
5624: log_message('Effectivity export failed');
5625: return_status := FALSE;
5626:
5627: WHEN NO_DATA_FOUND THEN /* B3577871 */
5628: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_bom_routing_pkg.Extract_effectivities ' );
5629: return_status := TRUE;
5630: WHEN OTHERS THEN
5631: log_message('Untrapped effectivity extraction error');
5632: log_message(sqlerrm);
7091:
7092: RETURN -1;
7093:
7094: EXCEPTION WHEN OTHERS THEN
7095: log_message(' Error in gmp_bom_routing_pkg.enh_bsearch_stpno: '||SQLERRM);
7096: RETURN -1;
7097: END enh_bsearch_stpno ;
7098:
7099:
7327: WHEN invalid_string_value THEN
7328: log_message('Organization string is Invalid ' );
7329: return_status := FALSE;
7330: WHEN NO_DATA_FOUND THEN /* B3577871 */
7331: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_bom_routing_pkg.Extract_Items ' );
7332: return_status := TRUE;
7333: WHEN OTHERS THEN
7334: log_message('Item extraction failed with error '||sqlerrm);
7335: return_status := FALSE;
7353: uom_code_dblink VARCHAR2(32767) ; /* bug: 6710684 Vpedarla */
7354: uom_code_ref ref_cursor_typ ;
7355: l_gmp_um_code VARCHAR2(32767);
7356: BEGIN
7357: LOG_MESSAGE(' GMP_BOM_ROUTING_PKG.get_profile_value called for profile '||profile_name||' with dblink '||pdblink);
7358:
7359: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';
7360:
7361: OPEN uom_code_ref for uom_code_dblink ;
7363: CLOSE uom_code_ref;
7364: RETURN l_gmp_um_code ;
7365: END get_profile_value;
7366:
7367: END GMP_BOM_ROUTING_PKG;