APPS.GMP_APS_DS_PULL dependencies on GMP_APS_DS_PULL

Line 1: PACKAGE BODY gmp_aps_ds_pull AS

1: PACKAGE BODY gmp_aps_ds_pull AS
2: /* $Header: GMPPLDSB.pls 120.28.12010000.2 2008/11/01 21:57:10 rpatangy ship $ */
3:
4: /* Define Exceptions */
5: invalid_string_value EXCEPTION;

Line 2780: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Production_orders ' );

2776: log_message('Profile "GMP: UOM for Hour" is Invalid ' );
2777: return_status := FALSE;
2778:
2779: WHEN NO_DATA_FOUND THEN /* B3577871 */
2780: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Production_orders ' );
2781: return_status := TRUE;
2782:
2783: WHEN OTHERS THEN
2784: return_status := FALSE;

Line 3151: log_message(' extract_onhand_balances_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );

3147: /* nsinghi INVCONV End */
3148:
3149: EXCEPTION
3150: WHEN onhand_balances_failure THEN
3151: log_message(' extract_onhand_balances_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3152: return_status := FALSE;
3153: WHEN inv_transfer_failure THEN
3154: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3155: return_status := FALSE;

Line 3154: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );

3150: WHEN onhand_balances_failure THEN
3151: log_message(' extract_onhand_balances_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3152: return_status := FALSE;
3153: WHEN inv_transfer_failure THEN
3154: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3155: return_status := FALSE;
3156: WHEN NO_DATA_FOUND THEN /* B3577871 */
3157: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3158: return_status := TRUE;

Line 3157: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );

3153: WHEN inv_transfer_failure THEN
3154: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3155: return_status := FALSE;
3156: WHEN NO_DATA_FOUND THEN /* B3577871 */
3157: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3158: return_status := TRUE;
3159:
3160: END onhand_inventory; /* end onhand_inventory */
3161:

Line 3927: log_message('Start gmp_aps_ds_pull.sales forecast');

3923: gschd_fcst_cnt := 0;
3924: g_item_tbl_position := 0;
3925: local_ret_status := return_status ;
3926:
3927: log_message('Start gmp_aps_ds_pull.sales forecast');
3928: time_stamp;
3929:
3930: IF return_status THEN
3931: v_cp_enabled := TRUE;

Line 4235: log_message('End of gmp_aps_ds_pull.sales forecast') ;

4231: return_status := local_ret_status ;
4232:
4233: Insert_Designator;
4234:
4235: log_message('End of gmp_aps_ds_pull.sales forecast') ;
4236: time_stamp ;
4237: return_status := TRUE;
4238: ELSE
4239: extract_forecasts( pdblink ,

Line 4248: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Sales_forecast ' );

4244:
4245: END IF ; -- if NOT api_mode
4246: EXCEPTION
4247: WHEN NO_DATA_FOUND THEN /* B3577871 */
4248: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Sales_forecast ' );
4249: return_status := TRUE;
4250:
4251: WHEN OTHERS THEN
4252: log_message('Failure occured during the Sales_Forecast extract');

Line 5791: log_message(' NO_DATA_FOUND exception raised in Procedure: gmp_aps_ds_pull.update_last_setup_id ' );

5787: CLOSE cur_lsetup_id ;
5788: COMMIT;
5789: EXCEPTION
5790: WHEN NO_DATA_FOUND THEN
5791: log_message(' NO_DATA_FOUND exception raised in Procedure: gmp_aps_ds_pull.update_last_setup_id ' );
5792: RAISE;
5793:
5794: WHEN OTHERS THEN
5795: log_message('Error in Last Setup ID Program: '||SQLERRM);

Line 5800: END gmp_aps_ds_pull;

5796: RAISE;
5797:
5798: END update_last_setup_id;
5799:
5800: END gmp_aps_ds_pull;