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.8 2011/06/20 10:03:13 tvala 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.8 2011/06/20 10:03:13 tvala 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 3662: Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK (

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

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

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

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

4481:
4482: BEGIN
4483:
4484: -- Set the error stack.
4485: pa_debug.set_err_stack('PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS');
4486:
4487: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
4488: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4489:

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

4845: IF c_valid_project_number_entry%ISOPEN THEN
4846: CLOSE c_valid_project_number_entry ;
4847: END IF ;
4848:
4849: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
4850: ,p_procedure_name => 'RUN_ACTION_CONC_PROCESS'
4851: ,p_error_text => errbuf);
4852:
4853: IF l_debug_mode = 'Y' THEN

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

5049:
5050: -- Call the validation API. It will
5051: -- perform all the validation.
5052: IF l_debug_mode = 'Y' THEN
5053: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.VALIDATE_ACTIONS';
5054: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5055: END IF ;
5056:
5057: l_name_tbl.extend;

Line 5105: PA_ACTIONS_PUB.VALIDATE_ACTIONS

5101: pa_debug.write(g_module_name,' validating action p_element_version_id_tbl ' || p_element_version_id_tbl(i) ,3) ;
5102: pa_debug.write(g_module_name,' validating action ( version id ) ' || l_element_version_id_tbl(l_count) ,3) ;
5103: END IF ;
5104:
5105: PA_ACTIONS_PUB.VALIDATE_ACTIONS
5106: ( p_init_msg_list => FND_API.G_FALSE
5107: ,p_debug_mode => l_debug_mode
5108: ,p_name_tbl => l_name_tbl
5109: ,p_completed_flag_tbl => l_completed_flag_tbl

Line 5234: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK

5230: pa_debug.g_err_stage:= 'Call UPDATE_DLV_ACTIONS_IN_BULK ';
5231: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5232: END IF;
5233:
5234: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK
5235: (p_api_version => p_api_version
5236: ,p_init_msg_list => FND_API.G_FALSE
5237: ,p_commit => p_commit
5238: ,p_validate_only => p_validate_only

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

5337: IF (p_commit = FND_API.G_TRUE) THEN
5338: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
5339: END IF ;
5340:
5341: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5342: ,p_procedure_name => 'UPD_DLV_ACTIONS_IN_BULK_TM');
5343:
5344: IF p_debug_mode = 'Y' THEN
5345: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

5617: IF (p_commit = FND_API.G_TRUE) THEN
5618: ROLLBACK TO RUN_ACTION_CONC_PROCESS_WRP_SP;
5619: END IF ;
5620:
5621: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5622: ,p_procedure_name => 'RUN_ACTION_CONC_PROCESS_WRP');
5623:
5624: IF p_debug_mode = 'Y' THEN
5625: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5678: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS_WRP

5674: --Bug 3752898
5675: --While Calling this API ,the Message Stack should not be re-initialized.
5676: --If it gets reinitialized it will break fix for Bug # 3134205
5677:
5678: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS_WRP
5679: (
5680: p_calling_module => 'FORMS'
5681: ,p_init_msg_list => FND_API.G_FALSE -- 3752898 , Passing False to avoid re-initialization of Message Stack
5682: ,p_project_id => p_project_id

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

5711: IF c_project_details%ISOPEN THEN
5712: CLOSE c_project_details;
5713: END IF;
5714:
5715: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'
5716: ,p_procedure_name => 'RUN_ACTION_CONC_FRM_WRP');
5717:
5718: RAISE;
5719: END RUN_ACTION_CONC_FRM_WRP;

Line 5721: END PA_ACTIONS_PUB;

5717:
5718: RAISE;
5719: END RUN_ACTION_CONC_FRM_WRP;
5720:
5721: END PA_ACTIONS_PUB;