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.46.12020000.6 2013/02/28 11:34:13 vkinduri ship $ */
3:
4: /* Define Exceptions */
5: invalid_string_value EXCEPTION;

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

3022: log_message('Profile "GMP: UOM for Hour" is Invalid ' );
3023: return_status := FALSE;
3024:
3025: WHEN NO_DATA_FOUND THEN /* B3577871 */
3026: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Production_orders ' );
3027: return_status := TRUE;
3028:
3029: WHEN OTHERS THEN
3030: return_status := FALSE;

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

3393: /* nsinghi INVCONV End */
3394:
3395: EXCEPTION
3396: WHEN onhand_balances_failure THEN
3397: log_message(' extract_onhand_balances_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3398: return_status := FALSE;
3399: WHEN inv_transfer_failure THEN
3400: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3401: return_status := FALSE;

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

3396: WHEN onhand_balances_failure THEN
3397: log_message(' extract_onhand_balances_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3398: return_status := FALSE;
3399: WHEN inv_transfer_failure THEN
3400: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3401: return_status := FALSE;
3402: WHEN NO_DATA_FOUND THEN /* B3577871 */
3403: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3404: return_status := TRUE;

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

3399: WHEN inv_transfer_failure THEN
3400: log_message(' extract_inv_transfer_supplies_failure raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3401: return_status := FALSE;
3402: WHEN NO_DATA_FOUND THEN /* B3577871 */
3403: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Onhand_inventory ' );
3404: return_status := TRUE;
3405:
3406: END onhand_inventory; /* end onhand_inventory */
3407:

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

4169: gschd_fcst_cnt := 0;
4170: g_item_tbl_position := 0;
4171: local_ret_status := return_status ;
4172:
4173: log_message('Start gmp_aps_ds_pull.sales forecast');
4174: time_stamp;
4175:
4176: IF return_status THEN
4177: v_cp_enabled := TRUE;

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

4477: return_status := local_ret_status ;
4478:
4479: Insert_Designator;
4480:
4481: log_message('End of gmp_aps_ds_pull.sales forecast') ;
4482: time_stamp ;
4483: return_status := TRUE;
4484: ELSE
4485: extract_forecasts( pdblink ,

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

4490:
4491: END IF ; -- if NOT api_mode
4492: EXCEPTION
4493: WHEN NO_DATA_FOUND THEN /* B3577871 */
4494: log_message(' NO_DATA_FOUND exception raised in Procedure: Gmp_aps_ds_pull.Sales_forecast ' );
4495: return_status := TRUE;
4496:
4497: WHEN OTHERS THEN
4498: log_message('Failure occured during the Sales_Forecast extract');

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

6033: CLOSE cur_lsetup_id ;
6034: COMMIT;
6035: EXCEPTION
6036: WHEN NO_DATA_FOUND THEN
6037: log_message(' NO_DATA_FOUND exception raised in Procedure: gmp_aps_ds_pull.update_last_setup_id ' );
6038: RAISE;
6039:
6040: WHEN OTHERS THEN
6041: log_message('Error in Last Setup ID Program: '||SQLERRM);

Line 6063: END gmp_aps_ds_pull;

6059: LOG_MESSAGE(pBUFF);
6060: END IF;
6061: END gmp_debug_message;
6062:
6063: END gmp_aps_ds_pull;