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_RBS_PVT dependencies on OKI_LOAD_RBS_PVT

Line 1: PACKAGE BODY oki_load_rbs_pvt as

1: PACKAGE BODY oki_load_rbs_pvt as
2: /* $Header: OKIRRBSB.pls 115.24 2003/11/24 08:25:10 kbajaj ship $ */
3:
4: --------------------------------------------------------------------------------
5: -- Modification History

Line 132: , oki_load_rbs_pvt.g_request_id

128: , p_status_code
129: , p_scs_code
130: , p_base_amount
131: , p_contract_count
132: , oki_load_rbs_pvt.g_request_id
133: , oki_load_rbs_pvt.g_program_application_id
134: , oki_load_rbs_pvt.g_program_id
135: , oki_load_rbs_pvt.g_program_update_date ) ;
136:

Line 133: , oki_load_rbs_pvt.g_program_application_id

129: , p_scs_code
130: , p_base_amount
131: , p_contract_count
132: , oki_load_rbs_pvt.g_request_id
133: , oki_load_rbs_pvt.g_program_application_id
134: , oki_load_rbs_pvt.g_program_id
135: , oki_load_rbs_pvt.g_program_update_date ) ;
136:
137:

Line 134: , oki_load_rbs_pvt.g_program_id

130: , p_base_amount
131: , p_contract_count
132: , oki_load_rbs_pvt.g_request_id
133: , oki_load_rbs_pvt.g_program_application_id
134: , oki_load_rbs_pvt.g_program_id
135: , oki_load_rbs_pvt.g_program_update_date ) ;
136:
137:
138: EXCEPTION

Line 135: , oki_load_rbs_pvt.g_program_update_date ) ;

131: , p_contract_count
132: , oki_load_rbs_pvt.g_request_id
133: , oki_load_rbs_pvt.g_program_application_id
134: , oki_load_rbs_pvt.g_program_id
135: , oki_load_rbs_pvt.g_program_update_date ) ;
136:
137:
138: EXCEPTION
139: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

Line 139: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

135: , oki_load_rbs_pvt.g_program_update_date ) ;
136:
137:
138: EXCEPTION
139: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
140: l_sqlcode := SQLCODE ;
141: l_sqlerrm := SQLERRM ;
142:
143: -- Set return code to error

Line 205: , request_id = oki_load_rbs_pvt.g_request_id

201:
202: UPDATE oki_renew_by_statuses SET
203: base_amount = p_base_amount
204: , contract_count = p_contract_count
205: , request_id = oki_load_rbs_pvt.g_request_id
206: , program_application_id = oki_load_rbs_pvt.g_program_application_id
207: , program_id = oki_load_rbs_pvt.g_program_id
208: , program_update_date = oki_load_rbs_pvt.g_program_update_date
209: WHERE ROWID = p_rowid ;

Line 206: , program_application_id = oki_load_rbs_pvt.g_program_application_id

202: UPDATE oki_renew_by_statuses SET
203: base_amount = p_base_amount
204: , contract_count = p_contract_count
205: , request_id = oki_load_rbs_pvt.g_request_id
206: , program_application_id = oki_load_rbs_pvt.g_program_application_id
207: , program_id = oki_load_rbs_pvt.g_program_id
208: , program_update_date = oki_load_rbs_pvt.g_program_update_date
209: WHERE ROWID = p_rowid ;
210:

Line 207: , program_id = oki_load_rbs_pvt.g_program_id

203: base_amount = p_base_amount
204: , contract_count = p_contract_count
205: , request_id = oki_load_rbs_pvt.g_request_id
206: , program_application_id = oki_load_rbs_pvt.g_program_application_id
207: , program_id = oki_load_rbs_pvt.g_program_id
208: , program_update_date = oki_load_rbs_pvt.g_program_update_date
209: WHERE ROWID = p_rowid ;
210:
211:

Line 208: , program_update_date = oki_load_rbs_pvt.g_program_update_date

204: , contract_count = p_contract_count
205: , request_id = oki_load_rbs_pvt.g_request_id
206: , program_application_id = oki_load_rbs_pvt.g_program_application_id
207: , program_id = oki_load_rbs_pvt.g_program_id
208: , program_update_date = oki_load_rbs_pvt.g_program_update_date
209: WHERE ROWID = p_rowid ;
210:
211:
212: EXCEPTION

Line 224: , value => 'OKI_LOAD_RBS_PVT.UPD_RNWL_BY_STAT');

220: fnd_message.set_name( application => 'OKI'
221: , name => 'OKI_UNEXPECTED_FAILURE');
222:
223: fnd_message.set_token( token => 'OBJECT_NAME'
224: , value => 'OKI_LOAD_RBS_PVT.UPD_RNWL_BY_STAT');
225:
226: fnd_file.put_line( which => fnd_file.log
227: , buff => fnd_message.get);
228:

Line 440: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

436: CLOSE l_expired_amt_csr ;
437:
438: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
439: -- Determine if the record is a new one or an existing one
440: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
441: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
442: 'EXPIRED', rec_l_org_id_csr.scs_code ) ;
443: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
444: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 443: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

439: -- Determine if the record is a new one or an existing one
440: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
441: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
442: 'EXPIRED', rec_l_org_id_csr.scs_code ) ;
443: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
444: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
445: l_loc := 'Insert the new record.' ;
446: -- Insert the current period data for the period
447: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 444: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

440: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
441: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
442: 'EXPIRED', rec_l_org_id_csr.scs_code ) ;
443: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
444: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
445: l_loc := 'Insert the new record.' ;
446: -- Insert the current period data for the period
447: oki_load_rbs_pvt.ins_rnwl_by_stat(
448: p_period_name => rec_g_glpr_csr.period_name

Line 447: oki_load_rbs_pvt.ins_rnwl_by_stat(

443: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
444: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
445: l_loc := 'Insert the new record.' ;
446: -- Insert the current period data for the period
447: oki_load_rbs_pvt.ins_rnwl_by_stat(
448: p_period_name => rec_g_glpr_csr.period_name
449: , p_period_set_name => rec_g_glpr_csr.period_set_name
450: , p_period_type => rec_g_glpr_csr.period_type
451: , p_authoring_org_id => rec_l_org_id_csr.authoring_org_id

Line 461: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

457: , x_retcode => l_retcode ) ;
458:
459: IF l_retcode = '2' THEN
460: -- Load failed, exit immediately.
461: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
462: END IF ;
463:
464: ELSE
465: l_loc := 'Update the existing record.' ;

Line 467: oki_load_rbs_pvt.upd_rnwl_by_stat(

463:
464: ELSE
465: l_loc := 'Update the existing record.' ;
466: -- Record already exists, so perform an update
467: oki_load_rbs_pvt.upd_rnwl_by_stat(
468: p_base_amount => l_base_contract_amount
469: , p_contract_count => l_contract_count
470: , p_rowid => l_rbs_rowid
471: , x_retcode => l_retcode ) ;

Line 475: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

471: , x_retcode => l_retcode ) ;
472:
473: IF l_retcode = '2' THEN
474: -- Load failed, exit immediately.
475: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
476: END IF ;
477:
478: END IF ;
479: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 479: CLOSE oki_load_rbs_pvt.g_rbs_csr;

475: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
476: END IF ;
477:
478: END IF ;
479: CLOSE oki_load_rbs_pvt.g_rbs_csr;
480:
481:
482: -- Re-initialize the counts and amounts before calculating
483: l_base_contract_amount := 0 ;

Line 499: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

495: CLOSE l_wip_csr;
496:
497: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
498: -- Determine if the record is a new one or an existing one
499: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
500: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
501: 'WIP', rec_l_org_id_csr.scs_code ) ;
502: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
503: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 502: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

498: -- Determine if the record is a new one or an existing one
499: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
500: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
501: 'WIP', rec_l_org_id_csr.scs_code ) ;
502: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
503: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
504: l_loc := 'Insert the new record.' ;
505: -- Insert the current period data for the period
506: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 503: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

499: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
500: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
501: 'WIP', rec_l_org_id_csr.scs_code ) ;
502: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
503: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
504: l_loc := 'Insert the new record.' ;
505: -- Insert the current period data for the period
506: oki_load_rbs_pvt.ins_rnwl_by_stat(
507: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 506: oki_load_rbs_pvt.ins_rnwl_by_stat(

502: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
503: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
504: l_loc := 'Insert the new record.' ;
505: -- Insert the current period data for the period
506: oki_load_rbs_pvt.ins_rnwl_by_stat(
507: p_period_set_name => rec_g_glpr_csr.period_set_name
508: , p_period_name => rec_g_glpr_csr.period_name
509: , p_period_type => rec_g_glpr_csr.period_type
510: , p_authoring_org_id => rec_l_org_id_csr.authoring_org_id

Line 520: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

516: , x_retcode => l_retcode ) ;
517:
518: IF l_retcode = '2' THEN
519: -- Load failed, exit immediately.
520: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
521: END IF ;
522:
523: ELSE
524: l_loc := 'Update the existing record.' ;

Line 526: oki_load_rbs_pvt.upd_rnwl_by_stat(

522:
523: ELSE
524: l_loc := 'Update the existing record.' ;
525: -- Record already exists, so perform an update
526: oki_load_rbs_pvt.upd_rnwl_by_stat(
527: p_base_amount => l_base_contract_amount
528: , p_contract_count => l_contract_count
529: , p_rowid => l_rbs_rowid
530: , x_retcode => l_retcode ) ;

Line 533: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

529: , p_rowid => l_rbs_rowid
530: , x_retcode => l_retcode ) ;
531: IF l_retcode = '2' THEN
532: -- Load failed, exit immediately.
533: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
534: END IF ;
535:
536: END IF;
537: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 537: CLOSE oki_load_rbs_pvt.g_rbs_csr;

533: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
534: END IF ;
535:
536: END IF;
537: CLOSE oki_load_rbs_pvt.g_rbs_csr;
538:
539: -- Re-initialize the counts and amounts before calculating
540: l_base_contract_amount := 0 ;
541: l_contract_count := 0 ;

Line 556: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

552: CLOSE l_signed_csr ;
553:
554: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
555: -- Determine if the record is a new one or an existing one
556: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
557: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
558: 'SIGNED', rec_l_org_id_csr.scs_code ) ;
559: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
560: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 559: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

555: -- Determine if the record is a new one or an existing one
556: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
557: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
558: 'SIGNED', rec_l_org_id_csr.scs_code ) ;
559: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
560: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
561: l_loc := 'Insert the new record.' ;
562: -- Insert the current period data for the period
563: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 560: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

556: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
557: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
558: 'SIGNED', rec_l_org_id_csr.scs_code ) ;
559: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
560: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
561: l_loc := 'Insert the new record.' ;
562: -- Insert the current period data for the period
563: oki_load_rbs_pvt.ins_rnwl_by_stat(
564: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 563: oki_load_rbs_pvt.ins_rnwl_by_stat(

559: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
560: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
561: l_loc := 'Insert the new record.' ;
562: -- Insert the current period data for the period
563: oki_load_rbs_pvt.ins_rnwl_by_stat(
564: p_period_set_name => rec_g_glpr_csr.period_set_name
565: , p_period_name => rec_g_glpr_csr.period_name
566: , p_period_type => rec_g_glpr_csr.period_type
567: , p_authoring_org_id => rec_l_org_id_csr.authoring_org_id

Line 577: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

573: , x_retcode => l_retcode ) ;
574:
575: IF l_retcode = '2' THEN
576: -- Load failed, exit immediately.
577: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
578: END IF ;
579:
580: ELSE
581: l_loc := 'Update the existing record.' ;

Line 583: oki_load_rbs_pvt.upd_rnwl_by_stat(

579:
580: ELSE
581: l_loc := 'Update the existing record.' ;
582: -- Record already exists, so perform an update
583: oki_load_rbs_pvt.upd_rnwl_by_stat(
584: p_base_amount => l_base_contract_amount
585: , p_contract_count => l_contract_count
586: , p_rowid => l_rbs_rowid
587: , x_retcode => l_retcode ) ;

Line 591: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

587: , x_retcode => l_retcode ) ;
588:
589: IF l_retcode = '2' THEN
590: -- Load failed, exit immediately.
591: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
592: END IF ;
593:
594: END IF;
595: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 595: CLOSE oki_load_rbs_pvt.g_rbs_csr;

591: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
592: END IF ;
593:
594: END IF;
595: CLOSE oki_load_rbs_pvt.g_rbs_csr;
596:
597: -- Re-initialize the counts and amounts before calculating
598: l_base_contract_amount := 0 ;
599: l_contract_count := 0 ;

Line 614: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

610: CLOSE l_forecast_csr ;
611:
612: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
613: -- Determine if the record is a new one or an existing one
614: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
615: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
616: 'FORECAST', rec_l_org_id_csr.scs_code ) ;
617: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
618: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 617: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

613: -- Determine if the record is a new one or an existing one
614: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
615: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
616: 'FORECAST', rec_l_org_id_csr.scs_code ) ;
617: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
618: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
619: -- Insert the current period data for the period
620: l_loc := 'Insert the new record.' ;
621: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 618: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

614: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
615: rec_g_glpr_csr.period_name, rec_l_org_id_csr.authoring_org_id,
616: 'FORECAST', rec_l_org_id_csr.scs_code ) ;
617: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
618: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
619: -- Insert the current period data for the period
620: l_loc := 'Insert the new record.' ;
621: oki_load_rbs_pvt.ins_rnwl_by_stat(
622: p_period_name => rec_g_glpr_csr.period_name

Line 621: oki_load_rbs_pvt.ins_rnwl_by_stat(

617: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
618: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
619: -- Insert the current period data for the period
620: l_loc := 'Insert the new record.' ;
621: oki_load_rbs_pvt.ins_rnwl_by_stat(
622: p_period_name => rec_g_glpr_csr.period_name
623: , p_period_set_name => rec_g_glpr_csr.period_set_name
624: , p_period_type => rec_g_glpr_csr.period_type
625: , p_authoring_org_id => rec_l_org_id_csr.authoring_org_id

Line 635: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

631: , x_retcode => l_retcode ) ;
632:
633: IF l_retcode = '2' THEN
634: -- Load failed, exit immediately.
635: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
636: END IF ;
637:
638: ELSE
639: l_loc := 'Update the existing record.' ;

Line 641: oki_load_rbs_pvt.upd_rnwl_by_stat(

637:
638: ELSE
639: l_loc := 'Update the existing record.' ;
640: -- Record already exists, so perform an update
641: oki_load_rbs_pvt.upd_rnwl_by_stat(
642: p_base_amount => l_base_contract_amount
643: , p_contract_count => l_contract_count
644: , p_rowid => l_rbs_rowid
645: , x_retcode => l_retcode ) ;

Line 649: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

645: , x_retcode => l_retcode ) ;
646:
647: IF l_retcode = '2' THEN
648: -- Load failed, exit immediately.
649: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
650: END IF ;
651:
652: END IF ;
653: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

Line 653: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

649: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
650: END IF ;
651:
652: END IF ;
653: CLOSE oki_load_rbs_pvt.g_rbs_csr ;
654: END LOOP rec_g_glpr_csr_loop ;
655: END LOOP l_org_id_csr_loop ;
656:
657: EXCEPTION

Line 658: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

654: END LOOP rec_g_glpr_csr_loop ;
655: END LOOP l_org_id_csr_loop ;
656:
657: EXCEPTION
658: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
659: -- Do not log an error ; It has already been logged.
660: -- Set return code to error
661: x_retcode := '2' ;
662:

Line 674: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1' );

670: fnd_message.set_name( application => 'OKI'
671: , name => 'OKI_UNEXPECTED_FAILURE');
672:
673: fnd_message.set_token( token => 'OBJECT_NAME'
674: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1' );
675:
676: fnd_file.put_line( which => fnd_file.log
677: , buff => fnd_message.get);
678:

Line 889: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

885: CLOSE l_expired_amt_csr ;
886:
887: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
888: -- Determine if the record is a new one or an existing one
889: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
890: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
891: 'EXPIRED', rec_l_scs_csr.scs_code ) ;
892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 890: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

886:
887: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
888: -- Determine if the record is a new one or an existing one
889: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
890: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
891: 'EXPIRED', rec_l_scs_csr.scs_code ) ;
892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
894: l_loc := 'Insert the new record.' ;

Line 892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

888: -- Determine if the record is a new one or an existing one
889: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
890: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
891: 'EXPIRED', rec_l_scs_csr.scs_code ) ;
892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
894: l_loc := 'Insert the new record.' ;
895: -- Insert the current period data for the period
896: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

889: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
890: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
891: 'EXPIRED', rec_l_scs_csr.scs_code ) ;
892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
894: l_loc := 'Insert the new record.' ;
895: -- Insert the current period data for the period
896: oki_load_rbs_pvt.ins_rnwl_by_stat(
897: p_period_name => rec_g_glpr_csr.period_name

Line 896: oki_load_rbs_pvt.ins_rnwl_by_stat(

892: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
893: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
894: l_loc := 'Insert the new record.' ;
895: -- Insert the current period data for the period
896: oki_load_rbs_pvt.ins_rnwl_by_stat(
897: p_period_name => rec_g_glpr_csr.period_name
898: , p_period_set_name => rec_g_glpr_csr.period_set_name
899: , p_period_type => rec_g_glpr_csr.period_type
900: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 900: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

896: oki_load_rbs_pvt.ins_rnwl_by_stat(
897: p_period_name => rec_g_glpr_csr.period_name
898: , p_period_set_name => rec_g_glpr_csr.period_set_name
899: , p_period_type => rec_g_glpr_csr.period_type
900: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
901: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
902: , p_status_code => 'EXPIRED'
903: , p_scs_code => rec_l_scs_csr.scs_code
904: , p_base_amount => l_base_contract_amount

Line 901: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

897: p_period_name => rec_g_glpr_csr.period_name
898: , p_period_set_name => rec_g_glpr_csr.period_set_name
899: , p_period_type => rec_g_glpr_csr.period_type
900: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
901: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
902: , p_status_code => 'EXPIRED'
903: , p_scs_code => rec_l_scs_csr.scs_code
904: , p_base_amount => l_base_contract_amount
905: , p_contract_count => l_contract_count

Line 910: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

906: , x_retcode => l_retcode ) ;
907:
908: IF l_retcode = '2' THEN
909: -- Load failed, exit immediately.
910: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
911: END IF ;
912:
913: ELSE
914: l_loc := 'Update the existing record.' ;

Line 916: oki_load_rbs_pvt.upd_rnwl_by_stat(

912:
913: ELSE
914: l_loc := 'Update the existing record.' ;
915: -- Record already exists, so perform an update
916: oki_load_rbs_pvt.upd_rnwl_by_stat(
917: p_base_amount => l_base_contract_amount
918: , p_contract_count => l_contract_count
919: , p_rowid => l_rbs_rowid
920: , x_retcode => l_retcode ) ;

Line 924: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

920: , x_retcode => l_retcode ) ;
921:
922: IF l_retcode = '2' THEN
923: -- Load failed, exit immediately.
924: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
925: END IF ;
926:
927: END IF ;
928: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 928: CLOSE oki_load_rbs_pvt.g_rbs_csr;

924: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
925: END IF ;
926:
927: END IF ;
928: CLOSE oki_load_rbs_pvt.g_rbs_csr;
929:
930:
931: -- Re-initialize the counts and amounts before calculating
932: l_base_contract_amount := 0 ;

Line 948: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

944: CLOSE l_wip_csr;
945:
946: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
947: -- Determine if the record is a new one or an existing one
948: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
949: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
950: 'WIP', rec_l_scs_csr.scs_code ) ;
951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 949: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

945:
946: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
947: -- Determine if the record is a new one or an existing one
948: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
949: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
950: 'WIP', rec_l_scs_csr.scs_code ) ;
951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
953: l_loc := 'Insert the new record.' ;

Line 951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

947: -- Determine if the record is a new one or an existing one
948: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
949: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
950: 'WIP', rec_l_scs_csr.scs_code ) ;
951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
953: l_loc := 'Insert the new record.' ;
954: -- Insert the current period data for the period
955: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

948: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
949: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
950: 'WIP', rec_l_scs_csr.scs_code ) ;
951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
953: l_loc := 'Insert the new record.' ;
954: -- Insert the current period data for the period
955: oki_load_rbs_pvt.ins_rnwl_by_stat(
956: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 955: oki_load_rbs_pvt.ins_rnwl_by_stat(

951: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
952: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
953: l_loc := 'Insert the new record.' ;
954: -- Insert the current period data for the period
955: oki_load_rbs_pvt.ins_rnwl_by_stat(
956: p_period_set_name => rec_g_glpr_csr.period_set_name
957: , p_period_name => rec_g_glpr_csr.period_name
958: , p_period_type => rec_g_glpr_csr.period_type
959: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 959: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

955: oki_load_rbs_pvt.ins_rnwl_by_stat(
956: p_period_set_name => rec_g_glpr_csr.period_set_name
957: , p_period_name => rec_g_glpr_csr.period_name
958: , p_period_type => rec_g_glpr_csr.period_type
959: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
960: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
961: , p_status_code => 'WIP'
962: , p_scs_code => rec_l_scs_csr.scs_code
963: , p_base_amount => l_base_contract_amount

Line 960: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

956: p_period_set_name => rec_g_glpr_csr.period_set_name
957: , p_period_name => rec_g_glpr_csr.period_name
958: , p_period_type => rec_g_glpr_csr.period_type
959: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
960: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
961: , p_status_code => 'WIP'
962: , p_scs_code => rec_l_scs_csr.scs_code
963: , p_base_amount => l_base_contract_amount
964: , p_contract_count => l_contract_count

Line 969: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

965: , x_retcode => l_retcode ) ;
966:
967: IF l_retcode = '2' THEN
968: -- Load failed, exit immediately.
969: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
970: END IF ;
971:
972: ELSE
973: l_loc := 'Update the existing record.' ;

Line 975: oki_load_rbs_pvt.upd_rnwl_by_stat(

971:
972: ELSE
973: l_loc := 'Update the existing record.' ;
974: -- Record already exists, so perform an update
975: oki_load_rbs_pvt.upd_rnwl_by_stat(
976: p_base_amount => l_base_contract_amount
977: , p_contract_count => l_contract_count
978: , p_rowid => l_rbs_rowid
979: , x_retcode => l_retcode ) ;

Line 982: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

978: , p_rowid => l_rbs_rowid
979: , x_retcode => l_retcode ) ;
980: IF l_retcode = '2' THEN
981: -- Load failed, exit immediately.
982: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
983: END IF ;
984:
985: END IF;
986: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 986: CLOSE oki_load_rbs_pvt.g_rbs_csr;

982: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
983: END IF ;
984:
985: END IF;
986: CLOSE oki_load_rbs_pvt.g_rbs_csr;
987:
988:
989: -- Re-initialize the counts and amounts before calculating
990: l_base_contract_amount := 0 ;

Line 1006: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1002: CLOSE l_signed_csr ;
1003:
1004: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1005: -- Determine if the record is a new one or an existing one
1006: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1007: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1008: 'SIGNED', rec_l_scs_csr.scs_code ) ;
1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1007: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1003:
1004: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1005: -- Determine if the record is a new one or an existing one
1006: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1007: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1008: 'SIGNED', rec_l_scs_csr.scs_code ) ;
1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1011: l_loc := 'Insert the new record.' ;

Line 1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

1005: -- Determine if the record is a new one or an existing one
1006: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1007: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1008: 'SIGNED', rec_l_scs_csr.scs_code ) ;
1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1011: l_loc := 'Insert the new record.' ;
1012: -- Insert the current period data for the period
1013: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1006: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1007: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1008: 'SIGNED', rec_l_scs_csr.scs_code ) ;
1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1011: l_loc := 'Insert the new record.' ;
1012: -- Insert the current period data for the period
1013: oki_load_rbs_pvt.ins_rnwl_by_stat(
1014: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 1013: oki_load_rbs_pvt.ins_rnwl_by_stat(

1009: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1010: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1011: l_loc := 'Insert the new record.' ;
1012: -- Insert the current period data for the period
1013: oki_load_rbs_pvt.ins_rnwl_by_stat(
1014: p_period_set_name => rec_g_glpr_csr.period_set_name
1015: , p_period_name => rec_g_glpr_csr.period_name
1016: , p_period_type => rec_g_glpr_csr.period_type
1017: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1017: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1013: oki_load_rbs_pvt.ins_rnwl_by_stat(
1014: p_period_set_name => rec_g_glpr_csr.period_set_name
1015: , p_period_name => rec_g_glpr_csr.period_name
1016: , p_period_type => rec_g_glpr_csr.period_type
1017: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1018: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1019: , p_status_code => 'SIGNED'
1020: , p_scs_code => rec_l_scs_csr.scs_code
1021: , p_base_amount => l_base_contract_amount

Line 1018: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1014: p_period_set_name => rec_g_glpr_csr.period_set_name
1015: , p_period_name => rec_g_glpr_csr.period_name
1016: , p_period_type => rec_g_glpr_csr.period_type
1017: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1018: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1019: , p_status_code => 'SIGNED'
1020: , p_scs_code => rec_l_scs_csr.scs_code
1021: , p_base_amount => l_base_contract_amount
1022: , p_contract_count => l_contract_count

Line 1027: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1023: , x_retcode => l_retcode ) ;
1024:
1025: IF l_retcode = '2' THEN
1026: -- Load failed, exit immediately.
1027: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1028: END IF ;
1029:
1030: ELSE
1031: l_loc := 'Update the existing record.' ;

Line 1033: oki_load_rbs_pvt.upd_rnwl_by_stat(

1029:
1030: ELSE
1031: l_loc := 'Update the existing record.' ;
1032: -- Record already exists, so perform an update
1033: oki_load_rbs_pvt.upd_rnwl_by_stat(
1034: p_base_amount => l_base_contract_amount
1035: , p_contract_count => l_contract_count
1036: , p_rowid => l_rbs_rowid
1037: , x_retcode => l_retcode ) ;

Line 1041: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1037: , x_retcode => l_retcode ) ;
1038:
1039: IF l_retcode = '2' THEN
1040: -- Load failed, exit immediately.
1041: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1042: END IF ;
1043:
1044: END IF;
1045: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

Line 1045: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

1041: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1042: END IF ;
1043:
1044: END IF;
1045: CLOSE oki_load_rbs_pvt.g_rbs_csr ;
1046:
1047: -- Re-initialize the counts and amounts before calculating
1048: l_base_contract_amount := 0 ;
1049: l_contract_count := 0 ;

Line 1064: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1060: CLOSE l_forecast_csr ;
1061:
1062: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1063: -- Determine if the record is a new one or an existing one
1064: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1065: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1066: 'FORECAST', rec_l_scs_csr.scs_code ) ;
1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1065: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1061:
1062: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1063: -- Determine if the record is a new one or an existing one
1064: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1065: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1066: 'FORECAST', rec_l_scs_csr.scs_code ) ;
1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1069: -- Insert the current period data for the period

Line 1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

1063: -- Determine if the record is a new one or an existing one
1064: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1065: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1066: 'FORECAST', rec_l_scs_csr.scs_code ) ;
1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1069: -- Insert the current period data for the period
1070: l_loc := 'Insert the new record.' ;
1071: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1064: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1065: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1066: 'FORECAST', rec_l_scs_csr.scs_code ) ;
1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1069: -- Insert the current period data for the period
1070: l_loc := 'Insert the new record.' ;
1071: oki_load_rbs_pvt.ins_rnwl_by_stat(
1072: p_period_name => rec_g_glpr_csr.period_name

Line 1071: oki_load_rbs_pvt.ins_rnwl_by_stat(

1067: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1068: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1069: -- Insert the current period data for the period
1070: l_loc := 'Insert the new record.' ;
1071: oki_load_rbs_pvt.ins_rnwl_by_stat(
1072: p_period_name => rec_g_glpr_csr.period_name
1073: , p_period_set_name => rec_g_glpr_csr.period_set_name
1074: , p_period_type => rec_g_glpr_csr.period_type
1075: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1075: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1071: oki_load_rbs_pvt.ins_rnwl_by_stat(
1072: p_period_name => rec_g_glpr_csr.period_name
1073: , p_period_set_name => rec_g_glpr_csr.period_set_name
1074: , p_period_type => rec_g_glpr_csr.period_type
1075: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1076: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1077: , p_status_code => 'FORECAST'
1078: , p_scs_code => rec_l_scs_csr.scs_code
1079: , p_base_amount => l_base_contract_amount

Line 1076: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1072: p_period_name => rec_g_glpr_csr.period_name
1073: , p_period_set_name => rec_g_glpr_csr.period_set_name
1074: , p_period_type => rec_g_glpr_csr.period_type
1075: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1076: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1077: , p_status_code => 'FORECAST'
1078: , p_scs_code => rec_l_scs_csr.scs_code
1079: , p_base_amount => l_base_contract_amount
1080: , p_contract_count => l_contract_count

Line 1085: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1081: , x_retcode => l_retcode ) ;
1082:
1083: IF l_retcode = '2' THEN
1084: -- Load failed, exit immediately.
1085: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1086: END IF ;
1087:
1088: ELSE
1089: l_loc := 'Update the existing record.' ;

Line 1091: oki_load_rbs_pvt.upd_rnwl_by_stat(

1087:
1088: ELSE
1089: l_loc := 'Update the existing record.' ;
1090: -- Record already exists, so perform an update
1091: oki_load_rbs_pvt.upd_rnwl_by_stat(
1092: p_base_amount => l_base_contract_amount
1093: , p_contract_count => l_contract_count
1094: , p_rowid => l_rbs_rowid
1095: , x_retcode => l_retcode ) ;

Line 1099: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1095: , x_retcode => l_retcode ) ;
1096:
1097: IF l_retcode = '2' THEN
1098: -- Load failed, exit immediately.
1099: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1100: END IF ;
1101:
1102: END IF ;
1103: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

Line 1103: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

1099: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1100: END IF ;
1101:
1102: END IF ;
1103: CLOSE oki_load_rbs_pvt.g_rbs_csr ;
1104: END LOOP rec_g_glpr_csr_loop ;
1105: END LOOP l_scs_csr_loop ;
1106:
1107: EXCEPTION

Line 1108: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

1104: END LOOP rec_g_glpr_csr_loop ;
1105: END LOOP l_scs_csr_loop ;
1106:
1107: EXCEPTION
1108: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
1109: -- Do not log an error ; It has already been logged.
1110: -- Set return code to error
1111: x_retcode := '2' ;
1112:

Line 1124: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1');

1120: fnd_message.set_name( application => 'OKI'
1121: , name => 'OKI_UNEXPECTED_FAILURE');
1122:
1123: fnd_message.set_token( token => 'OBJECT_NAME'
1124: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_DTL1');
1125:
1126: fnd_file.put_line( which => fnd_file.log
1127: , buff => fnd_message.get);
1128:

Line 1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1297: CLOSE l_expired_amt_csr ;
1298:
1299: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1300: -- Determine if the record is a new one or an existing one
1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;
1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1298:
1299: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1300: -- Determine if the record is a new one or an existing one
1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;
1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1306: l_loc := 'Insert the new record.' ;

Line 1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;

1299: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1300: -- Determine if the record is a new one or an existing one
1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;
1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1306: l_loc := 'Insert the new record.' ;
1307: -- Insert the current period data for the period

Line 1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

1300: -- Determine if the record is a new one or an existing one
1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;
1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1306: l_loc := 'Insert the new record.' ;
1307: -- Insert the current period data for the period
1308: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1301: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1302: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1303: 'EXPIRED', oki_load_rbs_pvt.g_all_scs_code) ;
1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1306: l_loc := 'Insert the new record.' ;
1307: -- Insert the current period data for the period
1308: oki_load_rbs_pvt.ins_rnwl_by_stat(
1309: p_period_name => rec_g_glpr_csr.period_name

Line 1308: oki_load_rbs_pvt.ins_rnwl_by_stat(

1304: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1305: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1306: l_loc := 'Insert the new record.' ;
1307: -- Insert the current period data for the period
1308: oki_load_rbs_pvt.ins_rnwl_by_stat(
1309: p_period_name => rec_g_glpr_csr.period_name
1310: , p_period_set_name => rec_g_glpr_csr.period_set_name
1311: , p_period_type => rec_g_glpr_csr.period_type
1312: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1312: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1308: oki_load_rbs_pvt.ins_rnwl_by_stat(
1309: p_period_name => rec_g_glpr_csr.period_name
1310: , p_period_set_name => rec_g_glpr_csr.period_set_name
1311: , p_period_type => rec_g_glpr_csr.period_type
1312: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1313: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1314: , p_status_code => 'EXPIRED'
1315: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1316: , p_base_amount => l_base_contract_amount

Line 1313: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1309: p_period_name => rec_g_glpr_csr.period_name
1310: , p_period_set_name => rec_g_glpr_csr.period_set_name
1311: , p_period_type => rec_g_glpr_csr.period_type
1312: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1313: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1314: , p_status_code => 'EXPIRED'
1315: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1316: , p_base_amount => l_base_contract_amount
1317: , p_contract_count => l_contract_count

Line 1315: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code

1311: , p_period_type => rec_g_glpr_csr.period_type
1312: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1313: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1314: , p_status_code => 'EXPIRED'
1315: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1316: , p_base_amount => l_base_contract_amount
1317: , p_contract_count => l_contract_count
1318: , x_retcode => l_retcode ) ;
1319:

Line 1322: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1318: , x_retcode => l_retcode ) ;
1319:
1320: IF l_retcode = '2' THEN
1321: -- Load failed, exit immediately.
1322: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1323: END IF ;
1324:
1325: ELSE
1326: l_loc := 'Update the existing record.' ;

Line 1328: oki_load_rbs_pvt.upd_rnwl_by_stat(

1324:
1325: ELSE
1326: l_loc := 'Update the existing record.' ;
1327: -- Record already exists, so perform an update
1328: oki_load_rbs_pvt.upd_rnwl_by_stat(
1329: p_base_amount => l_base_contract_amount
1330: , p_contract_count => l_contract_count
1331: , p_rowid => l_rbs_rowid
1332: , x_retcode => l_retcode ) ;

Line 1336: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1332: , x_retcode => l_retcode ) ;
1333:
1334: IF l_retcode = '2' THEN
1335: -- Load failed, exit immediately.
1336: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1337: END IF ;
1338:
1339: END IF ;
1340: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 1340: CLOSE oki_load_rbs_pvt.g_rbs_csr;

1336: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1337: END IF ;
1338:
1339: END IF ;
1340: CLOSE oki_load_rbs_pvt.g_rbs_csr;
1341:
1342: -- Re-initialize the counts and amounts before calculating
1343: l_base_contract_amount := 0 ;
1344: l_contract_count := 0 ;

Line 1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1354: CLOSE l_wip_csr;
1355:
1356: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1357: -- Determine if the record is a new one or an existing one
1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;
1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1355:
1356: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1357: -- Determine if the record is a new one or an existing one
1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;
1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1363: l_loc := 'Insert the new record.' ;

Line 1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;

1356: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1357: -- Determine if the record is a new one or an existing one
1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;
1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1363: l_loc := 'Insert the new record.' ;
1364: -- Insert the current period data for the period

Line 1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;

1357: -- Determine if the record is a new one or an existing one
1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;
1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1363: l_loc := 'Insert the new record.' ;
1364: -- Insert the current period data for the period
1365: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1358: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1359: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1360: 'WIP', oki_load_rbs_pvt.g_all_scs_code ) ;
1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1363: l_loc := 'Insert the new record.' ;
1364: -- Insert the current period data for the period
1365: oki_load_rbs_pvt.ins_rnwl_by_stat(
1366: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 1365: oki_load_rbs_pvt.ins_rnwl_by_stat(

1361: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid;
1362: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1363: l_loc := 'Insert the new record.' ;
1364: -- Insert the current period data for the period
1365: oki_load_rbs_pvt.ins_rnwl_by_stat(
1366: p_period_set_name => rec_g_glpr_csr.period_set_name
1367: , p_period_name => rec_g_glpr_csr.period_name
1368: , p_period_type => rec_g_glpr_csr.period_type
1369: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1369: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1365: oki_load_rbs_pvt.ins_rnwl_by_stat(
1366: p_period_set_name => rec_g_glpr_csr.period_set_name
1367: , p_period_name => rec_g_glpr_csr.period_name
1368: , p_period_type => rec_g_glpr_csr.period_type
1369: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1370: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1371: , p_status_code => 'WIP'
1372: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1373: , p_base_amount => l_base_contract_amount

Line 1370: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1366: p_period_set_name => rec_g_glpr_csr.period_set_name
1367: , p_period_name => rec_g_glpr_csr.period_name
1368: , p_period_type => rec_g_glpr_csr.period_type
1369: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1370: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1371: , p_status_code => 'WIP'
1372: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1373: , p_base_amount => l_base_contract_amount
1374: , p_contract_count => l_contract_count

Line 1372: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code

1368: , p_period_type => rec_g_glpr_csr.period_type
1369: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1370: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1371: , p_status_code => 'WIP'
1372: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1373: , p_base_amount => l_base_contract_amount
1374: , p_contract_count => l_contract_count
1375: , x_retcode => l_retcode ) ;
1376:

Line 1379: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1375: , x_retcode => l_retcode ) ;
1376:
1377: IF l_retcode = '2' THEN
1378: -- Load failed, exit immediately.
1379: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1380: END IF ;
1381:
1382: ELSE
1383: l_loc := 'Update the existing record.' ;

Line 1385: oki_load_rbs_pvt.upd_rnwl_by_stat(

1381:
1382: ELSE
1383: l_loc := 'Update the existing record.' ;
1384: -- Record already exists, so perform an update
1385: oki_load_rbs_pvt.upd_rnwl_by_stat(
1386: p_base_amount => l_base_contract_amount
1387: , p_contract_count => l_contract_count
1388: , p_rowid => l_rbs_rowid
1389: , x_retcode => l_retcode ) ;

Line 1392: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1388: , p_rowid => l_rbs_rowid
1389: , x_retcode => l_retcode ) ;
1390: IF l_retcode = '2' THEN
1391: -- Load failed, exit immediately.
1392: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1393: END IF ;
1394:
1395: END IF;
1396: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 1396: CLOSE oki_load_rbs_pvt.g_rbs_csr;

1392: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1393: END IF ;
1394:
1395: END IF;
1396: CLOSE oki_load_rbs_pvt.g_rbs_csr;
1397:
1398: -- Re-initialize the counts and amounts before calculating
1399: l_base_contract_amount := 0 ;
1400: l_contract_count := 0 ;

Line 1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1410: CLOSE l_signed_csr ;
1411:
1412: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1413: -- Determine if the record is a new one or an existing one
1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;
1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1411:
1412: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1413: -- Determine if the record is a new one or an existing one
1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;
1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1419: l_loc := 'Insert the new record.' ;

Line 1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;

1412: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1413: -- Determine if the record is a new one or an existing one
1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;
1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1419: l_loc := 'Insert the new record.' ;
1420: -- Insert the current period data for the period

Line 1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

1413: -- Determine if the record is a new one or an existing one
1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;
1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1419: l_loc := 'Insert the new record.' ;
1420: -- Insert the current period data for the period
1421: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1414: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1415: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1416: 'SIGNED', oki_load_rbs_pvt.g_all_scs_code ) ;
1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1419: l_loc := 'Insert the new record.' ;
1420: -- Insert the current period data for the period
1421: oki_load_rbs_pvt.ins_rnwl_by_stat(
1422: p_period_set_name => rec_g_glpr_csr.period_set_name

Line 1421: oki_load_rbs_pvt.ins_rnwl_by_stat(

1417: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1418: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1419: l_loc := 'Insert the new record.' ;
1420: -- Insert the current period data for the period
1421: oki_load_rbs_pvt.ins_rnwl_by_stat(
1422: p_period_set_name => rec_g_glpr_csr.period_set_name
1423: , p_period_name => rec_g_glpr_csr.period_name
1424: , p_period_type => rec_g_glpr_csr.period_type
1425: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1425: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1421: oki_load_rbs_pvt.ins_rnwl_by_stat(
1422: p_period_set_name => rec_g_glpr_csr.period_set_name
1423: , p_period_name => rec_g_glpr_csr.period_name
1424: , p_period_type => rec_g_glpr_csr.period_type
1425: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1426: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1427: , p_status_code => 'SIGNED'
1428: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1429: , p_base_amount => l_base_contract_amount

Line 1426: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1422: p_period_set_name => rec_g_glpr_csr.period_set_name
1423: , p_period_name => rec_g_glpr_csr.period_name
1424: , p_period_type => rec_g_glpr_csr.period_type
1425: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1426: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1427: , p_status_code => 'SIGNED'
1428: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1429: , p_base_amount => l_base_contract_amount
1430: , p_contract_count => l_contract_count

Line 1428: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code

1424: , p_period_type => rec_g_glpr_csr.period_type
1425: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1426: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1427: , p_status_code => 'SIGNED'
1428: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1429: , p_base_amount => l_base_contract_amount
1430: , p_contract_count => l_contract_count
1431: , x_retcode => l_retcode ) ;
1432:

Line 1435: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1431: , x_retcode => l_retcode ) ;
1432:
1433: IF l_retcode = '2' THEN
1434: -- Load failed, exit immediately.
1435: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1436: END IF ;
1437:
1438: ELSE
1439: l_loc := 'Update the existing record.' ;

Line 1441: oki_load_rbs_pvt.upd_rnwl_by_stat(

1437:
1438: ELSE
1439: l_loc := 'Update the existing record.' ;
1440: -- Record already exists, so perform an update
1441: oki_load_rbs_pvt.upd_rnwl_by_stat(
1442: p_base_amount => l_base_contract_amount
1443: , p_contract_count => l_contract_count
1444: , p_rowid => l_rbs_rowid
1445: , x_retcode => l_retcode ) ;

Line 1449: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1445: , x_retcode => l_retcode ) ;
1446:
1447: IF l_retcode = '2' THEN
1448: -- Load failed, exit immediately.
1449: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1450: END IF ;
1451:
1452: END IF;
1453: CLOSE oki_load_rbs_pvt.g_rbs_csr;

Line 1453: CLOSE oki_load_rbs_pvt.g_rbs_csr;

1449: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1450: END IF ;
1451:
1452: END IF;
1453: CLOSE oki_load_rbs_pvt.g_rbs_csr;
1454:
1455: -- Re-initialize the counts and amounts before calculating
1456: l_base_contract_amount := 0 ;
1457: l_contract_count := 0 ;

Line 1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,

1467: CLOSE l_forecast_csr ;
1468:
1469: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1470: -- Determine if the record is a new one or an existing one
1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;
1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

Line 1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,

1468:
1469: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1470: -- Determine if the record is a new one or an existing one
1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;
1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1476: -- Insert the current period data for the period

Line 1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;

1469: l_loc := 'Opening cursor to determine if insert or update should occur.' ;
1470: -- Determine if the record is a new one or an existing one
1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;
1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1476: -- Insert the current period data for the period
1477: l_loc := 'Insert the new record.' ;

Line 1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;

1470: -- Determine if the record is a new one or an existing one
1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;
1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1476: -- Insert the current period data for the period
1477: l_loc := 'Insert the new record.' ;
1478: oki_load_rbs_pvt.ins_rnwl_by_stat(

Line 1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN

1471: OPEN oki_load_rbs_pvt.g_rbs_csr( rec_g_glpr_csr.period_set_name,
1472: rec_g_glpr_csr.period_name, oki_load_rbs_pvt.g_all_org_id,
1473: 'FORECAST', oki_load_rbs_pvt.g_all_scs_code ) ;
1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1476: -- Insert the current period data for the period
1477: l_loc := 'Insert the new record.' ;
1478: oki_load_rbs_pvt.ins_rnwl_by_stat(
1479: p_period_name => rec_g_glpr_csr.period_name

Line 1478: oki_load_rbs_pvt.ins_rnwl_by_stat(

1474: FETCH oki_load_rbs_pvt.g_rbs_csr INTO l_rbs_rowid ;
1475: IF oki_load_rbs_pvt.g_rbs_csr%NOTFOUND THEN
1476: -- Insert the current period data for the period
1477: l_loc := 'Insert the new record.' ;
1478: oki_load_rbs_pvt.ins_rnwl_by_stat(
1479: p_period_name => rec_g_glpr_csr.period_name
1480: , p_period_set_name => rec_g_glpr_csr.period_set_name
1481: , p_period_type => rec_g_glpr_csr.period_type
1482: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

Line 1482: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id

1478: oki_load_rbs_pvt.ins_rnwl_by_stat(
1479: p_period_name => rec_g_glpr_csr.period_name
1480: , p_period_set_name => rec_g_glpr_csr.period_set_name
1481: , p_period_type => rec_g_glpr_csr.period_type
1482: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1483: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1484: , p_status_code => 'FORECAST'
1485: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1486: , p_base_amount => l_base_contract_amount

Line 1483: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name

1479: p_period_name => rec_g_glpr_csr.period_name
1480: , p_period_set_name => rec_g_glpr_csr.period_set_name
1481: , p_period_type => rec_g_glpr_csr.period_type
1482: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1483: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1484: , p_status_code => 'FORECAST'
1485: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1486: , p_base_amount => l_base_contract_amount
1487: , p_contract_count => l_contract_count

Line 1485: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code

1481: , p_period_type => rec_g_glpr_csr.period_type
1482: , p_authoring_org_id => oki_load_rbs_pvt.g_all_org_id
1483: , p_authoring_org_name => oki_load_rbs_pvt.g_all_org_name
1484: , p_status_code => 'FORECAST'
1485: , p_scs_code => oki_load_rbs_pvt.g_all_scs_code
1486: , p_base_amount => l_base_contract_amount
1487: , p_contract_count => l_contract_count
1488: , x_retcode => l_retcode ) ;
1489:

Line 1492: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1488: , x_retcode => l_retcode ) ;
1489:
1490: IF l_retcode = '2' THEN
1491: -- Load failed, exit immediately.
1492: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1493: END IF ;
1494:
1495: ELSE
1496: l_loc := 'Update the existing record.' ;

Line 1498: oki_load_rbs_pvt.upd_rnwl_by_stat(

1494:
1495: ELSE
1496: l_loc := 'Update the existing record.' ;
1497: -- Record already exists, so perform an update
1498: oki_load_rbs_pvt.upd_rnwl_by_stat(
1499: p_base_amount => l_base_contract_amount
1500: , p_contract_count => l_contract_count
1501: , p_rowid => l_rbs_rowid
1502: , x_retcode => l_retcode ) ;

Line 1506: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1502: , x_retcode => l_retcode ) ;
1503:
1504: IF l_retcode = '2' THEN
1505: -- Load failed, exit immediately.
1506: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1507: END IF ;
1508:
1509: END IF ;
1510: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

Line 1510: CLOSE oki_load_rbs_pvt.g_rbs_csr ;

1506: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1507: END IF ;
1508:
1509: END IF ;
1510: CLOSE oki_load_rbs_pvt.g_rbs_csr ;
1511: END LOOP ;
1512:
1513: EXCEPTION
1514: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

Line 1514: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

1510: CLOSE oki_load_rbs_pvt.g_rbs_csr ;
1511: END LOOP ;
1512:
1513: EXCEPTION
1514: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
1515: -- Do not log an error ; It has already been logged.
1516: -- Set return code to error
1517: x_retcode := '2' ;
1518:

Line 1530: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_SUM');

1526: fnd_message.set_name( application => 'OKI'
1527: , name => 'OKI_UNEXPECTED_FAILURE');
1528:
1529: fnd_message.set_token( token => 'OBJECT_NAME'
1530: , value => 'OKI_LOAD_RBS_PVT.OKI_CALC_RBS_SUM');
1531:
1532: fnd_file.put_line( which => fnd_file.log
1533: , buff => fnd_message.get);
1534:

Line 1590: SAVEPOINT oki_load_rbs_pvt_crt_rnwl_cst ;

1586:
1587:
1588: BEGIN
1589:
1590: SAVEPOINT oki_load_rbs_pvt_crt_rnwl_cst ;
1591:
1592: -- initialize return code to success
1593: l_retcode := '0' ;
1594: x_retcode := '0' ;

Line 1597: oki_load_rbs_pvt.calc_rbs_dtl1(

1593: l_retcode := '0' ;
1594: x_retcode := '0' ;
1595:
1596: -- Procedure to calculate the counts and amounts for each dimension
1597: oki_load_rbs_pvt.calc_rbs_dtl1(
1598: p_period_set_name => p_period_set_name
1599: , p_period_type => p_period_type
1600: , p_summary_build_date => p_summary_build_date
1601: , x_retcode => l_retcode ) ;

Line 1605: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1601: , x_retcode => l_retcode ) ;
1602:
1603: IF l_retcode = '2' THEN
1604: -- Load failed, exit immediately.
1605: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1606: END IF ;
1607:
1608: -- Procedure to calculate the counts and amounts across organizations
1609: oki_load_rbs_pvt.calc_rbs_dtl2(

Line 1609: oki_load_rbs_pvt.calc_rbs_dtl2(

1605: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1606: END IF ;
1607:
1608: -- Procedure to calculate the counts and amounts across organizations
1609: oki_load_rbs_pvt.calc_rbs_dtl2(
1610: p_period_set_name => p_period_set_name
1611: , p_period_type => p_period_type
1612: , p_summary_build_date => p_summary_build_date
1613: , x_retcode => l_retcode ) ;

Line 1617: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1613: , x_retcode => l_retcode ) ;
1614:
1615: IF l_retcode = '2' THEN
1616: -- Load failed, exit immediately.
1617: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1618: END IF ;
1619:
1620: -- Procedure to calculate the counts and amounts across organizations
1621: -- and subclasses

Line 1622: oki_load_rbs_pvt.calc_rbs_sum(

1618: END IF ;
1619:
1620: -- Procedure to calculate the counts and amounts across organizations
1621: -- and subclasses
1622: oki_load_rbs_pvt.calc_rbs_sum(
1623: p_period_set_name => p_period_set_name
1624: , p_period_type => p_period_type
1625: , p_summary_build_date => p_summary_build_date
1626: , x_retcode => l_retcode ) ;

Line 1630: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;

1626: , x_retcode => l_retcode ) ;
1627:
1628: IF l_retcode = '2' THEN
1629: -- Load failed, exit immediately.
1630: RAISE oki_load_rbs_pvt.g_excp_exit_immediate ;
1631: END IF ;
1632:
1633: COMMIT ;
1634:

Line 1635: SAVEPOINT oki_load_rbs_pvt_upd_refresh ;

1631: END IF ;
1632:
1633: COMMIT ;
1634:
1635: SAVEPOINT oki_load_rbs_pvt_upd_refresh ;
1636:
1637: -- Table loaded successfully. Log message in concurrent manager
1638: -- log indicating successful load.
1639: fnd_message.set_name( application => 'OKI'

Line 1664: ROLLBACK to oki_load_rbs_pvt_upd_refresh ;

1660: -- Do not log error; It has already been logged by the refreshs
1661: -- program
1662: x_retcode := l_retcode ;
1663:
1664: ROLLBACK to oki_load_rbs_pvt_upd_refresh ;
1665:
1666: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
1667: -- Do not log an error ; It has already been logged.
1668: -- Set return code to error

Line 1666: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN

1662: x_retcode := l_retcode ;
1663:
1664: ROLLBACK to oki_load_rbs_pvt_upd_refresh ;
1665:
1666: WHEN oki_load_rbs_pvt.g_excp_exit_immediate THEN
1667: -- Do not log an error ; It has already been logged.
1668: -- Set return code to error
1669: x_retcode := '2' ;
1670:

Line 1671: ROLLBACK TO oki_load_rbs_pvt_crt_rnwl_cst ;

1667: -- Do not log an error ; It has already been logged.
1668: -- Set return code to error
1669: x_retcode := '2' ;
1670:
1671: ROLLBACK TO oki_load_rbs_pvt_crt_rnwl_cst ;
1672:
1673: WHEN OTHERS THEN
1674:
1675: l_sqlcode := sqlcode ;

Line 1682: ROLLBACK to oki_load_rbs_pvt_crt_rnwl_cst ;

1678: -- Set return code to error
1679: x_retcode := '2' ;
1680:
1681: -- rollback all transactions
1682: ROLLBACK to oki_load_rbs_pvt_crt_rnwl_cst ;
1683:
1684:
1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_UNEXPECTED_FAILURE');

Line 1689: , value => 'OKI_LOAD_RBS_PVT.CRT_RNWL_BY_STAT');

1685: fnd_message.set_name( application => 'OKI'
1686: , name => 'OKI_UNEXPECTED_FAILURE');
1687:
1688: fnd_message.set_token( token => 'OBJECT_NAME'
1689: , value => 'OKI_LOAD_RBS_PVT.CRT_RNWL_BY_STAT');
1690:
1691: fnd_file.put_line( which => fnd_file.log
1692: , buff => fnd_message.get);
1693:

Line 1707: END oki_load_rbs_pvt ;

1703: g_program_application_id := fnd_global.prog_appl_id ;
1704: g_program_id := fnd_global.conc_program_id ;
1705: g_program_update_date := SYSDATE ;
1706:
1707: END oki_load_rbs_pvt ;