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.MSC_CL_GMP_UTILITY dependencies on MSC_CL_GMP_UTILITY

Line 1: PACKAGE BODY MSC_CL_GMP_UTILITY as --body

1: PACKAGE BODY MSC_CL_GMP_UTILITY as --body
2: /* $Header: MSCCLGMB.pls 120.0.12010000.3 2008/08/18 07:06:26 sbyerram ship $ */
3:
4:
5: /*======== GLOBAL OPM Data Collection Declaration =========*/

Line 1449: IF MSC_CL_GMP_UTILITY.org_string(g_instance_id) THEN

1445:
1446: dbms_session.free_unused_user_memory;/* akaruppa B5007729 */
1447:
1448: /* populate the org_string */
1449: IF MSC_CL_GMP_UTILITY.org_string(g_instance_id) THEN
1450: NULL ;
1451: ELSE
1452: log_message(MSC_CL_GMP_UTILITY.g_in_str_org);
1453: RAISE invalid_string_value ;

Line 1452: log_message(MSC_CL_GMP_UTILITY.g_in_str_org);

1448: /* populate the org_string */
1449: IF MSC_CL_GMP_UTILITY.org_string(g_instance_id) THEN
1450: NULL ;
1451: ELSE
1452: log_message(MSC_CL_GMP_UTILITY.g_in_str_org);
1453: RAISE invalid_string_value ;
1454: END IF;
1455:
1456: -- l_in_str_org := 'IN (1381,1382,1383,1383,5172)' ;

Line 1457: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* B3491625 */

1453: RAISE invalid_string_value ;
1454: END IF;
1455:
1456: -- l_in_str_org := 'IN (1381,1382,1383,1383,5172)' ;
1457: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* B3491625 */
1458:
1459: /*B2870041 changed cursor to retrieve the just the routing qty no uom conv,
1460: added uom conv of the product to the routing uom for a qty of 1 to get the
1461: factor. The factor will be used later. added product index to allow access

Line 5656: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Extract_effectivities ' );

5652: log_message('Effectivity export failed');
5653: return_status := FALSE;
5654:
5655: WHEN NO_DATA_FOUND THEN /* B3577871 */
5656: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Extract_effectivities ' );
5657: return_status := TRUE;
5658: WHEN OTHERS THEN
5659: log_message('Untrapped effectivity extraction error');
5660: log_message(sqlerrm);

Line 5768: IF MSC_CL_GMP_UTILITY.org_string(instance) THEN

5764: v_cp_enabled := FALSE;
5765: END IF;
5766:
5767: /* populate the org_string */
5768: IF MSC_CL_GMP_UTILITY.org_string(instance) THEN
5769: NULL ;
5770: ELSE
5771: RAISE invalid_string_value ;
5772: END IF;

Line 5774: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* 3491625 */

5770: ELSE
5771: RAISE invalid_string_value ;
5772: END IF;
5773:
5774: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* 3491625 */
5775:
5776: retrieval_cursor := 'DELETE FROM gmp_item_aps'||at_apps_link;
5777: EXECUTE IMMEDIATE retrieval_cursor;
5778:

Line 5917: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Extract_Items ' );

5913: WHEN invalid_string_value THEN
5914: log_message('Organization string is Invalid ' );
5915: return_status := FALSE;
5916: WHEN NO_DATA_FOUND THEN /* B3577871 */
5917: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Extract_Items ' );
5918: return_status := TRUE;
5919: WHEN OTHERS THEN
5920: log_message('Item extraction failed with error '||sqlerrm);
5921: return_status := FALSE;

Line 5991: IF MSC_CL_GMP_UTILITY.org_string(instance) THEN

5987: v_cp_enabled := FALSE;
5988: END IF;
5989:
5990: /* populate the org_string */
5991: IF MSC_CL_GMP_UTILITY.org_string(instance) THEN
5992: NULL ;
5993: ELSE
5994: RAISE invalid_string_value ;
5995: END IF;

Line 5997: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* B3491625 */

5993: ELSE
5994: RAISE invalid_string_value ;
5995: END IF;
5996:
5997: l_in_str_org := MSC_CL_GMP_UTILITY.g_in_str_org ; /* B3491625 */
5998:
5999: /* New Changes - Using mtl_organization_id from ic_whse_mst , instead of
6000: organization_id from sy_orgn_mst , Bug# 1252322 */
6001:

Line 7582: log_message(' Error in MSC_CL_GMP_UTILITY.enh_bsearch_stpno: '||SQLERRM);

7578:
7579: RETURN -1;
7580:
7581: EXCEPTION WHEN OTHERS THEN
7582: log_message(' Error in MSC_CL_GMP_UTILITY.enh_bsearch_stpno: '||SQLERRM);
7583: RETURN -1;
7584: END enh_bsearch_stpno ;
7585:
7586: /*

Line 8090: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN

8086: v_cp_enabled := FALSE;
8087: END IF;
8088:
8089: /* populate the org_string */
8090: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN
8091: NULL ;
8092: ELSE
8093: RAISE invalid_string_value ;
8094: END IF;

Line 8378: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

8374: || ' AND uom2.unit_of_measure = r.step_qty_uom '
8375: || ' AND c.delete_mark = 0 '
8376: || ' AND nvl(c.inactive_ind,0) = 0 ' ;
8377:
8378: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
8379: v_rsrc_cursor := v_rsrc_cursor
8380: ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '
8381: ||' WHERE h.wip_whse_code = som.resource_whse_code )' ;
8382: END IF;

Line 8450: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

8446: ||' AND crd.resources = gbsc.resources '
8447: ||' AND h.wip_whse_code = iwm.whse_code'
8448: ||' AND gbs.step_status in (1, 2) ';
8449:
8450: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
8451: stp_chg_cursor := stp_chg_cursor
8452: ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '
8453: ||' WHERE h.wip_whse_code = som.resource_whse_code )' ;
8454: END IF;

Line 9594: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

9590: ||' AND som.delete_mark = 0 '
9591: ||' AND som.resource_whse_code = iwm.whse_code ' ;
9592:
9593:
9594: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
9595: sql_stmt := sql_stmt
9596: ||' AND iwm.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
9597: END IF;
9598:

Line 9596: ||' AND iwm.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

9592:
9593:
9594: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
9595: sql_stmt := sql_stmt
9596: ||' AND iwm.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
9597: END IF;
9598:
9599: EXECUTE IMMEDIATE sql_stmt USING pinstance_id;
9600: /* NAVIN: ------------ END: Complex Route -- Collect Batch Step Dependencies in one insert-select ------------*/

Line 9940: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Production_orders ' );

9936: log_message('Profile "GMP: UOM for Hour" is Invalid ' );
9937: return_status := FALSE;
9938:
9939: WHEN NO_DATA_FOUND THEN /* B3577871 */
9940: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Production_orders ' );
9941: return_status := TRUE;
9942:
9943: WHEN OTHERS THEN
9944: return_status := FALSE;

Line 10305: log_message(' extract_onhand_balances_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );

10301: END IF;
10302:
10303: EXCEPTION
10304: WHEN onhand_balances_failure THEN
10305: log_message(' extract_onhand_balances_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10306: return_status := FALSE;
10307: WHEN inv_transfer_failure THEN
10308: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10309: return_status := FALSE;

Line 10308: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );

10304: WHEN onhand_balances_failure THEN
10305: log_message(' extract_onhand_balances_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10306: return_status := FALSE;
10307: WHEN inv_transfer_failure THEN
10308: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10309: return_status := FALSE;
10310: WHEN NO_DATA_FOUND THEN /* B3577871 */
10311: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10312: return_status := TRUE;

Line 10311: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );

10307: WHEN inv_transfer_failure THEN
10308: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10309: return_status := FALSE;
10310: WHEN NO_DATA_FOUND THEN /* B3577871 */
10311: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Onhand_inventory ' );
10312: return_status := TRUE;
10313:
10314: END onhand_inventory; /* end onhand_inventory */
10315:

Line 11184: MSC_CL_GMP_UTILITY.extract_items(

11180: BEGIN
11181:
11182: lv_cp_enabled := p_cp_enabled;
11183:
11184: MSC_CL_GMP_UTILITY.extract_items(
11185: at_apps_link => NULL,
11186: instance => NULL,
11187: run_date => p_run_date,
11188: return_status => lv_cp_enabled );

Line 11305: log_message('Start MSC_CL_GMP_UTILITY.sales forecast');

11301: gschd_fcst_cnt := 0;
11302: g_item_tbl_position := 0;
11303: local_ret_status := return_status ;
11304:
11305: log_message('Start MSC_CL_GMP_UTILITY.sales forecast');
11306: time_stamp;
11307:
11308: IF return_status THEN
11309: v_cp_enabled := TRUE;

Line 11636: log_message('End of MSC_CL_GMP_UTILITY.sales forecast') ;

11632: return_status := local_ret_status ;
11633:
11634: Insert_Designator;
11635:
11636: log_message('End of MSC_CL_GMP_UTILITY.sales forecast') ;
11637: time_stamp ;
11638: return_status := TRUE;
11639: ELSE
11640: extract_forecasts( pdblink ,

Line 11649: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Sales_forecast ' );

11645:
11646: END IF ; -- if NOT api_mode
11647: EXCEPTION
11648: WHEN NO_DATA_FOUND THEN /* B3577871 */
11649: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Sales_forecast ' );
11650: return_status := TRUE;
11651:
11652: WHEN OTHERS THEN
11653: log_message('Failure occured during the Sales_Forecast extract');

Line 11724: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN

11720: FETCH bs_code_ref INTO b_profile;
11721: CLOSE bs_code_ref;
11722:
11723: /* populate the org_string */
11724: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN
11725: NULL ;
11726: ELSE
11727: RAISE invalid_string_value ;
11728: END IF;

Line 11907: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

11903: ||' AND h.org_id = aspa.org_id(+) '
11904: ||' AND aspa.set_of_books_id = gsb.set_of_books_id(+) '
11905: ||' AND h.org_id is not null ' ;
11906:
11907: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
11908: v_sql_stmt := v_sql_stmt
11909: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
11910: END IF;
11911:

Line 11909: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

11905: ||' AND h.org_id is not null ' ;
11906:
11907: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
11908: v_sql_stmt := v_sql_stmt
11909: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
11910: END IF;
11911:
11912: EXECUTE IMMEDIATE v_sql_stmt USING
11913: b_profile, b_profile, v_instance_id, pdoc_type, l_profile ;

Line 12086: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

12082: ||' AND nvl(h.org_id,-99) = nvl(aspa.org_id,-99) '
12083: ||' AND aspa.set_of_books_id = gsb.set_of_books_id(+) '
12084: ||' AND h.org_id is null ' ;
12085:
12086: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12087: v_sql_stmt := v_sql_stmt
12088: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12089: END IF;
12090:

Line 12088: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

12084: ||' AND h.org_id is null ' ;
12085:
12086: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12087: v_sql_stmt := v_sql_stmt
12088: || ' AND i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12089: END IF;
12090:
12091: EXECUTE IMMEDIATE v_sql_stmt USING
12092: b_profile, b_profile, v_instance_id, pdoc_type, l_profile ;

Line 12097: log_message(MSC_CL_GMP_UTILITY.g_in_str_org);

12093:
12094: END IF ;
12095:
12096: IF v_entity = 2 THEN
12097: log_message(MSC_CL_GMP_UTILITY.g_in_str_org);
12098:
12099: /* For Engine Reseration record inserted */
12100: v_sql_stmt := 'INSERT into msc_st_reservations ('
12101: || ' inventory_item_id,'

Line 12152: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

12148: || ' and ool.open_flag = ' || '''Y'''
12149: || ' AND t.trans_qty <> 0 '
12150: || ' AND t.delete_mark = 0 ' ;
12151:
12152: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12153: v_sql_stmt := v_sql_stmt
12154: || ' and i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12155: END IF;
12156:

Line 12154: || ' and i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

12150: || ' AND t.delete_mark = 0 ' ;
12151:
12152: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12153: v_sql_stmt := v_sql_stmt
12154: || ' and i.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12155: END IF;
12156:
12157: EXECUTE IMMEDIATE v_sql_stmt USING v_instance_id, pdoc_type, l_profile ;
12158:

Line 12163: log_message(' NO DATA FOUND exception in: MSC_CL_GMP_UTILITY.sales_order_allocation');

12159: END IF; /* pentity */
12160:
12161: EXCEPTION
12162: WHEN NO_DATA_FOUND THEN
12163: log_message(' NO DATA FOUND exception in: MSC_CL_GMP_UTILITY.sales_order_allocation');
12164: return_status := TRUE;
12165: WHEN invalid_string_value THEN
12166: log_message('Organization string is Invalid ' );
12167: return_status := FALSE;

Line 12266: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN

12262: prev_fcst_set := '-1' ;
12263: prev_fcst := '-1';
12264:
12265: /* populate the org_string */
12266: IF MSC_CL_GMP_UTILITY.org_string(pinstance_id) THEN
12267: NULL ;
12268: ELSE
12269: RAISE invalid_string_value ;
12270: END IF;

Line 12292: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

12288: || ' fc_fcst_dtl'||pdblink||' d '
12289: || ' WHERE '
12290: || ' msi.organization_id = wm.mtl_organization_id ' ;
12291:
12292: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12293: l_fcst_stmt := l_fcst_stmt
12294: || ' and msi.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12295: END IF;
12296:

Line 12294: || ' and msi.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

12290: || ' msi.organization_id = wm.mtl_organization_id ' ;
12291:
12292: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
12293: l_fcst_stmt := l_fcst_stmt
12294: || ' and msi.organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
12295: END IF;
12296:
12297: l_fcst_stmt := l_fcst_stmt
12298: || ' and msi.segment1 = iim.item_no '

Line 13542: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

13538: ||' AND gbo.delete_mark = 0 '
13539: ||' AND gbo.so_line_id = ool.line_id '
13540: ||' AND ool.project_id = ppp.project_id (+) ';
13541:
13542: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
13543: v_stmt_alt_rsrc := v_stmt_alt_rsrc
13544: ||' AND EXISTS ( SELECT 1 FROM sy_orgn_mst'||pdblink||' som '
13545: ||' WHERE gia.whse_code = som.resource_whse_code )' ;
13546: END IF;

Line 13672: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.update_last_setup_id ' );

13668: CLOSE cur_lsetup_id ;
13669: COMMIT;
13670: EXCEPTION
13671: WHEN NO_DATA_FOUND THEN
13672: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.update_last_setup_id ' );
13673: RAISE;
13674:
13675: WHEN OTHERS THEN
13676: log_message('Error in Last Setup ID Program: '||SQLERRM);

Line 13807: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN

13803: v_cp_enabled := FALSE;
13804: END IF;
13805:
13806: /* populate the org_string */
13807: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN
13808: NULL ;
13809: ELSE
13810: RAISE invalid_string_value ;
13811: END IF;

Line 13911: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

13907: || ' AND w.mtl_organization_id = mrp.organization_id '
13908: || ' AND r.resources = rsm.resources ' /* B4081551 */
13909: || ' AND p.resource_whse_code = w.whse_code ' ;
13910:
13911: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
13912: ins_dept_res := ins_dept_res
13913: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
13914: END IF;
13915:

Line 13913: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

13909: || ' AND p.resource_whse_code = w.whse_code ' ;
13910:
13911: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
13912: ins_dept_res := ins_dept_res
13913: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
13914: END IF;
13915:
13916: ins_dept_res := ins_dept_res
13917: || ' AND r.delete_mark = 0 '

Line 13979: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

13975: || ' AND w.delete_mark = 0 '
13976: ||' AND sou.delete_mark = 0 '
13977: ||' AND sou.um_code = r.capacity_uom ';
13978:
13979: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
13980: ins_dept_res := ins_dept_res
13981: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
13982: END IF;
13983:

Line 13981: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;

13977: ||' AND sou.um_code = r.capacity_uom ';
13978:
13979: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
13980: ins_dept_res := ins_dept_res
13981: ||' AND w.mtl_organization_id ' || MSC_CL_GMP_UTILITY.g_in_str_org ;
13982: END IF;
13983:
13984: EXECUTE IMMEDIATE ins_dept_res USING p_instance_id, p_instance_id;
13985:

Line 14016: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

14012: || ' AND crd.resources = crm.resources '
14013: || ' AND crd.group_resource = crm.resources '
14014: || ' AND crd.delete_mark = 0 ';
14015:
14016: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
14017: ins_res_group := ins_res_group
14018: || ' AND EXISTS ( SELECT 1 FROM gmp_item_aps'||p_db_link||' gia '
14019: || ' WHERE gia.whse_code = sy.resource_whse_code )' ;
14020: END IF;

Line 14069: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

14065: ||' AND som.delete_mark = 0'
14066: ||' AND iwm.delete_mark = 0'
14067: ||' AND som.resource_whse_code = iwm.whse_code' ;
14068:
14069: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
14070: ins_res_instance := ins_res_instance
14071: ||' AND EXISTS ( SELECT 1 FROM gmp_item_aps'||p_db_link||' gia '
14072: ||' WHERE gia.whse_code = som.resource_whse_code )' ;
14073: END IF;

Line 14085: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Rsrc_extract ' );

14081: WHEN invalid_string_value THEN
14082: log_message('APS string is Invalid, check for Error condition' );
14083: return_status := FALSE;
14084: WHEN NO_DATA_FOUND THEN /* B3577871 */
14085: log_message(' NO_DATA_FOUND exception raised in Procedure: MSC_CL_GMP_UTILITY.Rsrc_extract ' );
14086: return_status := TRUE;
14087: WHEN OTHERS THEN
14088: log_message('Error in department/Res Group Insert: '||p_instance_id);
14089: log_message('stmt_no: ' || stmt_no || '--' || sqlerrm);

Line 15965: log_message('NO DATA FOUND : MSC_CL_GMP_UTILITY.net_rsrc_insert' || stmt_no);

15961: return_status := TRUE;
15962:
15963: EXCEPTION
15964: WHEN NO_DATA_FOUND THEN
15965: log_message('NO DATA FOUND : MSC_CL_GMP_UTILITY.net_rsrc_insert' || stmt_no);
15966: return_status := TRUE;
15967: WHEN OTHERS THEN
15968: log_message('Error in Net Resource Insert: '||stmt_no);
15969: log_message(sqlerrm);

Line 16355: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN

16351:
16352: /* Check if the org string have the organization */
16353: BEGIN
16354: stmt_no := 51;
16355: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN
16356: NULL ;
16357: ELSE
16358: RAISE invalid_string_value ;
16359: END IF;

Line 16363: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

16359: END IF;
16360:
16361: l_opm_org := plsqltbl_rec(k).organization_id ;
16362:
16363: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
16364: l_stmt := 'SELECT 1 FROM dual WHERE '||
16365: l_opm_org||MSC_CL_GMP_UTILITY.g_in_str_org ;
16366: OPEN l_cur for l_stmt ;
16367: FETCH l_cur INTO l_org_specific ;

Line 16365: l_opm_org||MSC_CL_GMP_UTILITY.g_in_str_org ;

16361: l_opm_org := plsqltbl_rec(k).organization_id ;
16362:
16363: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
16364: l_stmt := 'SELECT 1 FROM dual WHERE '||
16365: l_opm_org||MSC_CL_GMP_UTILITY.g_in_str_org ;
16366: OPEN l_cur for l_stmt ;
16367: FETCH l_cur INTO l_org_specific ;
16368: IF l_cur%NOTFOUND THEN
16369: l_org_specific := 0;

Line 16788: log_message(' NO_DATA_FOUND exception : MSC_CL_GMP_UTILITY.Populate_rsrc_cal ' );

16784: WHEN invalid_string_value THEN
16785: log_message('APS string is Invalid, check for Error condition' );
16786: return_status := FALSE;
16787: WHEN NO_DATA_FOUND THEN /* B3577871 */
16788: log_message(' NO_DATA_FOUND exception : MSC_CL_GMP_UTILITY.Populate_rsrc_cal ' );
16789: return_status := TRUE;
16790: WHEN OTHERS THEN
16791: log_message('Error in Populate Rsrc cal construct: '||stmt_no);
16792: log_message('Error : '||v_icode);

Line 16849: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN

16845: old_calendar_id := -1;
16846:
16847: stmt_no := 610;
16848: /* populate the org_string */
16849: IF MSC_CL_GMP_UTILITY.org_string(p_instance_id) THEN
16850: NULL ;
16851: ELSE
16852: RAISE invalid_string_value ;
16853: END IF;

Line 16868: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN

16864: ||' AND crd.calendar_id IS NOT NULL '
16865: ||' AND crd.calendar_id = shcl.calendar_id '
16866: ||' AND iwm.whse_code = sy.resource_whse_code ' ;
16867:
16868: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
16869: sql_get_cal := sql_get_cal
16870: ||' AND iwm.mtl_organization_id '||MSC_CL_GMP_UTILITY.g_in_str_org;
16871: END IF;
16872:

Line 16870: ||' AND iwm.mtl_organization_id '||MSC_CL_GMP_UTILITY.g_in_str_org;

16866: ||' AND iwm.whse_code = sy.resource_whse_code ' ;
16867:
16868: IF MSC_CL_GMP_UTILITY.g_in_str_org IS NOT NULL THEN
16869: sql_get_cal := sql_get_cal
16870: ||' AND iwm.mtl_organization_id '||MSC_CL_GMP_UTILITY.g_in_str_org;
16871: END IF;
16872:
16873: sql_get_cal := sql_get_cal
16874: ||' AND shcl.delete_mark = 0 '

Line 16937: log_message('NO DATA FOUND exception: MSC_CL_GMP_UTILITY.rsrcal_based_availability');

16933: WHEN invalid_string_value THEN
16934: log_message('APS string is Invalid, check for Error condition' );
16935: return_status := FALSE;
16936: WHEN NO_DATA_FOUND THEN
16937: log_message('NO DATA FOUND exception: MSC_CL_GMP_UTILITY.rsrcal_based_availability');
16938: return_status := TRUE;
16939: WHEN OTHERS THEN
16940: log_message('Error in MSC_CL_GMP_UTILITY.rsrcal_based_availability '||p_instance_id);
16941: log_message(sqlerrm);

Line 16940: log_message('Error in MSC_CL_GMP_UTILITY.rsrcal_based_availability '||p_instance_id);

16936: WHEN NO_DATA_FOUND THEN
16937: log_message('NO DATA FOUND exception: MSC_CL_GMP_UTILITY.rsrcal_based_availability');
16938: return_status := TRUE;
16939: WHEN OTHERS THEN
16940: log_message('Error in MSC_CL_GMP_UTILITY.rsrcal_based_availability '||p_instance_id);
16941: log_message(sqlerrm);
16942: return_status := FALSE;
16943:
16944: END rsrcal_based_availability;

Line 17954: log_message('NO DATA FOUND exception: MSC_CL_GMP_UTILITY.net_rsrc_avail_calculate');

17950:
17951: return_status := TRUE ;
17952: EXCEPTION
17953: WHEN NO_DATA_FOUND THEN
17954: log_message('NO DATA FOUND exception: MSC_CL_GMP_UTILITY.net_rsrc_avail_calculate');
17955: return_status := TRUE;
17956: WHEN OTHERS THEN
17957: log_message('Error in Net Resource Instance Insert: '||stmt_no);
17958: log_message(sqlerrm);

Line 18063: SELECT MSC_CL_GMP_UTILITY.is_aps_compatible

18059: l_aps_compatible := 0 ;
18060: org_str := NULL ;
18061: in_position := -10 ;
18062:
18063: SELECT MSC_CL_GMP_UTILITY.is_aps_compatible
18064: INTO l_aps_compatible FROM DUAL ;
18065:
18066: IF l_aps_compatible = 1 THEN
18067:

Line 18084: MSC_CL_GMP_UTILITY.g_in_str_org := org_str ;

18080: We have to find the IN part in the string, otherwise have to raise
18081: Exception message for error condition */
18082:
18083: IF in_position > 0 THEN
18084: MSC_CL_GMP_UTILITY.g_in_str_org := org_str ;
18085: return TRUE ;
18086: ELSE
18087: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;
18088: return FALSE ;

Line 18087: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;

18083: IF in_position > 0 THEN
18084: MSC_CL_GMP_UTILITY.g_in_str_org := org_str ;
18085: return TRUE ;
18086: ELSE
18087: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;
18088: return FALSE ;
18089: END IF;
18090:
18091:

Line 18094: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;

18090:
18091:
18092: ELSE
18093: /* For older patchset This value should be TRUE */
18094: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;
18095: return TRUE ;
18096: END IF;
18097:
18098: EXCEPTION

Line 18101: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;

18097:
18098: EXCEPTION
18099: WHEN OTHERS THEN
18100: log_message('Error in org_string ' || sqlerrm);
18101: MSC_CL_GMP_UTILITY.g_in_str_org := NULL ;
18102: return FALSE ;
18103: END ORG_STRING;
18104:
18105: FUNCTION GMP_CAL_UTILITY1_R10

Line 18152: END MSC_CL_GMP_UTILITY;

18148: BEGIN
18149: RETURN 1 ;
18150: END is_aps_compatible ;
18151:
18152: END MSC_CL_GMP_UTILITY;