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

Line 1: PACKAGE BODY PA_ACTIONS_PUB as

1: PACKAGE BODY PA_ACTIONS_PUB as
2: /* $Header: PAACTNPB.pls 120.4.12010000.2 2008/09/18 22:59:09 skkoppul ship $ */
3:
4: Invalid_Arg_Exc_Dlv EXCEPTION ;
5: g_plsql_max_array_size NUMBER := 200 ;

Line 6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';

2: /* $Header: PAACTNPB.pls 120.4.12010000.2 2008/09/18 22:59:09 skkoppul ship $ */
3:
4: Invalid_Arg_Exc_Dlv EXCEPTION ;
5: g_plsql_max_array_size NUMBER := 200 ;
6: g_module_name VARCHAR2(100) := 'pa.plsql.pa_actions_pub';
7: g_insert CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'INSERT' ;
8: g_create CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CREATE' ;
9: g_delete CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'DELETE' ;
10: g_update CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UPDATE' ;

Line 218: pa_debug.g_err_stage:= 'Exiting PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK' ;

214: RAISE Invalid_Arg_Exc_Dlv ;
215: END IF ;
216:
217: IF l_debug_mode = 'Y' THEN
218: pa_debug.g_err_stage:= 'Exiting PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK' ;
219: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
220: pa_debug.reset_curr_function;
221: END IF;
222:

Line 263: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

259: IF (p_commit = FND_API.G_TRUE) THEN
260: ROLLBACK TO CR_DLV_ACTIONS_SP;
261: END IF ;
262:
263: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
264: ,p_procedure_name => 'CREATE_DLV_ACTIONS_IN_BULK');
265:
266: IF p_debug_mode = 'Y' THEN
267: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 504: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

500: IF (p_commit = FND_API.G_TRUE) THEN
501: ROLLBACK TO UP_DLV_ACTIONS_SP;
502: END IF ;
503:
504: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
505: ,p_procedure_name => 'UPDATE_DLV_ACTIONS_IN_BULK');
506:
507: IF p_debug_mode = 'Y' THEN
508: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 657: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

653: IF (p_commit = FND_API.G_TRUE) THEN
654: ROLLBACK TO UP_DLV_ACTIONS_SP;
655: END IF ;
656:
657: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
658: ,p_procedure_name => 'DELETE_DLV_ACTIONS_IN_BULK');
659:
660: IF p_debug_mode = 'Y' THEN
661: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 904: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.VALIDATE_ACTIONS';

900:
901: -- Call the validation API. It will
902: -- perform all the validation.
903: IF l_debug_mode = 'Y' THEN
904: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.VALIDATE_ACTIONS';
905: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
906: END IF ;
907:
908: -- Bug 3651563 ,If p_calling_module is nt passed ,

Line 911: PA_ACTIONS_PUB.VALIDATE_ACTIONS

907:
908: -- Bug 3651563 ,If p_calling_module is nt passed ,
909: -- Whatever validation is done in this API specific to AMG Flow will not get fired
910: -- So,Passing p_calling_module also
911: PA_ACTIONS_PUB.VALIDATE_ACTIONS
912: ( p_init_msg_list => FND_API.G_FALSE
913: ,p_debug_mode => l_debug_mode
914: ,p_calling_module => p_calling_module -- Included by avaithia Bug 3651563
915: ,p_name_tbl => p_name_tbl

Line 1178: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK

1174: pa_debug.g_err_stage:= 'Call DELETE_DLV_ACTIONS_IN_BULK ';
1175: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1176: END IF;
1177:
1178: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK
1179: (p_api_version => p_api_version
1180: ,p_init_msg_list => FND_API.G_FALSE
1181: ,p_commit => p_commit
1182: ,p_validate_only => p_validate_only

Line 1211: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK

1207: pa_debug.g_err_stage:= 'Call UPDATE_DLV_ACTIONS_IN_BULK ';
1208: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1209: END IF;
1210:
1211: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK
1212: (p_api_version => p_api_version
1213: ,p_init_msg_list => FND_API.G_FALSE
1214: ,p_commit => p_commit
1215: ,p_validate_only => p_validate_only

Line 1273: PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK

1269: pa_debug.g_err_stage:= 'Call CREATE_DLV_ACTIONS_IN_BULK ';
1270: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1271: END IF;
1272:
1273: PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK
1274: (p_api_version => p_api_version
1275: ,p_init_msg_list => FND_API.G_FALSE
1276: ,p_commit => p_commit
1277: ,p_validate_only => p_validate_only

Line 1322: pa_debug.write(g_module_name,' return from PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK ['||x_return_status||']',3);

1318: ,x_msg_data => x_msg_data
1319: ) ;
1320:
1321: IF l_debug_mode = 'Y' THEN
1322: pa_debug.write(g_module_name,' return from PA_ACTIONS_PUB.CREATE_DLV_ACTIONS_IN_BULK ['||x_return_status||']',3);
1323: END IF;
1324:
1325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1326: RAISE Invalid_Arg_Exc_Dlv ;

Line 1383: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

1379: IF (p_commit = FND_API.G_TRUE) THEN
1380: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
1381: END IF ;
1382:
1383: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
1384: ,p_procedure_name => 'CR_UP_DLV_ACTIONS_IN_BULK');
1385:
1386: IF p_debug_mode = 'Y' THEN
1387: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2346: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: x_msg_count := 1;
2344: x_msg_data := SQLERRM;
2345:
2346: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
2347: ,p_procedure_name => 'VALIDATE_ACTIONS');
2348:
2349: IF p_debug_mode = 'Y' THEN
2350: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2559: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

2555: IF (p_commit = FND_API.G_TRUE) THEN
2556: ROLLBACK TO DELETE_DLV_ACTIONS_SP;
2557: END IF ;
2558:
2559: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
2560: ,p_procedure_name => 'DELETE_DLV_ACTION');
2561:
2562: IF p_debug_mode = 'Y' THEN
2563: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2755: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

2751: IF (p_commit = FND_API.G_TRUE) THEN
2752: ROLLBACK TO COPY_ACTIONS_SP;
2753: END IF ;
2754:
2755: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
2756: ,p_procedure_name => 'COPY_ACTIONS');
2757:
2758: IF p_debug_mode = 'Y' THEN
2759: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3661: Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK (

3657: END IF;
3658:
3659: -- Invoke the API to create dlvr actions in bulk.
3660:
3661: Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK (
3662: p_init_msg_list => p_init_msg_list
3663: ,p_commit => p_commit
3664: ,p_validate_only => FND_API.G_FALSE
3665: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3710: pa_debug.write(g_module_name,'Returned from Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK ['||x_return_status||']',5);

3706: ,x_msg_count => x_msg_count
3707: ,x_msg_data => x_msg_data);
3708:
3709: IF p_debug_mode = 'Y' THEN
3710: pa_debug.write(g_module_name,'Returned from Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK ['||x_return_status||']',5);
3711: END IF;
3712:
3713: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4416: pa_debug.set_err_stack('PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS');

4412:
4413: BEGIN
4414:
4415: -- Set the error stack.
4416: pa_debug.set_err_stack('PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS');
4417:
4418: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
4419: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4420:

Line 4780: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

4776: IF c_valid_project_number_entry%ISOPEN THEN
4777: CLOSE c_valid_project_number_entry ;
4778: END IF ;
4779:
4780: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
4781: ,p_procedure_name => 'RUN_ACTION_CONC_PROCESS'
4782: ,p_error_text => errbuf);
4783:
4784: IF l_debug_mode = 'Y' THEN

Line 4984: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.VALIDATE_ACTIONS';

4980:
4981: -- Call the validation API. It will
4982: -- perform all the validation.
4983: IF l_debug_mode = 'Y' THEN
4984: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.VALIDATE_ACTIONS';
4985: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4986: END IF ;
4987:
4988: l_name_tbl.extend;

Line 5036: PA_ACTIONS_PUB.VALIDATE_ACTIONS

5032: pa_debug.write(g_module_name,' validating action p_element_version_id_tbl ' || p_element_version_id_tbl(i) ,3) ;
5033: pa_debug.write(g_module_name,' validating action ( version id ) ' || l_element_version_id_tbl(l_count) ,3) ;
5034: END IF ;
5035:
5036: PA_ACTIONS_PUB.VALIDATE_ACTIONS
5037: ( p_init_msg_list => FND_API.G_FALSE
5038: ,p_debug_mode => l_debug_mode
5039: ,p_name_tbl => l_name_tbl
5040: ,p_completed_flag_tbl => l_completed_flag_tbl

Line 5165: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK

5161: pa_debug.g_err_stage:= 'Call UPDATE_DLV_ACTIONS_IN_BULK ';
5162: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5163: END IF;
5164:
5165: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK
5166: (p_api_version => p_api_version
5167: ,p_init_msg_list => FND_API.G_FALSE
5168: ,p_commit => p_commit
5169: ,p_validate_only => p_validate_only

Line 5272: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

5268: IF (p_commit = FND_API.G_TRUE) THEN
5269: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
5270: END IF ;
5271:
5272: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5273: ,p_procedure_name => 'UPD_DLV_ACTIONS_IN_BULK_TM');
5274:
5275: IF p_debug_mode = 'Y' THEN
5276: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5552: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

5548: IF (p_commit = FND_API.G_TRUE) THEN
5549: ROLLBACK TO RUN_ACTION_CONC_PROCESS_WRP_SP;
5550: END IF ;
5551:
5552: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5553: ,p_procedure_name => 'RUN_ACTION_CONC_PROCESS_WRP');
5554:
5555: IF p_debug_mode = 'Y' THEN
5556: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5609: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS_WRP

5605: --Bug 3752898
5606: --While Calling this API ,the Message Stack should not be re-initialized.
5607: --If it gets reinitialized it will break fix for Bug # 3134205
5608:
5609: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS_WRP
5610: (
5611: p_calling_module => 'FORMS'
5612: ,p_init_msg_list => FND_API.G_FALSE -- 3752898 , Passing False to avoid re-initialization of Message Stack
5613: ,p_project_id => p_project_id

Line 5646: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

5642: IF c_project_details%ISOPEN THEN
5643: CLOSE c_project_details;
5644: END IF;
5645:
5646: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5647: ,p_procedure_name => 'RUN_ACTION_CONC_FRM_WRP');
5648:
5649: RAISE;
5650: END RUN_ACTION_CONC_FRM_WRP;

Line 5652: END PA_ACTIONS_PUB;

5648:
5649: RAISE;
5650: END RUN_ACTION_CONC_FRM_WRP;
5651:
5652: END PA_ACTIONS_PUB;