DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_PJP_FP_CURR_WRAP

Line 125: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK

121: BEGIN
122:
123: print_time('VALIDATE_SET_PR_PARAMS : Begin.. ');
124:
125: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK
126: ( p_package_name => g_package_name
127: , x_return_status => x_return_status );
128:
129: x_num_rows := 0;

Line 131: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;

127: , x_return_status => x_return_status );
128:
129: x_num_rows := 0;
130:
131: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
132: print_time ( ' Worker id is.. ' || g_worker_id );
133:
134: print_time(' VALIDATE_SET_PR_PARAMS : plan type id is ' || p_plan_type_id );
135: print_time(' p_context is ' || p_context || ' and rbs ver id is ' || p_rbs_version_id );

Line 904: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

900: print_time('VALIDATE_SET_PR_PARAMS : end.. ');
901:
902: EXCEPTION
903: WHEN OTHERS THEN
904: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
905: ( p_package_name => g_package_name
906: , p_procedure_name => ' VALIDATE_SET_PR_PARAMS '
907: , x_return_status => l_return_status ) ;
908:

Line 1128: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

1124:
1125: EXCEPTION
1126:
1127: WHEN OTHERS THEN
1128: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1129: ( p_package_name => g_package_name
1130: , p_procedure_name => ' OBTAIN_RELEASE_LOCKS '
1131: , x_return_status => x_return_status ) ;
1132:

Line 1180: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

1176: FOR UPDATE;
1177:
1178: BEGIN
1179:
1180: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1181: ( p_package_name => g_package_name
1182: , x_return_status => x_return_status ) ;
1183:
1184: print_time ( ' UPDATE_LOCKS: p_context = ' || p_context || ' p_update_mode = ' || NVL(p_update_mode, 'X'));

Line 1610: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

1606: Fnd_Msg_Pub.add_detail(p_message_type=>Fnd_Api.G_RET_STS_ERROR);
1607:
1608: print_time ( ' UPDATE_LOCKS exception ' || SQLERRM);
1609:
1610: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER
1611: ( p_package_name => g_package_name
1612: , p_procedure_name => ' UPDATE_LOCKS '
1613: , x_return_status => x_return_status ) ;
1614:

Line 1618: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

1614:
1615: RAISE;
1616:
1617: WHEN OTHERS THEN
1618: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
1619: ( p_package_name => g_package_name
1620: , p_procedure_name => ' UPDATE_LOCKS '
1621: , x_return_status => x_return_status ) ;
1622:

Line 3645: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

3641: BEGIN
3642:
3643: -- dbms_output.put_line ( ' Begin.. ');
3644:
3645: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3646: ( p_package_name => g_package_name
3647: , x_return_status => l_return_status ) ;
3648:
3649: --

Line 3718: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

3714: */
3715:
3716: EXCEPTION
3717: WHEN OTHERS THEN
3718: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
3719: ( p_package_name => g_package_name
3720: , p_procedure_name => 'RETRIEVE_OVERRIDDEN_WP_ETC'
3721: , x_return_status => l_return_status ) ;
3722:

Line 3742: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

3738: l_msg_count NUMBER;
3739:
3740: BEGIN
3741:
3742: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3743: ( p_package_name => g_package_name
3744: , x_return_status => l_return_status ) ;
3745:
3746: print_time('EXTRACT_PLAN_ETC_PRIRBS : Begin' );

Line 4260: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

4256:
4257:
4258: EXCEPTION
4259: WHEN OTHERS THEN
4260: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
4261: ( p_package_name => g_package_name
4262: , p_procedure_name => 'EXTRACT_PLAN_ETC_PRIRBS'
4263: , x_return_status => l_return_status ) ;
4264:

Line 4280: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

4276: BEGIN
4277:
4278: print_time ( 'DELETE_PLAN_LINES : begin ' );
4279:
4280: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
4281: ( p_package_name => g_package_name
4282: , x_return_status => x_return_status ) ;
4283:
4284: --Bug 6047966.

Line 4317: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

4313: print_time ( 'DELETE_PLAN_LINES : after deletion of plan lines , # rows deleted is ' || SQL%ROWCOUNT );
4314:
4315: EXCEPTION
4316: WHEN OTHERS THEN
4317: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
4318: ( p_package_name => g_package_name
4319: , p_procedure_name => 'DELETE_PLAN_LINES'
4320: , x_return_status => x_return_status ) ;
4321:

Line 4862: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (

4858: BEGIN
4859:
4860: print_time('........GET_GLOBAL_EXCHANGE_RATES: Begin. ' );
4861:
4862: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
4863: x_currency_conversion_rule => g_currency_conversion_rule
4864: , x_prorating_format => g_prorating_format
4865: , x_global1_currency_code => g_global1_currency_code
4866: , x_global2_currency_code => g_global2_currency_code

Line 5247: /* This issue will come only when PJI_PJP_FP_CURR_WRAP.get_ent_dates_info gives a no_data_found error.

5243:
5244: EXCEPTION
5245: WHEN NO_DATA_FOUND THEN
5246:
5247: /* This issue will come only when PJI_PJP_FP_CURR_WRAP.get_ent_dates_info gives a no_data_found error.
5248: updating the plan versions as time dangling so that the plan will be marked as dangling. Not updating
5249: the existing records so that data for the primary calendar is not impacted because of issue in proration to
5250: other calendars */
5251:

Line 5269: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (

5265: PROCEDURE PRORATE_TO_ENT IS
5266: l_calendar_type VARCHAR2(15) := 'E';
5267: BEGIN
5268:
5269: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
5270: x_currency_conversion_rule => g_currency_conversion_rule
5271: , x_prorating_format => g_prorating_format
5272: , x_global1_currency_code => g_global1_currency_code
5273: , x_global2_currency_code => g_global2_currency_code

Line 5278: PJI_PJP_FP_CURR_WRAP.get_ent_dates_info (

5274: , x_global1_currency_mau => g_global1_currency_mau
5275: , x_global2_currency_mau => g_global2_currency_mau ) ;
5276:
5277:
5278: PJI_PJP_FP_CURR_WRAP.get_ent_dates_info (
5279: x_global_start_date => g_global_start_date
5280: , x_ent_start_period_id => g_ent_start_period_id
5281: , x_ent_start_period_name => g_ent_start_period_name
5282: , x_ent_start_date => g_ent_start_date

Line 5326: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (

5322: ELSE RETURN;
5323: END IF;
5324:
5325:
5326: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
5327: x_currency_conversion_rule => g_currency_conversion_rule
5328: , x_prorating_format => g_prorating_format
5329: , x_global1_currency_code => g_global1_currency_code
5330: , x_global2_currency_code => g_global2_currency_code

Line 5335: PJI_PJP_FP_CURR_WRAP.get_ent_dates_info (

5331: , x_global1_currency_mau => g_global1_currency_mau
5332: , x_global2_currency_mau => g_global2_currency_mau ) ;
5333:
5334:
5335: PJI_PJP_FP_CURR_WRAP.get_ent_dates_info (
5336: x_global_start_date => g_global_start_date
5337: , x_ent_start_period_id => g_ent_start_period_id
5338: , x_ent_start_period_name => g_ent_start_period_name
5339: , x_ent_start_date => g_ent_start_date

Line 7559: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

7555: */
7556:
7557: EXCEPTION
7558: WHEN OTHERS THEN
7559: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
7560: ( p_package_name => g_package_name
7561: , p_procedure_name => 'PRINT_NUM_WBSRLPRCDS_INPJP1'
7562: , x_return_status => l_return_status ) ;
7563:

Line 7600: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);

7596: -- Print time API to measure time taken by each api. Also useful for debugging.
7597: ----------
7598: PROCEDURE PRINT_TIME(p_tag IN VARCHAR2) IS
7599: BEGIN
7600: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
7601: EXCEPTION
7602: WHEN OTHERS THEN
7603: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7604: p_procedure_name => 'PRINT_TIME');

Line 7615: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (

7611: BEGIN
7612:
7613: print_time ( ' EXTRACT_PLAN_AMTS_SECRBS_GLC12 begin. ' );
7614:
7615: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
7616: x_currency_conversion_rule => g_currency_conversion_rule
7617: , x_prorating_format => g_prorating_format
7618: , x_global1_currency_code => g_global1_currency_code
7619: , x_global2_currency_code => g_global2_currency_code

Line 8780: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (

8776: BEGIN
8777:
8778: print_time ( ' EXTRACT_PLAN_AMTS_PRIRBS_GLC12 begin. ' );
8779:
8780: PJI_PJP_FP_CURR_WRAP.get_global_currency_info (
8781: x_currency_conversion_rule => g_currency_conversion_rule
8782: , x_prorating_format => g_prorating_format
8783: , x_global1_currency_code => g_global1_currency_code
8784: , x_global2_currency_code => g_global2_currency_code

Line 10654: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK

10650: l_extract_etc VARCHAR2(1) := NULL; -- 4682341
10651:
10652: BEGIN
10653:
10654: PJI_PJP_FP_CURR_WRAP.INIT_ERR_STACK
10655: ( p_package_name => g_package_name
10656: , x_return_status => x_return_status );
10657:
10658: IF (p_extrn_type NOT IN ('FULL', 'INCREMENTAL', 'RBS', 'PARTIAL')) THEN

Line 11132: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER

11128: -- DELETE PLAN LINES.
11129:
11130: EXCEPTION
11131: WHEN OTHERS THEN
11132: PJI_PJP_FP_CURR_WRAP.EXCP_HANDLER
11133: ( p_package_name => g_package_name
11134: , p_procedure_name => ' PROCESS_PENDING_PLAN_UPDATES '
11135: , x_return_status => x_return_status ) ;
11136:

Line 11667: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;

11663: -- bug 6063826
11664:
11665: BEGIN -- this portion is executed WHENever the package is initialized
11666:
11667: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
11668:
11669: END PJI_FM_PLAN_MAINT_PVT;