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

Line 1: PACKAGE BODY oki_load_wbc_pvt as

1: PACKAGE BODY oki_load_wbc_pvt as
2: /* $Header: OKIRWBCB.pls 115.21 2003/11/24 08:24:41 kbajaj ship $ */
3:
4: --------------------------------------------------------------------------------
5: -- Modification History

Line 139: , oki_load_wbc_pvt.g_request_id

135: , p_scs_code
136: , p_base_forecast_amount
137: , p_base_booked_amount
138: , p_base_lost_amount
139: , oki_load_wbc_pvt.g_request_id
140: , oki_load_wbc_pvt.g_program_application_id
141: , oki_load_wbc_pvt.g_program_id
142: , oki_load_wbc_pvt.g_program_update_date ) ;
143:

Line 140: , oki_load_wbc_pvt.g_program_application_id

136: , p_base_forecast_amount
137: , p_base_booked_amount
138: , p_base_lost_amount
139: , oki_load_wbc_pvt.g_request_id
140: , oki_load_wbc_pvt.g_program_application_id
141: , oki_load_wbc_pvt.g_program_id
142: , oki_load_wbc_pvt.g_program_update_date ) ;
143:
144:

Line 141: , oki_load_wbc_pvt.g_program_id

137: , p_base_booked_amount
138: , p_base_lost_amount
139: , oki_load_wbc_pvt.g_request_id
140: , oki_load_wbc_pvt.g_program_application_id
141: , oki_load_wbc_pvt.g_program_id
142: , oki_load_wbc_pvt.g_program_update_date ) ;
143:
144:
145: EXCEPTION

Line 142: , oki_load_wbc_pvt.g_program_update_date ) ;

138: , p_base_lost_amount
139: , oki_load_wbc_pvt.g_request_id
140: , oki_load_wbc_pvt.g_program_application_id
141: , oki_load_wbc_pvt.g_program_id
142: , oki_load_wbc_pvt.g_program_update_date ) ;
143:
144:
145: EXCEPTION
146: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

Line 146: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

142: , oki_load_wbc_pvt.g_program_update_date ) ;
143:
144:
145: EXCEPTION
146: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
147: l_sqlcode := SQLCODE ;
148: l_sqlerrm := SQLERRM ;
149:
150: -- Set return code to error

Line 213: , request_id = oki_load_wbc_pvt.g_request_id

209: UPDATE oki_wip_by_customers SET
210: base_forecast_amount = p_base_forecast_amount
211: , base_booked_amount = p_base_booked_amount
212: , base_lost_amount = p_base_lost_amount
213: , request_id = oki_load_wbc_pvt.g_request_id
214: , program_application_id = oki_load_wbc_pvt.g_program_application_id
215: , program_id = oki_load_wbc_pvt.g_program_id
216: , program_update_date = oki_load_wbc_pvt.g_program_update_date
217: WHERE ROWID = p_wbc_rowid ;

Line 214: , program_application_id = oki_load_wbc_pvt.g_program_application_id

210: base_forecast_amount = p_base_forecast_amount
211: , base_booked_amount = p_base_booked_amount
212: , base_lost_amount = p_base_lost_amount
213: , request_id = oki_load_wbc_pvt.g_request_id
214: , program_application_id = oki_load_wbc_pvt.g_program_application_id
215: , program_id = oki_load_wbc_pvt.g_program_id
216: , program_update_date = oki_load_wbc_pvt.g_program_update_date
217: WHERE ROWID = p_wbc_rowid ;
218:

Line 215: , program_id = oki_load_wbc_pvt.g_program_id

211: , base_booked_amount = p_base_booked_amount
212: , base_lost_amount = p_base_lost_amount
213: , request_id = oki_load_wbc_pvt.g_request_id
214: , program_application_id = oki_load_wbc_pvt.g_program_application_id
215: , program_id = oki_load_wbc_pvt.g_program_id
216: , program_update_date = oki_load_wbc_pvt.g_program_update_date
217: WHERE ROWID = p_wbc_rowid ;
218:
219: EXCEPTION

Line 216: , program_update_date = oki_load_wbc_pvt.g_program_update_date

212: , base_lost_amount = p_base_lost_amount
213: , request_id = oki_load_wbc_pvt.g_request_id
214: , program_application_id = oki_load_wbc_pvt.g_program_application_id
215: , program_id = oki_load_wbc_pvt.g_program_id
216: , program_update_date = oki_load_wbc_pvt.g_program_update_date
217: WHERE ROWID = p_wbc_rowid ;
218:
219: EXCEPTION
220: WHEN OTHERS THEN

Line 231: , value => 'OKI_LOAD_WBC_PVT.UPD_WIP_BY_CUST');

227: fnd_message.set_name( application => 'OKI'
228: , name => 'OKI_UNEXPECTED_FAILURE');
229:
230: fnd_message.set_token( token => 'OBJECT_NAME'
231: , value => 'OKI_LOAD_WBC_PVT.UPD_WIP_BY_CUST');
232:
233: fnd_file.put_line( which => fnd_file.log
234: , buff => fnd_message.get);
235:

Line 427: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,

423:
424:
425: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
426: -- Determine if the record is a new one or an existing one
427: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
428: rec_g_glpr_csr.period_name, rec_l_cust_id_csr.authoring_org_id,
429: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
430: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
431: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

Line 430: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;

426: -- Determine if the record is a new one or an existing one
427: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
428: rec_g_glpr_csr.period_name, rec_l_cust_id_csr.authoring_org_id,
429: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
430: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
431: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
432: l_loc := 'Insert the new record.' ;
433: -- Insert the current period data for the period
434: oki_load_wbc_pvt.ins_wip_by_cust(

Line 431: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

427: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
428: rec_g_glpr_csr.period_name, rec_l_cust_id_csr.authoring_org_id,
429: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
430: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
431: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
432: l_loc := 'Insert the new record.' ;
433: -- Insert the current period data for the period
434: oki_load_wbc_pvt.ins_wip_by_cust(
435: p_period_name => rec_g_glpr_csr.period_name

Line 434: oki_load_wbc_pvt.ins_wip_by_cust(

430: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
431: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
432: l_loc := 'Insert the new record.' ;
433: -- Insert the current period data for the period
434: oki_load_wbc_pvt.ins_wip_by_cust(
435: p_period_name => rec_g_glpr_csr.period_name
436: , p_period_set_name => rec_g_glpr_csr.period_set_name
437: , p_period_type => rec_g_glpr_csr.period_type
438: , p_authoring_org_id => rec_l_cust_id_csr.authoring_org_id

Line 450: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

446: , x_retcode => l_retcode) ;
447:
448: IF l_retcode = '2' THEN
449: -- Load failed, exit immediately.
450: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
451: EXIT ;
452: END IF ;
453:
454: ELSE

Line 457: oki_load_wbc_pvt.upd_wip_by_cust(

453:
454: ELSE
455: l_loc := 'Update the existing record.' ;
456: -- Record already exists, so perform an update
457: oki_load_wbc_pvt.upd_wip_by_cust(
458: p_base_forecast_amount => l_base_forecast_amount
459: , p_base_booked_amount => l_base_booked_amount
460: , p_base_lost_amount => l_base_lost_amount
461: , p_wbc_rowid => rec_g_wbc_csr.rowid

Line 466: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

462: , x_retcode => l_retcode ) ;
463:
464: IF l_retcode = '2' THEN
465: -- Load failed, exit immediately.
466: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
467: END IF ;
468: END IF ;
469:
470: CLOSE g_wbc_csr ;

Line 476: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

472: END LOOP g_glpr_csr_loop ;
473: END LOOP l_cust_id_csr_loop ;
474:
475: EXCEPTION
476: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
477: -- Do not log an error ; It has already been logged.
478: -- Set return code to error
479: x_retcode := '2' ;
480:

Line 492: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL1');

488: fnd_message.set_name( application => 'OKI'
489: , name => 'OKI_UNEXPECTED_FAILURE');
490:
491: fnd_message.set_token( token => 'OBJECT_NAME'
492: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL1');
493:
494: fnd_file.put_line( which => fnd_file.log
495: , buff => fnd_message.get);
496:

Line 688: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,

684:
685:
686: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
687: -- Determine if the record is a new one or an existing one
688: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
689: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
690: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

Line 689: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,

685:
686: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
687: -- Determine if the record is a new one or an existing one
688: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
689: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
690: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
693: l_loc := 'Insert the new record.' ;

Line 691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;

687: -- Determine if the record is a new one or an existing one
688: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
689: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
690: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
693: l_loc := 'Insert the new record.' ;
694: -- Insert the current period data for the period
695: oki_load_wbc_pvt.ins_wip_by_cust(

Line 692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

688: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
689: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
690: rec_l_cust_id_csr.customer_id, rec_l_cust_id_csr.scs_code ) ;
691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
693: l_loc := 'Insert the new record.' ;
694: -- Insert the current period data for the period
695: oki_load_wbc_pvt.ins_wip_by_cust(
696: p_period_name => rec_g_glpr_csr.period_name

Line 695: oki_load_wbc_pvt.ins_wip_by_cust(

691: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
692: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
693: l_loc := 'Insert the new record.' ;
694: -- Insert the current period data for the period
695: oki_load_wbc_pvt.ins_wip_by_cust(
696: p_period_name => rec_g_glpr_csr.period_name
697: , p_period_set_name => rec_g_glpr_csr.period_set_name
698: , p_period_type => rec_g_glpr_csr.period_type
699: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id

Line 699: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id

695: oki_load_wbc_pvt.ins_wip_by_cust(
696: p_period_name => rec_g_glpr_csr.period_name
697: , p_period_set_name => rec_g_glpr_csr.period_set_name
698: , p_period_type => rec_g_glpr_csr.period_type
699: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id
700: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name
701: , p_customer_party_id => rec_l_cust_id_csr.customer_id
702: , p_customer_name => rec_l_cust_id_csr.customer_name
703: , p_scs_code => rec_l_cust_id_csr.scs_code

Line 700: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name

696: p_period_name => rec_g_glpr_csr.period_name
697: , p_period_set_name => rec_g_glpr_csr.period_set_name
698: , p_period_type => rec_g_glpr_csr.period_type
699: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id
700: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name
701: , p_customer_party_id => rec_l_cust_id_csr.customer_id
702: , p_customer_name => rec_l_cust_id_csr.customer_name
703: , p_scs_code => rec_l_cust_id_csr.scs_code
704: , p_base_forecast_amount => l_base_forecast_amount

Line 711: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

707: , x_retcode => l_retcode) ;
708:
709: IF l_retcode = '2' THEN
710: -- Load failed, exit immediately.
711: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
712: EXIT ;
713: END IF ;
714:
715: ELSE

Line 718: oki_load_wbc_pvt.upd_wip_by_cust(

714:
715: ELSE
716: l_loc := 'Update the existing record.' ;
717: -- Record already exists, so perform an update
718: oki_load_wbc_pvt.upd_wip_by_cust(
719: p_base_forecast_amount => l_base_forecast_amount
720: , p_base_booked_amount => l_base_booked_amount
721: , p_base_lost_amount => l_base_lost_amount
722: , p_wbc_rowid => rec_g_wbc_csr.rowid

Line 727: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

723: , x_retcode => l_retcode ) ;
724:
725: IF l_retcode = '2' THEN
726: -- Load failed, exit immediately.
727: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
728: END IF ;
729: END IF ;
730:
731: CLOSE oki_load_wbc_pvt.g_wbc_csr ;

Line 731: CLOSE oki_load_wbc_pvt.g_wbc_csr ;

727: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
728: END IF ;
729: END IF ;
730:
731: CLOSE oki_load_wbc_pvt.g_wbc_csr ;
732:
733: END LOOP g_glpr_csr_loop ;
734: END LOOP l_cust_id_csr_loop ;
735:

Line 737: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

733: END LOOP g_glpr_csr_loop ;
734: END LOOP l_cust_id_csr_loop ;
735:
736: EXCEPTION
737: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
738: -- Do not log an error ; It has already been logged.
739: -- Set return code to error
740: x_retcode := '2' ;
741:

Line 753: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL2');

749: fnd_message.set_name( application => 'OKI'
750: , name => 'OKI_UNEXPECTED_FAILURE');
751:
752: fnd_message.set_token( token => 'OBJECT_NAME'
753: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL2');
754:
755: fnd_file.put_line( which => fnd_file.log
756: , buff => fnd_message.get);
757:

Line 937: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,

933: CLOSE l_cust_lost_csr ;
934:
935: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
936: -- Determine if the record is a new one or an existing one
937: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
939: rec_l_cust_id_csr.customer_id,
940: oki_load_wbc_pvt.g_all_scs_code ) ;
941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;

Line 938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,

934:
935: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
936: -- Determine if the record is a new one or an existing one
937: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
939: rec_l_cust_id_csr.customer_id,
940: oki_load_wbc_pvt.g_all_scs_code ) ;
941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

Line 940: oki_load_wbc_pvt.g_all_scs_code ) ;

936: -- Determine if the record is a new one or an existing one
937: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
939: rec_l_cust_id_csr.customer_id,
940: oki_load_wbc_pvt.g_all_scs_code ) ;
941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
943: l_loc := 'Insert the new record.' ;
944: -- Insert the current period data for the period

Line 941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;

937: OPEN oki_load_wbc_pvt.g_wbc_csr( rec_g_glpr_csr.period_set_name,
938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
939: rec_l_cust_id_csr.customer_id,
940: oki_load_wbc_pvt.g_all_scs_code ) ;
941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
943: l_loc := 'Insert the new record.' ;
944: -- Insert the current period data for the period
945: oki_load_wbc_pvt.ins_wip_by_cust(

Line 942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN

938: rec_g_glpr_csr.period_name, oki_load_wbc_pvt.g_all_org_id,
939: rec_l_cust_id_csr.customer_id,
940: oki_load_wbc_pvt.g_all_scs_code ) ;
941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
943: l_loc := 'Insert the new record.' ;
944: -- Insert the current period data for the period
945: oki_load_wbc_pvt.ins_wip_by_cust(
946: p_period_name => rec_g_glpr_csr.period_name

Line 945: oki_load_wbc_pvt.ins_wip_by_cust(

941: FETCH oki_load_wbc_pvt.g_wbc_csr into rec_g_wbc_csr ;
942: IF oki_load_wbc_pvt.g_wbc_csr%NOTFOUND THEN
943: l_loc := 'Insert the new record.' ;
944: -- Insert the current period data for the period
945: oki_load_wbc_pvt.ins_wip_by_cust(
946: p_period_name => rec_g_glpr_csr.period_name
947: , p_period_set_name => rec_g_glpr_csr.period_set_name
948: , p_period_type => rec_g_glpr_csr.period_type
949: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id

Line 949: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id

945: oki_load_wbc_pvt.ins_wip_by_cust(
946: p_period_name => rec_g_glpr_csr.period_name
947: , p_period_set_name => rec_g_glpr_csr.period_set_name
948: , p_period_type => rec_g_glpr_csr.period_type
949: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id
950: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name
951: , p_customer_party_id => rec_l_cust_id_csr.customer_id
952: , p_customer_name => rec_l_cust_id_csr.customer_name
953: , p_scs_code => oki_load_wbc_pvt.g_all_scs_code

Line 950: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name

946: p_period_name => rec_g_glpr_csr.period_name
947: , p_period_set_name => rec_g_glpr_csr.period_set_name
948: , p_period_type => rec_g_glpr_csr.period_type
949: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id
950: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name
951: , p_customer_party_id => rec_l_cust_id_csr.customer_id
952: , p_customer_name => rec_l_cust_id_csr.customer_name
953: , p_scs_code => oki_load_wbc_pvt.g_all_scs_code
954: , p_base_forecast_amount => l_base_forecast_amount

Line 953: , p_scs_code => oki_load_wbc_pvt.g_all_scs_code

949: , p_authoring_org_id => oki_load_wbc_pvt.g_all_org_id
950: , p_authoring_org_name => oki_load_wbc_pvt.g_all_org_name
951: , p_customer_party_id => rec_l_cust_id_csr.customer_id
952: , p_customer_name => rec_l_cust_id_csr.customer_name
953: , p_scs_code => oki_load_wbc_pvt.g_all_scs_code
954: , p_base_forecast_amount => l_base_forecast_amount
955: , p_base_booked_amount => l_base_booked_amount
956: , p_base_lost_amount => l_base_lost_amount
957: , x_retcode => l_retcode) ;

Line 961: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

957: , x_retcode => l_retcode) ;
958:
959: IF l_retcode = '2' THEN
960: -- Load failed, exit immediately.
961: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
962: EXIT ;
963: END IF ;
964:
965: ELSE

Line 968: oki_load_wbc_pvt.upd_wip_by_cust(

964:
965: ELSE
966: l_loc := 'Update the existing record.' ;
967: -- Record already exists, so perform an update
968: oki_load_wbc_pvt.upd_wip_by_cust(
969: p_base_forecast_amount => l_base_forecast_amount
970: , p_base_booked_amount => l_base_booked_amount
971: , p_base_lost_amount => l_base_lost_amount
972: , p_wbc_rowid => rec_g_wbc_csr.rowid

Line 977: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

973: , x_retcode => l_retcode ) ;
974:
975: IF l_retcode = '2' THEN
976: -- Load failed, exit immediately.
977: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
978: END IF ;
979: END IF ;
980:
981: CLOSE oki_load_wbc_pvt.g_wbc_csr ;

Line 981: CLOSE oki_load_wbc_pvt.g_wbc_csr ;

977: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
978: END IF ;
979: END IF ;
980:
981: CLOSE oki_load_wbc_pvt.g_wbc_csr ;
982:
983: END LOOP ;
984: END LOOP ;
985:

Line 987: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

983: END LOOP ;
984: END LOOP ;
985:
986: EXCEPTION
987: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
988: -- Do not log an error ; It has already been logged.
989: -- Set return code to error
990: x_retcode := '2' ;
991:

Line 1003: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_SUM');

999: fnd_message.set_name( application => 'OKI'
1000: , name => 'OKI_UNEXPECTED_FAILURE');
1001:
1002: fnd_message.set_token( token => 'OBJECT_NAME'
1003: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_SUM');
1004:
1005: fnd_file.put_line( which => fnd_file.log
1006: , buff => fnd_message.get);
1007:

Line 1062: SAVEPOINT oki_load_wbc_pvt_crt_wip_cust ;

1058:
1059:
1060: BEGIN
1061:
1062: SAVEPOINT oki_load_wbc_pvt_crt_wip_cust ;
1063:
1064: -- initialize return code to success
1065: l_retcode := '0' ;
1066: x_retcode := '0' ;

Line 1069: oki_load_wbc_pvt.calc_wbc_dtl1(

1065: l_retcode := '0' ;
1066: x_retcode := '0' ;
1067:
1068: -- Procedure to calculate the amounts for each dimension
1069: oki_load_wbc_pvt.calc_wbc_dtl1(
1070: p_period_set_name => p_period_set_name
1071: , p_period_type => p_period_type
1072: , p_summary_build_date => p_summary_build_date
1073: , x_retcode => l_retcode ) ;

Line 1077: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

1073: , x_retcode => l_retcode ) ;
1074:
1075: IF l_retcode = '2' THEN
1076: -- Load failed, exit immediately.
1077: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
1078: END IF ;
1079:
1080: -- Procedure to calculate the amounts across organizations
1081: oki_load_wbc_pvt.calc_wbc_dtl2(

Line 1081: oki_load_wbc_pvt.calc_wbc_dtl2(

1077: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
1078: END IF ;
1079:
1080: -- Procedure to calculate the amounts across organizations
1081: oki_load_wbc_pvt.calc_wbc_dtl2(
1082: p_period_set_name => p_period_set_name
1083: , p_period_type => p_period_type
1084: , p_summary_build_date => p_summary_build_date
1085: , x_retcode => l_retcode ) ;

Line 1089: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

1085: , x_retcode => l_retcode ) ;
1086:
1087: IF l_retcode = '2' THEN
1088: -- Load failed, exit immediately.
1089: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
1090: END IF ;
1091:
1092: -- Procedure to calculate the amounts across organizations
1093: -- and subclasses

Line 1094: oki_load_wbc_pvt.calc_wbc_sum(

1090: END IF ;
1091:
1092: -- Procedure to calculate the amounts across organizations
1093: -- and subclasses
1094: oki_load_wbc_pvt.calc_wbc_sum(
1095: p_period_set_name => p_period_set_name
1096: , p_period_type => p_period_type
1097: , p_summary_build_date => p_summary_build_date
1098: , x_retcode => l_retcode ) ;

Line 1102: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;

1098: , x_retcode => l_retcode ) ;
1099:
1100: IF l_retcode = '2' THEN
1101: -- Load failed, exit immediately.
1102: RAISE oki_load_wbc_pvt.g_excp_exit_immediate ;
1103: END IF ;
1104:
1105: COMMIT ;
1106:

Line 1107: SAVEPOINT oki_load_wbc_pvt_upd_refresh ;

1103: END IF ;
1104:
1105: COMMIT ;
1106:
1107: SAVEPOINT oki_load_wbc_pvt_upd_refresh ;
1108:
1109: -- Table loaded successfully. Log message in concurrent manager
1110: -- log indicating successful load.
1111: fnd_message.set_name( application => 'OKI'

Line 1135: ROLLBACK to oki_load_wbc_pvt_upd_refresh ;

1131: -- Do not log error; It has already been logged by the refreshs
1132: -- program
1133: x_retcode := l_retcode ;
1134:
1135: ROLLBACK to oki_load_wbc_pvt_upd_refresh ;
1136:
1137: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
1138: -- Do not log an error ; It has already been logged.
1139: -- Set return code to error

Line 1137: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN

1133: x_retcode := l_retcode ;
1134:
1135: ROLLBACK to oki_load_wbc_pvt_upd_refresh ;
1136:
1137: WHEN oki_load_wbc_pvt.g_excp_exit_immediate THEN
1138: -- Do not log an error ; It has already been logged.
1139: -- Set return code to error
1140: x_retcode := '2' ;
1141:

Line 1142: ROLLBACK TO oki_load_wbc_pvt_crt_wip_cust ;

1138: -- Do not log an error ; It has already been logged.
1139: -- Set return code to error
1140: x_retcode := '2' ;
1141:
1142: ROLLBACK TO oki_load_wbc_pvt_crt_wip_cust ;
1143:
1144: WHEN OTHERS THEN
1145:
1146: l_sqlcode := sqlcode ;

Line 1153: ROLLBACK to oki_load_wbc_pvt_crt_wip_cust ;

1149: -- Set return code to error
1150: x_retcode := '2' ;
1151:
1152: -- rollback all transactions
1153: ROLLBACK to oki_load_wbc_pvt_crt_wip_cust ;
1154:
1155:
1156: fnd_message.set_name( application => 'OKI'
1157: , name => 'OKI_UNEXPECTED_FAILURE');

Line 1160: , value => 'OKI_LOAD_WBC_PVT.CRT_WIP_BY_CUST');

1156: fnd_message.set_name( application => 'OKI'
1157: , name => 'OKI_UNEXPECTED_FAILURE');
1158:
1159: fnd_message.set_token( token => 'OBJECT_NAME'
1160: , value => 'OKI_LOAD_WBC_PVT.CRT_WIP_BY_CUST');
1161:
1162: fnd_file.put_line( which => fnd_file.log
1163: , buff => fnd_message.get);
1164:

Line 1179: END oki_load_wbc_pvt ;

1175: g_program_application_id := fnd_global.prog_appl_id ;
1176: g_program_id := fnd_global.conc_program_id ;
1177: g_program_update_date := SYSDATE ;
1178:
1179: END oki_load_wbc_pvt ;