DBA Data[Home] [Help]

APPS.PA_ACTIONS_PUB dependencies on FND_MSG_PUB

Line 147: FND_MSG_PUB.initialize;

143: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
144: END IF;
145:
146: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149:
150: IF (p_commit = FND_API.G_TRUE) THEN
151: savepoint CR_DLV_ACTIONS_SP ;

Line 226: l_msg_count := FND_MSG_PUB.count_msg;

222:
223: EXCEPTION
224: WHEN Invalid_Arg_Exc_Dlv THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: l_msg_count := FND_MSG_PUB.count_msg;
227:
228: IF (p_commit = FND_API.G_TRUE) THEN
229: ROLLBACK TO CR_DLV_ACTIONS_SP;
230: END IF ;

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 394: FND_MSG_PUB.initialize;

390: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
391: END IF;
392:
393: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: IF (p_commit = FND_API.G_TRUE) THEN
398: savepoint UP_DLV_ACTIONS_SP ;

Line 467: l_msg_count := FND_MSG_PUB.count_msg;

463:
464: EXCEPTION
465: WHEN Invalid_Arg_Exc_Dlv THEN
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: l_msg_count := FND_MSG_PUB.count_msg;
468:
469: IF (p_commit = FND_API.G_TRUE) THEN
470: ROLLBACK TO UP_DLV_ACTIONS_SP;
471: END IF ;

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 578: FND_MSG_PUB.initialize;

574: END IF;
575:
576:
577: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
578: FND_MSG_PUB.initialize;
579: END IF;
580:
581: IF (p_commit = FND_API.G_TRUE) THEN
582: savepoint DEL_DLV_ACTIONS_SP ;

Line 620: l_msg_count := FND_MSG_PUB.count_msg;

616:
617: EXCEPTION
618: WHEN Invalid_Arg_Exc_Dlv THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: l_msg_count := FND_MSG_PUB.count_msg;
621:
622: IF (p_commit = FND_API.G_TRUE) THEN
623: ROLLBACK TO DEL_DLV_ACTIONS_SP;
624: END IF ;

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 875: FND_MSG_PUB.initialize;

871: pa_debug.write(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,3) ;
872: END IF;
873:
874: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
875: FND_MSG_PUB.initialize;
876: END IF;
877:
878: IF (p_commit = FND_API.G_TRUE) THEN
879: savepoint CR_UP_DLV_ACTIONS_SP ;

Line 1342: l_msg_count := FND_MSG_PUB.count_msg;

1338:
1339: EXCEPTION
1340: WHEN Invalid_Arg_Exc_Dlv THEN
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: l_msg_count := FND_MSG_PUB.count_msg;
1343:
1344: IF (p_commit = FND_API.G_TRUE) THEN
1345: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
1346: END IF ;

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 1571: FND_MSG_PUB.initialize;

1567: pa_debug.write(g_module_name,'p_object_type'||':'||p_object_type,3) ;
1568: END IF;
1569:
1570: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1571: FND_MSG_PUB.initialize;
1572: END IF;
1573:
1574: IF p_object_type = g_deliverables THEN
1575:

Line 2013: x_msg_count := FND_MSG_PUB.count_msg ;

2009: END IF ; -- If p_user_action_tbl(i) <> g_unmodified
2010: END LOOP ;
2011: END IF ;
2012:
2013: x_msg_count := FND_MSG_PUB.count_msg ;
2014: IF x_msg_count > 0 THEN
2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: END IF ;
2017: /* ==============3435905 : FP M : Deliverables Changes For AMG - Start * =========================*/

Line 2303: x_msg_count := FND_MSG_PUB.count_msg ;

2299: /* Bug 3651563 Very Important Fix .Please do not add any code after the following statements
2300: because if some message is there in the error stack
2301: before exiting this API,x_return_status should be set as 'ERROR'*/
2302:
2303: x_msg_count := FND_MSG_PUB.count_msg ;
2304: IF x_msg_count > 0 THEN
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306: END IF ;
2307:

Line 2317: l_msg_count := FND_MSG_PUB.count_msg;

2313:
2314: EXCEPTION
2315: WHEN Invalid_Arg_Exc_Dlv THEN
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: l_msg_count := FND_MSG_PUB.count_msg;
2318:
2319: IF l_debug_mode = 'Y' THEN
2320: pa_debug.g_err_stage := 'inside invalid arg exception of VALIDATE_ACTIONS';
2321: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

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 2443: FND_MSG_PUB.initialize;

2439: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
2440: END IF;
2441:
2442: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2443: FND_MSG_PUB.initialize;
2444: END IF;
2445:
2446: IF (p_commit = FND_API.G_TRUE) THEN
2447: savepoint DELETE_DLV_ACTIONS_SP ;

Line 2522: l_msg_count := FND_MSG_PUB.count_msg;

2518:
2519: EXCEPTION
2520: WHEN Invalid_Arg_Exc_Dlv THEN
2521: x_return_status := FND_API.G_RET_STS_ERROR;
2522: l_msg_count := FND_MSG_PUB.count_msg;
2523:
2524: IF (p_commit = FND_API.G_TRUE) THEN
2525: ROLLBACK TO DELETE_DLV_ACTIONS_SP;
2526: END IF ;

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 2652: FND_MSG_PUB.initialize;

2648: pa_debug.write(g_module_name,'p_target_object_type'||':'||p_target_object_type,3) ;
2649: END IF;
2650:
2651: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2652: FND_MSG_PUB.initialize;
2653: END IF;
2654:
2655: IF (p_commit = FND_API.G_TRUE) THEN
2656: savepoint COPY_ACTIONS_SP ;

Line 2718: l_msg_count := FND_MSG_PUB.count_msg;

2714:
2715: EXCEPTION
2716: WHEN Invalid_Arg_Exc_Dlv THEN
2717: x_return_status := FND_API.G_RET_STS_ERROR;
2718: l_msg_count := FND_MSG_PUB.count_msg;
2719:
2720: IF (p_commit = FND_API.G_TRUE) THEN
2721: ROLLBACK TO COPY_ACTIONS_SP;
2722: END IF ;

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 3173: FND_MSG_PUB.initialize;

3169: END IF;
3170:
3171: -- Initialize the message table if requested.
3172: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
3173: FND_MSG_PUB.initialize;
3174: END IF;
3175:
3176: IF p_debug_mode = 'Y' THEN
3177: PA_DEBUG.set_curr_function( p_function => l_api_name,

Line 3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3284: );
3285:
3286: IF (l_dlvr_action_enabled <> 'Y') THEN
3287:
3288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3289: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_ACTION_NOT_ENABLED') ;
3290: PA_UTILS.ADD_MESSAGE
3291: (p_app_short_name => 'PA',
3292: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 3326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3322: END IF;
3323:
3324: IF p_action_in_tbl(i_actn).action_name IS NULL OR p_action_in_tbl(i_actn).action_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3325:
3326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3327: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_NAME_NULL_ERROR') ;
3328: PA_UTILS.ADD_MESSAGE
3329: (p_app_short_name => 'PA',
3330: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 3579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3575: Open is_lowest_task (l_project_id,l_fin_task_id);
3576: Fetch is_lowest_task INTO l_fin_task_num_tbl(i_actn);
3577:
3578: IF is_lowest_task%NOTFOUND THEN
3579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3580: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_INVALID_LOW_FIN_TASK') ;
3581: PA_UTILS.ADD_MESSAGE
3582: (p_app_short_name => 'PA',
3583: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 3612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3608: Open is_top_task (l_project_id,l_fin_task_id);
3609: Fetch is_top_task INTO l_fin_task_num_tbl(i_actn);
3610:
3611: IF is_top_task%NOTFOUND THEN
3612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3613: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_INVALID_TOP_FIN_TASK') ;
3614: PA_UTILS.ADD_MESSAGE
3615: (p_app_short_name => 'PA',
3616: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 4287: l_msg_count := FND_MSG_PUB.count_msg;

4283: IF (p_commit = FND_API.G_TRUE) THEN
4284: ROLLBACK TO create_dlvr_actions_wrapper;
4285: END IF;
4286: x_return_status := FND_API.G_RET_STS_ERROR;
4287: l_msg_count := FND_MSG_PUB.count_msg;
4288:
4289: IF l_msg_count = 1 AND x_msg_data IS NULL
4290: THEN
4291: PA_INTERFACE_UTILS_PUB.get_messages

Line 4316: l_msg_count := FND_MSG_PUB.count_msg;

4312: IF (p_commit = FND_API.G_TRUE) THEN
4313: ROLLBACK TO create_dlvr_actions_wrapper;
4314: END IF;
4315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4316: l_msg_count := FND_MSG_PUB.count_msg;
4317:
4318: IF l_msg_count = 1 AND x_msg_data IS NULL
4319: THEN
4320: PA_INTERFACE_UTILS_PUB.get_messages

Line 4355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4351: pa_debug.reset_curr_function;
4352: END IF;
4353:
4354:
4355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4356: FND_MSG_PUB.add_exc_msg
4357: ( p_pkg_name => G_PKG_NAME
4358: , p_procedure_name => l_api_name );
4359: END IF;

Line 4356: FND_MSG_PUB.add_exc_msg

4352: END IF;
4353:
4354:
4355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4356: FND_MSG_PUB.add_exc_msg
4357: ( p_pkg_name => G_PKG_NAME
4358: , p_procedure_name => l_api_name );
4359: END IF;
4360: END Create_Dlvr_Actions_Wrapper;

Line 4725: l_msg_count := FND_MSG_PUB.count_msg;

4721: EXCEPTION
4722:
4723: WHEN Invalid_Arg_Exc_Dlv THEN
4724: l_return_status := FND_API.G_RET_STS_ERROR;
4725: l_msg_count := FND_MSG_PUB.count_msg;
4726: retcode := '-1';
4727:
4728: IF l_debug_mode = 'Y' THEN
4729: pa_debug.g_err_stage := 'Inside Invalid Argument exception of RUN_ACTION_CONC_PROCESS';

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 4974: FND_MSG_PUB.initialize;

4970: pa_debug.write(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,3) ;
4971: END IF;
4972:
4973: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
4974: FND_MSG_PUB.initialize;
4975: END IF;
4976:
4977: IF (p_commit = FND_API.G_TRUE) THEN
4978: savepoint CR_UP_DLV_ACTIONS_SP ;

Line 5235: l_msg_count := FND_MSG_PUB.count_msg;

5231:
5232: EXCEPTION
5233: WHEN Invalid_Arg_Exc_Dlv THEN
5234: x_return_status := FND_API.G_RET_STS_ERROR;
5235: l_msg_count := FND_MSG_PUB.count_msg;
5236:
5237: IF (p_commit = FND_API.G_TRUE) THEN
5238: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
5239: END IF ;

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 5360: FND_MSG_PUB.initialize;

5356: END IF;
5357:
5358: -- Initialise Message Stack
5359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
5360: FND_MSG_PUB.initialize;
5361: END IF;
5362:
5363: -- Define Save Point
5364: IF (p_commit = FND_API.G_TRUE) THEN

Line 5492: l_msg_count := FND_MSG_PUB.count_msg;

5488: END IF;
5489: EXCEPTION
5490: WHEN Invalid_Arg_Exc_Dlv THEN
5491: x_return_status := FND_API.G_RET_STS_ERROR;
5492: l_msg_count := FND_MSG_PUB.count_msg;
5493:
5494: -- 3671408 cursor is not used now , commented below code
5495: /*
5496: --Close any open cursors and roll back

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 5633: x_msg_count := FND_MSG_PUB.count_msg;

5629: CLOSE c_project_details;
5630: END IF;
5631:
5632: x_return_status := FND_API.G_RET_STS_ERROR;
5633: x_msg_count := FND_MSG_PUB.count_msg;
5634: x_msg_data :='Invalid Argument Exception inside RUN_ACTION_CONC_FRM_WRP' || x_msg_data;
5635: RETURN;
5636: WHEN OTHERS THEN
5637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5638: x_msg_count := FND_MSG_PUB.count_msg;

5634: x_msg_data :='Invalid Argument Exception inside RUN_ACTION_CONC_FRM_WRP' || x_msg_data;
5635: RETURN;
5636: WHEN OTHERS THEN
5637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5638: x_msg_count := FND_MSG_PUB.count_msg;
5639: x_msg_data := SQLERRM;
5640:
5641: -- 3671408 added code to handle cursor
5642: IF c_project_details%ISOPEN THEN

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;