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 FND_API

Line 80: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

76:
77:
78: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
79: (p_api_version IN NUMBER :=1.0
80: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
81: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
84: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 81: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

77:
78: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
79: (p_api_version IN NUMBER :=1.0
80: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
81: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
84: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
85: ,p_debug_mode IN VARCHAR2 :='N'

Line 82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

78: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
79: (p_api_version IN NUMBER :=1.0
80: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
81: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
84: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
85: ,p_debug_mode IN VARCHAR2 :='N'
86: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

79: (p_api_version IN NUMBER :=1.0
80: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
81: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
82: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
83: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
84: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
85: ,p_debug_mode IN VARCHAR2 :='N'
86: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
87: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132: l_msg_index_out NUMBER;
133: BEGIN
134:
135: x_msg_count := 0;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
138:
139: IF l_debug_mode = 'Y' THEN
140: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'

Line 146: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

142: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
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

Line 150: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
152: END IF;
153:
154: -- Call the pvt Create API only if something is fetched

Line 163: ,p_init_msg_list => FND_API.G_FALSE

159: pa_debug.write(g_module_name,'Before Calling PA_ACTIONS_PVT.CREATE_DLV_ACTIONS_IN_BULK' ,3);
160: END IF;
161: PA_ACTIONS_PVT.CREATE_DLV_ACTIONS_IN_BULK
162: (p_api_version => p_api_version
163: ,p_init_msg_list => FND_API.G_FALSE
164: ,p_commit => p_commit
165: ,p_validate_only => p_validate_only
166: ,p_validation_level => p_validation_level
167: ,p_calling_module => p_calling_module

Line 213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

209: IF l_debug_mode = 'Y' THEN
210: pa_debug.write(g_module_name,'x_return_status is ' || x_return_status,3);
211: END IF ;
212:
213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
214: RAISE Invalid_Arg_Exc_Dlv ;
215: END IF ;
216:
217: IF l_debug_mode = 'Y' THEN

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: END IF;
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;

Line 228: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
231:
232: IF l_debug_mode = 'Y' THEN

Line 239: (p_encoded => FND_API.G_TRUE,

235: END IF;
236:
237: IF l_msg_count = 1 THEN
238: PA_INTERFACE_UTILS_PUB.get_messages
239: (p_encoded => FND_API.G_TRUE,
240: p_msg_index => 1,
241: p_msg_count => l_msg_count,
242: p_msg_data => l_msg_data,
243: p_data => l_data,

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

251: pa_debug.reset_curr_function;
252: END IF ;
253: RETURN;
254: WHEN OTHERS THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: x_msg_count := 1;
257: x_msg_data := SQLERRM;
258:
259: IF (p_commit = FND_API.G_TRUE) THEN

Line 259: IF (p_commit = FND_API.G_TRUE) THEN

255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: x_msg_count := 1;
257: x_msg_data := SQLERRM;
258:
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'

Line 328: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

324: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
325:
326: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
327: (p_api_version IN NUMBER :=1.0
328: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
329: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
332: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 329: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

325:
326: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
327: (p_api_version IN NUMBER :=1.0
328: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
329: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
332: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
333: ,p_debug_mode IN VARCHAR2 :='N'

Line 330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

326: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
327: (p_api_version IN NUMBER :=1.0
328: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
329: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
332: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
333: ,p_debug_mode IN VARCHAR2 :='N'
334: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

327: (p_api_version IN NUMBER :=1.0
328: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
329: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
330: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
331: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
332: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
333: ,p_debug_mode IN VARCHAR2 :='N'
334: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
335: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 383: x_return_status := FND_API.G_RET_STS_SUCCESS;

379:
380: BEGIN
381:
382: x_msg_count := 0;
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
385:
386: IF l_debug_mode = 'Y' THEN
387: PA_DEBUG.set_curr_function( p_function => 'UPDADTE_DLV_ACTIONS_IN_BULK'

Line 393: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

389: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';
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

Line 397: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
399: END IF;
400:
401: -- Call the pvt Create API only if something is fetched

Line 407: ,p_init_msg_list => FND_API.G_FALSE

403: IF nvl(p_name_tbl.LAST,0)>0 THEN
404:
405: PA_ACTIONS_PVT.UPDATE_DLV_ACTIONS_IN_BULK
406: (p_api_version => p_api_version
407: ,p_init_msg_list => FND_API.G_FALSE
408: ,p_commit => p_commit
409: ,p_validate_only => p_validate_only
410: ,p_validation_level => p_validation_level
411: ,p_calling_module => p_calling_module

Line 454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

450: ) ;
451:
452: END IF ;
453:
454: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
455: RAISE Invalid_Arg_Exc_Dlv ;
456: END IF ;
457:
458: IF l_debug_mode = 'Y' THEN

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: END IF;
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;

Line 469: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
472:
473: IF l_debug_mode = 'Y' THEN

Line 480: (p_encoded => FND_API.G_TRUE,

476: END IF;
477:
478: IF l_msg_count = 1 THEN
479: PA_INTERFACE_UTILS_PUB.get_messages
480: (p_encoded => FND_API.G_TRUE,
481: p_msg_index => 1,
482: p_msg_count => l_msg_count,
483: p_msg_data => l_msg_data,
484: p_data => l_data,

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: pa_debug.reset_curr_function;
493: END IF ;
494: RETURN;
495: WHEN OTHERS THEN
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := 1;
498: x_msg_data := SQLERRM;
499:
500: IF (p_commit = FND_API.G_TRUE) THEN

Line 500: IF (p_commit = FND_API.G_TRUE) THEN

496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := 1;
498: x_msg_data := SQLERRM;
499:
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'

Line 542: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

538: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
539:
540: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
541: (p_api_version IN NUMBER :=1.0
542: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
543: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 543: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

539:
540: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
541: (p_api_version IN NUMBER :=1.0
542: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
543: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'

Line 544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

540: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
541: (p_api_version IN NUMBER :=1.0
542: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
543: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'
548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

541: (p_api_version IN NUMBER :=1.0
542: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
543: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
544: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
545: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
546: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
547: ,p_debug_mode IN VARCHAR2 :='N'
548: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
549: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562: l_msg_data VARCHAR2(2000);
563: l_msg_index_out NUMBER;
564: BEGIN
565: x_msg_count := 0;
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
568:
569: IF l_debug_mode = 'Y' THEN
570: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK',

Line 577: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

573: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
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

Line 581: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
583: END IF;
584:
585: IF l_debug_mode = 'Y' THEN

Line 592: ,p_init_msg_list => FND_API.G_FALSE

588: END IF;
589:
590: PA_ACTIONS_PVT.DELETE_DLV_ACTIONS_IN_BULK
591: (p_api_version => p_api_version
592: ,p_init_msg_list => FND_API.G_FALSE
593: ,p_commit => p_commit
594: ,p_validate_only => p_validate_only
595: ,p_validation_level => p_validation_level
596: ,p_calling_module => p_calling_module

Line 609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

605: ,x_msg_count => x_msg_count
606: ,x_msg_data => x_msg_data
607: ) ;
608:
609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
610: RAISE Invalid_Arg_Exc_Dlv ;
611: END IF ;
612:
613: IF l_debug_mode = 'Y' THEN --Added for bug 4945876

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: END IF ;
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;

Line 622: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
625:
626: IF l_debug_mode = 'Y' THEN

Line 633: (p_encoded => FND_API.G_TRUE,

629: END IF;
630:
631: IF l_msg_count = 1 THEN
632: PA_INTERFACE_UTILS_PUB.get_messages
633: (p_encoded => FND_API.G_TRUE,
634: p_msg_index => 1,
635: p_msg_count => l_msg_count,
636: p_msg_data => l_msg_data,
637: p_data => l_data,

Line 649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

645: pa_debug.reset_curr_function;
646: END IF ;
647: RETURN;
648: WHEN OTHERS THEN
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: x_msg_count := 1;
651: x_msg_data := SQLERRM;
652:
653: IF (p_commit = FND_API.G_TRUE) THEN

Line 653: IF (p_commit = FND_API.G_TRUE) THEN

649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: x_msg_count := 1;
651: x_msg_data := SQLERRM;
652:
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'

Line 723: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

719: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
720:
721: PROCEDURE CR_UP_DLV_ACTIONS_IN_BULK
722: (p_api_version IN NUMBER :=1.0
723: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
724: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
727: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 724: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

720:
721: PROCEDURE CR_UP_DLV_ACTIONS_IN_BULK
722: (p_api_version IN NUMBER :=1.0
723: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
724: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
727: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
728: ,p_debug_mode IN VARCHAR2 :='N'

Line 725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

721: PROCEDURE CR_UP_DLV_ACTIONS_IN_BULK
722: (p_api_version IN NUMBER :=1.0
723: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
724: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
727: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
728: ,p_debug_mode IN VARCHAR2 :='N'
729: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

722: (p_api_version IN NUMBER :=1.0
723: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
724: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
725: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
726: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
727: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
728: ,p_debug_mode IN VARCHAR2 :='N'
729: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
730: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 856: x_return_status := FND_API.G_RET_STS_SUCCESS;

852:
853: BEGIN
854:
855: x_msg_count := 0;
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
858:
859: IF l_debug_mode = 'Y' THEN
860: PA_DEBUG.set_curr_function( p_function => 'CR_UP_DLV_ACTIONS_IN_BULK',

Line 874: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

870: pa_debug.write(g_module_name,'p_object_type'||':'||p_object_type,3) ;
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

Line 878: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
880: END IF;
881:
882: IF l_debug_mode = 'Y' THEN

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

890: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
891: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
892: END IF;
893:
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
896: ,p_msg_name => 'PA_INV_PARAM_PASSED');
897: RAISE Invalid_Arg_Exc_Dlv;
898: END IF;

Line 912: ( p_init_msg_list => FND_API.G_FALSE

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
916: ,p_completed_flag_tbl => p_completed_flag_tbl

Line 938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

934: ,x_msg_count => x_msg_count
935: ,x_msg_data => x_msg_data
936: ) ;
937:
938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
939: RAISE Invalid_Arg_Exc_Dlv ;
940: END IF ;
941:
942:

Line 1180: ,p_init_msg_list => FND_API.G_FALSE

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
1183: ,p_validation_level => p_validation_level
1184: ,p_calling_module => p_calling_module

Line 1197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1193: ,x_msg_count => x_msg_count
1194: ,x_msg_data => x_msg_data
1195: ) ;
1196:
1197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1198: RAISE Invalid_Arg_Exc_Dlv ;
1199: END IF ;
1200:
1201: END IF ;

Line 1213: ,p_init_msg_list => FND_API.G_FALSE

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
1216: ,p_validation_level => p_validation_level
1217: ,p_calling_module => p_calling_module

Line 1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1255: ,x_msg_data => x_msg_data
1256: ) ;
1257:
1258:
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1260: RAISE Invalid_Arg_Exc_Dlv ;
1261: END IF ;
1262:
1263: END IF ;

Line 1275: ,p_init_msg_list => FND_API.G_FALSE

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
1278: ,p_validation_level => p_validation_level
1279: ,p_calling_module => p_calling_module

Line 1325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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 ;
1327: END IF ;
1328:
1329: END IF ;

Line 1341: x_return_status := FND_API.G_RET_STS_ERROR;

1337: END IF;
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;

Line 1344: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
1347:
1348: IF l_debug_mode = 'Y' THEN

Line 1355: (p_encoded => FND_API.G_TRUE,

1351: END IF;
1352:
1353: IF l_msg_count = 1 THEN
1354: PA_INTERFACE_UTILS_PUB.get_messages
1355: (p_encoded => FND_API.G_TRUE,
1356: p_msg_index => 1,
1357: p_msg_count => l_msg_count,
1358: p_msg_data => l_msg_data,
1359: p_data => l_data,

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1371: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1372: END IF;
1373: RETURN;
1374: WHEN OTHERS THEN
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: x_msg_count := 1;
1377: x_msg_data := SQLERRM;
1378:
1379: IF (p_commit = FND_API.G_TRUE) THEN

Line 1379: IF (p_commit = FND_API.G_TRUE) THEN

1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: x_msg_count := 1;
1377: x_msg_data := SQLERRM;
1378:
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'

Line 1431: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

1427: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
1428:
1429: PROCEDURE VALIDATE_ACTIONS
1430: ( p_api_version IN NUMBER :=1.0
1431: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1432: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1435: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 1432: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

1428:
1429: PROCEDURE VALIDATE_ACTIONS
1430: ( p_api_version IN NUMBER :=1.0
1431: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1432: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1435: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1436: ,p_debug_mode IN VARCHAR2 :='N'

Line 1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

1429: PROCEDURE VALIDATE_ACTIONS
1430: ( p_api_version IN NUMBER :=1.0
1431: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1432: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1435: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1436: ,p_debug_mode IN VARCHAR2 :='N'
1437: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

1430: ( p_api_version IN NUMBER :=1.0
1431: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1432: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1433: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1434: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1435: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1436: ,p_debug_mode IN VARCHAR2 :='N'
1437: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1438: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

1550: -- 3947021 end
1551:
1552: BEGIN
1553: x_msg_count := 0;
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1556:
1557: IF l_debug_mode = 'Y' THEN
1558: PA_DEBUG.set_curr_function( p_function => 'CR_UP_DLV_ACTIONS_IN_BULK',

Line 1570: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1566: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
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

Line 2015: x_return_status := FND_API.G_RET_STS_ERROR;

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 * =========================*/
2018:
2019: IF (p_calling_module = 'AMG') THEN

Line 2070: x_return_status := FND_API.G_RET_STS_ERROR ;

2066: FOR k IN l_name_tbl.FIRST..l_name_tbl.LAST LOOP
2067: IF ( (nvl(p_name_tbl(i),'X') = nvl(l_name_tbl(k),'Y')) AND
2068: p_proj_element_id_tbl(i) <> l_proj_element_id_tbl(k) ) THEN
2069:
2070: x_return_status := FND_API.G_RET_STS_ERROR ;
2071: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ALL_DUPLICATE_NAME') ;
2072: PA_UTILS.ADD_MESSAGE
2073: (p_app_short_name => 'PA',
2074: p_msg_name => 'PA_ACTION_NAME_ERR',

Line 2127: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2123: IF l_debug_mode = 'Y' THEN
2124: Pa_Debug.WRITE(g_module_name,' validating carrying out org ['||l_carrying_out_org_id||']status['||x_return_status||']', l_debug_level3);
2125: END IF;
2126: -- added for bug: 4537865
2127: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2128: l_carrying_out_org_id := l_new_carrying_out_org_id ;
2129: END IF;
2130: -- added for bug: 4537865
2131:

Line 2132: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2128: l_carrying_out_org_id := l_new_carrying_out_org_id ;
2129: END IF;
2130: -- added for bug: 4537865
2131:
2132: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2134: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2135: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_CARRYING_ORG_INVALID') ;
2136: PA_UTILS.ADD_MESSAGE

Line 2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2129: END IF;
2130: -- added for bug: 4537865
2131:
2132: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2134: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2135: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_CARRYING_ORG_INVALID') ;
2136: PA_UTILS.ADD_MESSAGE
2137: (p_app_short_name => 'PA',

Line 2134: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2130: -- added for bug: 4537865
2131:
2132: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2134: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2135: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_CARRYING_ORG_INVALID') ;
2136: PA_UTILS.ADD_MESSAGE
2137: (p_app_short_name => 'PA',
2138: p_msg_name => 'PA_ACTN_VALID_ERR',

Line 2146: x_return_status := FND_API.G_RET_STS_ERROR;

2142: p_value2 => l_deliverable_number,
2143: p_token3 => 'MESSAGE',
2144: p_value3 => l_err_message
2145: );
2146: x_return_status := FND_API.G_RET_STS_ERROR;
2147: END IF;
2148: END IF;
2149:
2150: -- validate action_owner_id - valid value

Line 2179: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2175: Pa_Debug.WRITE(g_module_name,' validated owner id ['||l_action_owner_id||']status['||x_return_status||']' , l_debug_level3);
2176: END IF;
2177:
2178: -- added for bug 4537865
2179: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2180: l_action_owner_id := l_new_action_owner_id;
2181: END IF;
2182: -- added for bug 4537865
2183:

Line 2184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2180: l_action_owner_id := l_new_action_owner_id;
2181: END IF;
2182: -- added for bug 4537865
2183:
2184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2186: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2187: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_OWNER_INVALID') ;
2188: PA_UTILS.ADD_MESSAGE

Line 2185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2181: END IF;
2182: -- added for bug 4537865
2183:
2184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2186: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2187: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_OWNER_INVALID') ;
2188: PA_UTILS.ADD_MESSAGE
2189: (p_app_short_name => 'PA',

Line 2186: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2182: -- added for bug 4537865
2183:
2184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2186: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2187: l_err_message := FND_MESSAGE.GET_STRING('PA','ACTION_OWNER_INVALID') ;
2188: PA_UTILS.ADD_MESSAGE
2189: (p_app_short_name => 'PA',
2190: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 2200: x_return_status := FND_API.G_RET_STS_ERROR;

2196: p_value3 => p_action_reference_tbl(i_act),
2197: p_token4 => 'MESSAGE',
2198: p_value4 => l_err_message
2199: );
2200: x_return_status := FND_API.G_RET_STS_ERROR;
2201: END IF;
2202: END IF;
2203:
2204: -- validate function code

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228: p_value3 => p_action_reference_tbl(i_act),
2229: p_token4 => 'MESSAGE',
2230: p_value4 => l_err_message
2231: );
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: END IF;
2234:
2235: --Bug 3651563
2236: --If p_calling_module is 'AMG' then do function code related validation

Line 2244: x_return_status := FND_API.G_RET_STS_ERROR;

2240: WHILE j_act IS NOT NULL LOOP
2241: IF ( ((p_function_code_tbl(i_act) = 'SHIPPING' AND p_function_code_tbl(j_act) = 'SHIPPING')
2242: OR (p_function_code_tbl(i_act) = 'PROCUREMENT' AND p_function_code_tbl(j_act) = 'PROCUREMENT'))
2243: AND i_act <> j_act ) THEN
2244: x_return_status := FND_API.G_RET_STS_ERROR;
2245: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLV_TOO_MANY_ACTIONS');
2246: PA_UTILS.ADD_MESSAGE
2247: (p_app_short_name => 'PA',
2248: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 2270: x_return_status := FND_API.G_RET_STS_ERROR;

2266: IF ( ((p_function_code_tbl(i_act) = 'SHIPPING' AND l_function_code_tbl(k_act) = 'SHIPPING')
2267: OR (p_function_code_tbl(i_act) = 'PROCUREMENT' AND l_function_code_tbl(k_act) = 'PROCUREMENT'))
2268: AND p_proj_element_id_tbl(i_act) <> l_proj_element_id_tbl(k_act) ) THEN
2269:
2270: x_return_status := FND_API.G_RET_STS_ERROR;
2271: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLV_TOO_MANY_ACTIONS') ;
2272: PA_UTILS.ADD_MESSAGE
2273: (p_app_short_name => 'PA',
2274: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 2305: x_return_status := FND_API.G_RET_STS_ERROR;

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:
2308: IF l_debug_mode = 'Y' THEN
2309: pa_debug.g_err_stage:='Exiting Validate Actions ';

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR;

2312: END IF;
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';

Line 2326: (p_encoded => FND_API.G_TRUE,

2322: END IF;
2323:
2324: IF l_msg_count = 1 THEN
2325: PA_INTERFACE_UTILS_PUB.get_messages
2326: (p_encoded => FND_API.G_TRUE,
2327: p_msg_index => 1,
2328: p_msg_count => l_msg_count,
2329: p_msg_data => l_msg_data,
2330: p_data => l_data,

Line 2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2338: pa_debug.reset_curr_function;
2339: END IF ;
2340: RETURN;
2341: WHEN OTHERS THEN
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'

Line 2379: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2375: -- p_action_ver_id IN NUMBER Y Action Version Id
2376:
2377: PROCEDURE DELETE_DLV_ACTION
2378: (p_api_version IN NUMBER :=1.0
2379: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2380: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2380: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2376:
2377: PROCEDURE DELETE_DLV_ACTION
2378: (p_api_version IN NUMBER :=1.0
2379: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2380: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'

Line 2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2377: PROCEDURE DELETE_DLV_ACTION
2378: (p_api_version IN NUMBER :=1.0
2379: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2380: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2378: (p_api_version IN NUMBER :=1.0
2379: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2380: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2381: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

Line 2421: x_return_status := FND_API.G_RET_STS_SUCCESS;

2417:
2418: BEGIN
2419:
2420: x_msg_count := 0;
2421: x_return_status := FND_API.G_RET_STS_SUCCESS;
2422: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2423:
2424: IF l_debug_mode = 'Y' THEN
2425: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTION',

Line 2442: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2438: pa_debug.write(g_module_name,'p_function_code'||':'||p_function_code,3) ;
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

Line 2446: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
2448: END IF;
2449:
2450: IF l_debug_mode = 'Y' THEN

Line 2483: x_return_status := FND_API.G_RET_STS_ERROR;

2479: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2480: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2481: END IF;
2482:
2483: x_return_status := FND_API.G_RET_STS_ERROR;
2484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
2485: ,p_msg_name => 'PA_INV_PARAM_PASSED');
2486: RAISE Invalid_Arg_Exc_Dlv;
2487: END IF;

Line 2509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2505: ,x_msg_count => x_msg_count
2506: ,x_msg_data => x_msg_data
2507: ) ;
2508:
2509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2510: RAISE Invalid_Arg_Exc_Dlv ;
2511: END IF ;
2512:
2513: IF l_debug_mode = 'Y' THEN

Line 2521: x_return_status := FND_API.G_RET_STS_ERROR;

2517: END IF;
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;

Line 2524: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
2527:
2528: IF l_debug_mode = 'Y' THEN

Line 2535: (p_encoded => FND_API.G_TRUE,

2531: END IF;
2532:
2533: IF l_msg_count = 1 THEN
2534: PA_INTERFACE_UTILS_PUB.get_messages
2535: (p_encoded => FND_API.G_TRUE,
2536: p_msg_index => 1,
2537: p_msg_count => l_msg_count,
2538: p_msg_data => l_msg_data,
2539: p_data => l_data,

Line 2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2547: pa_debug.reset_curr_function;
2548: END IF ;
2549: RETURN;
2550: WHEN OTHERS THEN
2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: x_msg_count := 1;
2553: x_msg_data := SQLERRM;
2554:
2555: IF (p_commit = FND_API.G_TRUE) THEN

Line 2555: IF (p_commit = FND_API.G_TRUE) THEN

2551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2552: x_msg_count := 1;
2553: x_msg_data := SQLERRM;
2554:
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'

Line 2600: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2596: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
2597:
2598: PROCEDURE COPY_ACTIONS
2599: (p_api_version IN NUMBER :=1.0
2600: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2601: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2601: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2597:
2598: PROCEDURE COPY_ACTIONS
2599: (p_api_version IN NUMBER :=1.0
2600: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2601: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'

Line 2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2598: PROCEDURE COPY_ACTIONS
2599: (p_api_version IN NUMBER :=1.0
2600: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2601: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2599: (p_api_version IN NUMBER :=1.0
2600: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2601: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2602: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2603: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2604: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2605: ,p_debug_mode IN VARCHAR2 :='N'
2606: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

Line 2632: x_return_status := FND_API.G_RET_STS_SUCCESS;

2628: l_msg_index_out NUMBER;
2629: BEGIN
2630:
2631: x_msg_count := 0;
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2634:
2635: IF l_debug_mode = 'Y' THEN
2636: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS',

Line 2651: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2647: pa_debug.write(g_module_name,'p_target_object_id '||':'||p_target_object_id ,3) ;
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

Line 2655: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
2657: END IF;
2658:
2659: IF l_debug_mode = 'Y' THEN

Line 2672: x_return_status := FND_API.G_RET_STS_ERROR;

2668: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2669: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2670: END IF;
2671:
2672: x_return_status := FND_API.G_RET_STS_ERROR;
2673: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
2674: ,p_msg_name => 'PA_INV_PARAM_PASSED');
2675: RAISE Invalid_Arg_Exc_Dlv;
2676: END IF;

Line 2705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2701: ,x_msg_data => x_msg_data
2702: ) ;
2703:
2704:
2705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2706: RAISE Invalid_Arg_Exc_Dlv ;
2707: END IF ;
2708:
2709: IF l_debug_mode = 'Y' THEN

Line 2717: x_return_status := FND_API.G_RET_STS_ERROR;

2713: END IF;
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;

Line 2720: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
2723:
2724: IF l_debug_mode = 'Y' THEN

Line 2731: (p_encoded => FND_API.G_TRUE,

2727: END IF;
2728:
2729: IF l_msg_count = 1 THEN
2730: PA_INTERFACE_UTILS_PUB.get_messages
2731: (p_encoded => FND_API.G_TRUE,
2732: p_msg_index => 1,
2733: p_msg_count => l_msg_count,
2734: p_msg_data => l_msg_data,
2735: p_data => l_data,

Line 2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2743: pa_debug.reset_curr_function;
2744: END IF ;
2745: RETURN;
2746: WHEN OTHERS THEN
2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: x_msg_count := 1;
2749: x_msg_data := SQLERRM;
2750:
2751: IF (p_commit = FND_API.G_TRUE) THEN

Line 2751: IF (p_commit = FND_API.G_TRUE) THEN

2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: x_msg_count := 1;
2749: x_msg_data := SQLERRM;
2750:
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'

Line 2977: , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2973: --
2974:
2975: PROCEDURE Create_Dlvr_Actions_Wrapper
2976: ( p_api_version IN NUMBER :=1.0
2977: , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2978: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
2979: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2980: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2981: , p_calling_module IN VARCHAR2 :='AMG'

Line 2978: , p_commit IN VARCHAR2 :=FND_API.G_FALSE

2974:
2975: PROCEDURE Create_Dlvr_Actions_Wrapper
2976: ( p_api_version IN NUMBER :=1.0
2977: , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2978: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
2979: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2980: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2981: , p_calling_module IN VARCHAR2 :='AMG'
2982: , p_debug_mode IN VARCHAR2 :='N'

Line 2979: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2975: PROCEDURE Create_Dlvr_Actions_Wrapper
2976: ( p_api_version IN NUMBER :=1.0
2977: , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2978: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
2979: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2980: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2981: , p_calling_module IN VARCHAR2 :='AMG'
2982: , p_debug_mode IN VARCHAR2 :='N'
2983: , p_insert_or_update IN VARCHAR2 := 'INSERT'

Line 2980: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2976: ( p_api_version IN NUMBER :=1.0
2977: , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2978: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
2979: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2980: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2981: , p_calling_module IN VARCHAR2 :='AMG'
2982: , p_debug_mode IN VARCHAR2 :='N'
2983: , p_insert_or_update IN VARCHAR2 := 'INSERT'
2984: , p_action_in_tbl IN PA_PROJECT_PUB.action_in_tbl_type

Line 3159: IF p_commit = FND_API.G_TRUE THEN

3155: l_update_oke_yn VARCHAR2(1) := 'Y';
3156:
3157: BEGIN
3158:
3159: IF p_commit = FND_API.G_TRUE THEN
3160: SAVEPOINT create_dlvr_actions_wrapper;
3161: END IF;
3162: -- Standard call to check for call compatibility.
3163: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

Line 3163: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

3159: IF p_commit = FND_API.G_TRUE THEN
3160: SAVEPOINT create_dlvr_actions_wrapper;
3161: END IF;
3162: -- Standard call to check for call compatibility.
3163: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
3164: p_api_version ,
3165: l_api_name ,
3166: G_PKG_NAME )
3167: THEN

Line 3168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3164: p_api_version ,
3165: l_api_name ,
3166: G_PKG_NAME )
3167: THEN
3168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3169: END IF;
3170:
3171: -- Initialize the message table if requested.
3172: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 3172: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

3168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3184: x_return_status := FND_API.G_RET_STS_SUCCESS;

3180: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3181: END IF;
3182:
3183: -- Set API return status to success
3184: x_return_status := FND_API.G_RET_STS_SUCCESS;
3185:
3186: -- OKE apis expect CREATE instead of INSERT. Initializing local variable
3187: -- l_action based on value of p_insert_or_update
3188:

Line 3304: x_return_status := FND_API.G_RET_STS_ERROR;

3300: p_value4 => l_err_message
3301: );
3302: END IF;
3303:
3304: x_return_status := FND_API.G_RET_STS_ERROR;
3305: RAISE FND_API.G_EXC_ERROR;
3306:
3307: END IF;
3308:

Line 3305: RAISE FND_API.G_EXC_ERROR;

3301: );
3302: END IF;
3303:
3304: x_return_status := FND_API.G_RET_STS_ERROR;
3305: RAISE FND_API.G_EXC_ERROR;
3306:
3307: END IF;
3308:
3309: -- Validate Action reference - not null, unique

Line 3318: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3314: , x_unique_flag => l_unique_flag
3315: , x_return_status => x_return_status
3316: );
3317:
3318: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3321: RAISE FND_API.G_EXC_ERROR;
3322: END IF;

Line 3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3315: , x_return_status => x_return_status
3316: );
3317:
3318: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3321: RAISE FND_API.G_EXC_ERROR;
3322: END IF;
3323:

Line 3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3316: );
3317:
3318: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3321: RAISE FND_API.G_EXC_ERROR;
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

Line 3321: RAISE FND_API.G_EXC_ERROR;

3317:
3318: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3321: RAISE FND_API.G_EXC_ERROR;
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:

Line 3342: x_return_status := FND_API.G_RET_STS_ERROR;

3338: p_value4 => l_err_message
3339: );
3340:
3341: END IF;
3342: x_return_status := FND_API.G_RET_STS_ERROR;
3343: RAISE FND_API.G_EXC_ERROR;
3344:
3345: END IF;
3346:

Line 3343: RAISE FND_API.G_EXC_ERROR;

3339: );
3340:
3341: END IF;
3342: x_return_status := FND_API.G_RET_STS_ERROR;
3343: RAISE FND_API.G_EXC_ERROR;
3344:
3345: END IF;
3346:
3347: END IF;

Line 3560: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3556: -- * added for bug: 4537865
3557: , p_return_status => x_return_status );
3558:
3559: --added for bug: 4537865
3560: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3561: l_fin_task_id := l_new_fin_task_id;
3562: END IF;
3563: --added for bug: 4537865
3564:

Line 3565: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3561: l_fin_task_id := l_new_fin_task_id;
3562: END IF;
3563: --added for bug: 4537865
3564:
3565: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3568: RAISE FND_API.G_EXC_ERROR;
3569: END IF;

Line 3566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3562: END IF;
3563: --added for bug: 4537865
3564:
3565: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3568: RAISE FND_API.G_EXC_ERROR;
3569: END IF;
3570:

Line 3567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3563: --added for bug: 4537865
3564:
3565: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3568: RAISE FND_API.G_EXC_ERROR;
3569: END IF;
3570:
3571: IF l_function_code_tbl(i_actn) IN ( 'SHIPPING' , 'PROCUREMENT') THEN

Line 3568: RAISE FND_API.G_EXC_ERROR;

3564:
3565: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3568: RAISE FND_API.G_EXC_ERROR;
3569: END IF;
3570:
3571: IF l_function_code_tbl(i_actn) IN ( 'SHIPPING' , 'PROCUREMENT') THEN
3572:

Line 3595: x_return_status := FND_API.G_RET_STS_ERROR;

3591: p_value4 => l_err_message
3592: );
3593:
3594: END IF;
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596:
3597: RAISE FND_API.G_EXC_ERROR;
3598: ELSE
3599: l_fin_task_id_tbl(i_actn) := l_fin_task_id;

Line 3597: RAISE FND_API.G_EXC_ERROR;

3593:
3594: END IF;
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596:
3597: RAISE FND_API.G_EXC_ERROR;
3598: ELSE
3599: l_fin_task_id_tbl(i_actn) := l_fin_task_id;
3600: END IF;
3601:

Line 3628: x_return_status := FND_API.G_RET_STS_ERROR;

3624: p_value4 => l_err_message
3625: );
3626:
3627: END IF;
3628: x_return_status := FND_API.G_RET_STS_ERROR;
3629:
3630: RAISE FND_API.G_EXC_ERROR;
3631: ELSE
3632: l_fin_task_id_tbl(i_actn) := l_fin_task_id;

Line 3630: RAISE FND_API.G_EXC_ERROR;

3626:
3627: END IF;
3628: x_return_status := FND_API.G_RET_STS_ERROR;
3629:
3630: RAISE FND_API.G_EXC_ERROR;
3631: ELSE
3632: l_fin_task_id_tbl(i_actn) := l_fin_task_id;
3633: END IF;
3634:

Line 3664: ,p_validate_only => FND_API.G_FALSE

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
3666: ,p_calling_module => 'AMG'
3667: ,p_debug_mode => p_debug_mode
3668: ,p_max_msg_count => NULL

Line 3665: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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
3666: ,p_calling_module => 'AMG'
3667: ,p_debug_mode => p_debug_mode
3668: ,p_max_msg_count => NULL
3669: ,p_name_tbl => l_action_name_tbl

Line 3713: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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;
3715: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3716: RAISE FND_API.G_EXC_ERROR;
3717: END IF;

Line 3714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
3715: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3716: RAISE FND_API.G_EXC_ERROR;
3717: END IF;
3718:

Line 3715: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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;
3715: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3716: RAISE FND_API.G_EXC_ERROR;
3717: END IF;
3718:
3719: -- After successfull creation of actions, looping the action-in table and populating

Line 3716: RAISE FND_API.G_EXC_ERROR;

3712:
3713: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3715: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3716: RAISE FND_API.G_EXC_ERROR;
3717: END IF;
3718:
3719: -- After successfull creation of actions, looping the action-in table and populating
3720: -- OKE and Billing PLSQL tables

Line 3761: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3757: pa_debug.write(g_module_name,'Derived action id ['||l_action_id||']for reference['||p_action_in_tbl(i_actn).pm_action_reference||
3758: ']status['||x_return_status||']',5);
3759: END IF;
3760:
3761: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3763: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: END IF;

Line 3762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3758: ']status['||x_return_status||']',5);
3759: END IF;
3760:
3761: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3763: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: END IF;
3766:

Line 3763: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3759: END IF;
3760:
3761: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3763: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: END IF;
3766:
3767: IF p_debug_mode = 'Y' THEN

Line 3764: RAISE FND_API.G_EXC_ERROR;

3760:
3761: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3763: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: END IF;
3766:
3767: IF p_debug_mode = 'Y' THEN
3768: pa_debug.write(g_module_name,'Should we update OKE attributes? '||l_update_oke_yn);

Line 4038: x_return_status := FND_API.G_RET_STS_ERROR;

4034: p_value2 => l_deliverable_number,
4035: p_token3 => 'MESSAGE',
4036: p_value3 => l_err_message
4037: );
4038: x_return_status := FND_API.G_RET_STS_ERROR;
4039: CLOSE C_org_name;
4040:
4041: -- Added for bug# 3810957 , throwing invalid cursor error
4042: -- here, C_org_name cursor was closed and second time closing it was throwing above error

Line 4043: -- if invalid event org id , set return status to 'E' , close the cursor and raise FND_API.G_EXC_ERROR exception

4039: CLOSE C_org_name;
4040:
4041: -- Added for bug# 3810957 , throwing invalid cursor error
4042: -- here, C_org_name cursor was closed and second time closing it was throwing above error
4043: -- if invalid event org id , set return status to 'E' , close the cursor and raise FND_API.G_EXC_ERROR exception
4044: RAISE FND_API.G_EXC_ERROR;
4045: -- 3810957 end
4046: END IF;
4047: CLOSE C_org_name;

Line 4044: RAISE FND_API.G_EXC_ERROR;

4040:
4041: -- Added for bug# 3810957 , throwing invalid cursor error
4042: -- here, C_org_name cursor was closed and second time closing it was throwing above error
4043: -- if invalid event org id , set return status to 'E' , close the cursor and raise FND_API.G_EXC_ERROR exception
4044: RAISE FND_API.G_EXC_ERROR;
4045: -- 3810957 end
4046: END IF;
4047: CLOSE C_org_name;
4048: END IF;

Line 4143: , p_init_msg_list => FND_API.G_FALSE

4139: l_dlv_ship_action_rec.quantity := l_dlv_ship_action_tbl(i_ship1).quantity ;
4140:
4141: oke_amg_grp.manage_dlv_action
4142: ( p_api_version => p_api_version
4143: , p_init_msg_list => FND_API.G_FALSE
4144: , p_commit => p_commit
4145: , p_action => l_action
4146: , p_dlv_action_type => g_dlv_action_ship
4147: , p_master_inv_org_id => l_org_id

Line 4200: , p_init_msg_list => FND_API.G_FALSE

4196: l_dlv_req_action_rec.currency := l_dlv_req_action_tbl(i_proc1).currency ;
4197:
4198: oke_amg_grp.manage_dlv_action
4199: ( p_api_version => p_api_version
4200: , p_init_msg_list => FND_API.G_FALSE
4201: , p_commit => p_commit
4202: , p_action => l_action
4203: , p_dlv_action_type => g_dlv_action_proc
4204: , p_master_inv_org_id => l_org_id

Line 4230: ,p_init_msg_list => FND_API.G_FALSE

4226:
4227: Pa_Event_Pub.create_event
4228: ( p_api_version_number => p_api_version
4229: ,p_commit => p_commit
4230: ,p_init_msg_list => FND_API.G_FALSE
4231: ,p_pm_product_code => l_pm_source_code
4232: ,p_event_in_tbl => l_event_in_tbl
4233: ,p_event_out_tbl => l_event_out_tbl
4234: ,p_msg_count => x_msg_count

Line 4243: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4239: IF p_debug_mode = 'Y' THEN
4240: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.create_event for billing action ['||x_return_status||']',5);
4241: END IF;
4242:
4243: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4246: RAISE FND_API.G_EXC_ERROR;
4247: END IF;

Line 4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4240: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.create_event for billing action ['||x_return_status||']',5);
4241: END IF;
4242:
4243: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4246: RAISE FND_API.G_EXC_ERROR;
4247: END IF;
4248:

Line 4245: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4241: END IF;
4242:
4243: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4246: RAISE FND_API.G_EXC_ERROR;
4247: END IF;
4248:
4249: ELSIF ( p_insert_or_update = g_update) THEN

Line 4246: RAISE FND_API.G_EXC_ERROR;

4242:
4243: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4246: RAISE FND_API.G_EXC_ERROR;
4247: END IF;
4248:
4249: ELSIF ( p_insert_or_update = g_update) THEN
4250:

Line 4254: , p_init_msg_list => FND_API.G_FALSE

4250:
4251: Pa_Event_Pub.Update_Event
4252: ( p_api_version_number => p_api_version
4253: , p_commit => p_commit
4254: , p_init_msg_list => FND_API.G_FALSE
4255: , p_pm_product_code => l_pm_source_code
4256: , p_event_in_tbl => l_event_in_tbl
4257: , p_event_out_tbl => l_event_out_tbl
4258: , p_msg_count => x_msg_count

Line 4267: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4263: IF p_debug_mode = 'Y' THEN
4264: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.update_event for billing action ['||x_return_status||']',5);
4265: END IF;
4266:
4267: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;

Line 4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4264: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.update_event for billing action ['||x_return_status||']',5);
4265: END IF;
4266:
4267: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;
4272:

Line 4269: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4265: END IF;
4266:
4267: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;
4272:
4273: END IF; -- p_insert_or_update values

Line 4270: RAISE FND_API.G_EXC_ERROR;

4266:
4267: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4270: RAISE FND_API.G_EXC_ERROR;
4271: END IF;
4272:
4273: END IF; -- p_insert_or_update values
4274: END IF; -- i_bill > 0

Line 4282: WHEN FND_API.G_EXC_ERROR THEN

4278: pa_debug.write(g_module_name,l_api_name||': Exiting without error',5);
4279: END IF;
4280:
4281: EXCEPTION
4282: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 4283: IF (p_commit = FND_API.G_TRUE) THEN

4279: END IF;
4280:
4281: EXCEPTION
4282: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 4286: x_return_status := FND_API.G_RET_STS_ERROR;

4282: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4292: (p_encoded => FND_API.G_FALSE,

4288:
4289: IF l_msg_count = 1 AND x_msg_data IS NULL
4290: THEN
4291: PA_INTERFACE_UTILS_PUB.get_messages
4292: (p_encoded => FND_API.G_FALSE,
4293: p_msg_index => 1,
4294: p_msg_count => x_msg_count,
4295: p_msg_data => l_msg_data,
4296: p_data => l_data,

Line 4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4307: pa_debug.reset_curr_function;
4308: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
4309: END IF;
4310:
4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

Line 4312: IF (p_commit = FND_API.G_TRUE) THEN

4308: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
4309: END IF;
4310:
4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

Line 4315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 4321: (p_encoded => FND_API.G_FALSE,

4317:
4318: IF l_msg_count = 1 AND x_msg_data IS NULL
4319: THEN
4320: PA_INTERFACE_UTILS_PUB.get_messages
4321: (p_encoded => FND_API.G_FALSE,
4322: p_msg_index => 1,
4323: p_msg_count => x_msg_count,
4324: p_msg_data => l_msg_data,
4325: p_data => l_data,

Line 4341: IF (p_commit = FND_API.G_TRUE) THEN

4337: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);
4338: END IF;
4339:
4340: WHEN OTHERS THEN
4341: IF (p_commit = FND_API.G_TRUE) THEN
4342: ROLLBACK TO create_dlvr_actions_wrapper;
4343: END IF;
4344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4345: x_msg_count := 1;

Line 4344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4340: WHEN OTHERS THEN
4341: IF (p_commit = FND_API.G_TRUE) THEN
4342: ROLLBACK TO create_dlvr_actions_wrapper;
4343: END IF;
4344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4345: x_msg_count := 1;
4346: x_msg_data := SQLERRM;
4347:
4348: IF p_debug_mode = 'Y' THEN

Line 4391: l_init_msg_list VARCHAR2(20) := FND_API.G_FALSE ;

4387: -- 3752898
4388: -- We need this variable only for passing to OKE API
4389: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,
4390: -- Its not correct to initialise this variable as TRUE .By default this value should be FALSE
4391: l_init_msg_list VARCHAR2(20) := FND_API.G_FALSE ;
4392:
4393: l_valid VARCHAR2(1);
4394:
4395: /* Commented for Bug Number 4907103

Line 4426: l_return_status := FND_API.G_RET_STS_SUCCESS;

4422: retcode := '0';
4423: errbuf := NULL;
4424:
4425: -- Initialize the return status to success
4426: l_return_status := FND_API.G_RET_STS_SUCCESS;
4427: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4428:
4429: IF l_debug_mode = 'Y' THEN
4430: pa_debug.set_curr_function( p_function => 'RUN_ACTION_CONC_PROCESS',

Line 4458: l_return_status := FND_API.G_RET_STS_ERROR;

4454: IF l_debug_mode = 'Y' THEN
4455: pa_debug.g_err_stage:= 'RUN_ACTION_CONC_PROCESS : Invalid value entered for Project Number From';
4456: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4457: END IF;
4458: l_return_status := FND_API.G_RET_STS_ERROR;
4459: PA_UTILS.ADD_MESSAGE
4460: (p_app_short_name => 'PA',
4461: p_msg_name => 'PA_INV_PARAM_PASSED');
4462: CLOSE c_valid_project_number_entry ;

Line 4474: l_return_status := FND_API.G_RET_STS_ERROR;

4470: IF l_debug_mode = 'Y' THEN
4471: pa_debug.g_err_stage:= 'RUN_ACTION_CONC_PROCESS : Invalid value entered for Project Number To' ;
4472: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4473: END IF;
4474: l_return_status := FND_API.G_RET_STS_ERROR;
4475: PA_UTILS.ADD_MESSAGE
4476: (p_app_short_name => 'PA',
4477: p_msg_name => 'PA_INV_PARAM_PASSED');
4478: CLOSE c_valid_project_number_entry ;

Line 4490: l_return_status := FND_API.G_RET_STS_ERROR;

4486: IF l_debug_mode = 'Y' THEN
4487: pa_debug.g_err_stage:= 'Mandatory parameter to this API : Function is NULL';
4488: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4489: END IF;
4490: l_return_status := FND_API.G_RET_STS_ERROR;
4491: PA_UTILS.ADD_MESSAGE
4492: (p_app_short_name => 'PA',
4493: p_msg_name => 'PA_INV_PARAM_PASSED');
4494: RAISE Invalid_Arg_Exc_Dlv;

Line 4547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4543: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4544: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4545: END IF;
4546:
4547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4548: RAISE Invalid_Arg_Exc_Dlv ;
4549: END IF ;
4550: ELSIF p_function = 'PROCUREMENT' THEN
4551: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

Line 4565: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4561: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4562: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4563: END IF;
4564:
4565: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4566: RAISE Invalid_Arg_Exc_Dlv ;
4567: END IF ;
4568:
4569: ELSIF p_function = 'BOTH' THEN

Line 4584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4580: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4581: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4582: END IF;
4583:
4584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4585: RAISE Invalid_Arg_Exc_Dlv ;
4586: END IF ;
4587: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4588: P_PROJECT_ID => l_project_id_tbl(l_count)

Line 4601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4597: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4598: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4599: END IF;
4600:
4601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4602: RAISE Invalid_Arg_Exc_Dlv ;
4603: END IF ;
4604:
4605: END IF;

Line 4642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4638: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4639: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4640: END IF;
4641:
4642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4643: RAISE Invalid_Arg_Exc_Dlv ;
4644: END IF ;
4645:
4646: ELSIF p_function = 'PROCUREMENT' THEN

Line 4666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4662: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4663: END IF;
4664:
4665:
4666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4667: RAISE Invalid_Arg_Exc_Dlv ;
4668: END IF ;
4669: ELSIF p_function = 'BOTH' THEN
4670:

Line 4689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4685: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4686: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4687: END IF;
4688:
4689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4690: RAISE Invalid_Arg_Exc_Dlv ;
4691: END IF ;
4692:
4693: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

Line 4707: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4703: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4704: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4705: END IF;
4706:
4707: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4708: RAISE Invalid_Arg_Exc_Dlv ;
4709: END IF ;
4710: END IF;
4711:

Line 4724: l_return_status := FND_API.G_RET_STS_ERROR;

4720:
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

Line 4747: (p_encoded => FND_API.G_TRUE,

4743: END IF ;
4744:
4745: IF l_msg_count >= 1 THEN
4746: PA_INTERFACE_UTILS_PUB.get_messages
4747: (p_encoded => FND_API.G_TRUE,
4748: p_msg_index => 1,
4749: p_msg_count => l_msg_count,
4750: p_msg_data => l_msg_data,
4751: p_data => l_data,

Line 4764: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4760: END IF ;
4761: RAISE; /* Will have to raise since called as part of conc request .After Reports is built for the C.P no need for this raise */
4762:
4763: WHEN OTHERS THEN
4764: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4765: retcode := '-1';
4766: errbuf := SQLERRM;
4767:
4768: IF c_project_id_range%ISOPEN THEN

Line 4849: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

4845: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
4846:
4847: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4848: (p_api_version IN NUMBER :=1.0
4849: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4850: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4853: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 4850: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

4846:
4847: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4848: (p_api_version IN NUMBER :=1.0
4849: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4850: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4853: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4854: ,p_debug_mode IN VARCHAR2 :='N'

Line 4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

4847: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4848: (p_api_version IN NUMBER :=1.0
4849: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4850: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4853: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4854: ,p_debug_mode IN VARCHAR2 :='N'
4855: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

4848: (p_api_version IN NUMBER :=1.0
4849: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4850: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4851: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4852: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4853: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4854: ,p_debug_mode IN VARCHAR2 :='N'
4855: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4856: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 4946: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4942: l_object_id NUMBER;
4943: l_object_version_id NUMBER;
4944: l_project_id NUMBER;
4945:
4946: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4947: l_count NUMBER;
4948:
4949: BEGIN
4950:

Line 4957: x_return_status := FND_API.G_RET_STS_SUCCESS;

4953: -- to validation actions api for validations
4954: -- if validations are successful, call UPDATE_DLV_ACTIONS_IN_BULK api
4955:
4956: x_msg_count := 0;
4957: x_return_status := FND_API.G_RET_STS_SUCCESS;
4958: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4959:
4960: IF l_debug_mode = 'Y' THEN
4961: PA_DEBUG.set_curr_function( p_function => 'UPD_DLV_ACTIONS_IN_BULK_TM',

Line 4973: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

4969: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
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

Line 4977: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
4979: END IF;
4980:
4981: -- Call the validation API. It will

Line 5037: ( p_init_msg_list => FND_API.G_FALSE

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
5041: ,p_completion_date_tbl => l_completion_date_tbl

Line 5062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5058: ,x_msg_count => x_msg_count
5059: ,x_msg_data => x_msg_data
5060: ) ;
5061:
5062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5063: l_return_status := FND_API.G_RET_STS_ERROR;
5064: END IF;
5065:
5066: END LOOP ;

Line 5063: l_return_status := FND_API.G_RET_STS_ERROR;

5059: ,x_msg_data => x_msg_data
5060: ) ;
5061:
5062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5063: l_return_status := FND_API.G_RET_STS_ERROR;
5064: END IF;
5065:
5066: END LOOP ;
5067:

Line 5070: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5066: END LOOP ;
5067:
5068: END IF;
5069:
5070: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5071: RAISE Invalid_Arg_Exc_Dlv ;
5072: END IF ;
5073:
5074: -- Loop through p_name_tbl to find out the

Line 5167: ,p_init_msg_list => FND_API.G_FALSE

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
5170: ,p_validation_level => p_validation_level
5171: ,p_calling_module => p_calling_module

Line 5213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5209: ,x_msg_data => x_msg_data
5210: ) ;
5211:
5212:
5213: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5214: RAISE Invalid_Arg_Exc_Dlv ;
5215: END IF ;
5216:
5217: END IF ;

Line 5220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5216:
5217: END IF ;
5218:
5219:
5220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5221: RAISE Invalid_Arg_Exc_Dlv ;
5222: END IF ;
5223:
5224: END IF ; -- Only if something is fetched

Line 5234: x_return_status := FND_API.G_RET_STS_ERROR;

5230: END IF;
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;

Line 5237: IF (p_commit = FND_API.G_TRUE) THEN

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 ;
5240:
5241: IF l_debug_mode = 'Y' THEN

Line 5248: (p_encoded => FND_API.G_TRUE,

5244: END IF;
5245:
5246: IF l_msg_count = 1 THEN
5247: PA_INTERFACE_UTILS_PUB.get_messages
5248: (p_encoded => FND_API.G_TRUE,
5249: p_msg_index => 1,
5250: p_msg_count => l_msg_count,
5251: p_msg_data => l_msg_data,
5252: p_data => l_data,

Line 5264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5260: pa_debug.reset_curr_function;
5261: END IF ;
5262: RETURN;
5263: WHEN OTHERS THEN
5264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5265: x_msg_count := 1;
5266: x_msg_data := SQLERRM;
5267:
5268: IF (p_commit = FND_API.G_TRUE) THEN

Line 5268: IF (p_commit = FND_API.G_TRUE) THEN

5264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5265: x_msg_count := 1;
5266: x_msg_data := SQLERRM;
5267:
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'

Line 5301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

5297:
5298: PROCEDURE RUN_ACTION_CONC_PROCESS_WRP
5299: (
5300: p_api_version IN NUMBER :=1.0
5301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 5302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

5298: PROCEDURE RUN_ACTION_CONC_PROCESS_WRP
5299: (
5300: p_api_version IN NUMBER :=1.0
5301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'

Line 5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

5299: (
5300: p_api_version IN NUMBER :=1.0
5301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'
5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

5300: p_api_version IN NUMBER :=1.0
5301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'
5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5308: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

Line 5315: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5311: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5312: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5313: )
5314: IS
5315: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5316: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5317: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5318: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5319:

Line 5347: x_return_status := FND_API.G_RET_STS_SUCCESS;

5343:
5344: BEGIN
5345:
5346: x_msg_count := 0;
5347: x_return_status := FND_API.G_RET_STS_SUCCESS;
5348: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5349:
5350: IF l_debug_mode = 'Y' THEN
5351: pa_debug.g_err_stage:= 'Entering RUN_ACTION_CONC_PROCESS_WRP';

Line 5359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

5355: p_debug_mode => l_debug_mode );
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

Line 5364: IF (p_commit = 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
5365: savepoint RUN_ACTION_CONC_PROCESS_WRP_SP ;
5366: END IF;
5367:
5368: --Printing Input Parameters

Line 5386: l_return_status := FND_API.G_RET_STS_ERROR;

5382: IF l_debug_mode = 'Y' THEN
5383: pa_debug.g_err_stage:= 'Mandatory parameter to this API : Project ID is NULL';
5384: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5385: END IF;
5386: l_return_status := FND_API.G_RET_STS_ERROR;
5387: PA_UTILS.ADD_MESSAGE
5388: (p_app_short_name => 'PA',
5389: p_msg_name => 'PA_INV_PARAM_PASSED');
5390: RAISE Invalid_Arg_Exc_Dlv;

Line 5410: l_return_status := FND_API.G_RET_STS_ERROR;

5406: IF l_debug_mode = 'Y' THEN
5407: pa_debug.g_err_stage:= 'No Project Number returned for the passed Project ID ';
5408: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5409: END IF;
5410: l_return_status := FND_API.G_RET_STS_ERROR;
5411: PA_UTILS.ADD_MESSAGE
5412: (p_app_short_name => 'PA',
5413: p_msg_name => 'PA_INV_PARAM_PASSED');
5414: RAISE Invalid_Arg_Exc_Dlv;

Line 5427: l_return_status := FND_API.G_RET_STS_ERROR;

5423: IF l_debug_mode = 'Y' THEN
5424: pa_debug.g_err_stage:= 'No Project Number returned for the passed Project ID ';
5425: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5426: END IF;
5427: l_return_status := FND_API.G_RET_STS_ERROR;
5428: PA_UTILS.ADD_MESSAGE
5429: (p_app_short_name => 'PA',
5430: p_msg_name => 'PA_INV_PARAM_PASSED');
5431: RAISE Invalid_Arg_Exc_Dlv;

Line 5491: x_return_status := FND_API.G_RET_STS_ERROR;

5487: pa_debug.reset_curr_function; --Added for bug 4945876
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: /*

Line 5506: IF (p_commit = FND_API.G_TRUE) THEN

5502: /* IF c_project_sys_status_code%ISOPEN THEN
5503: CLOSE c_project_sys_status_code;
5504: END IF;*/
5505:
5506: IF (p_commit = FND_API.G_TRUE) THEN
5507: ROLLBACK TO RUN_ACTION_CONC_PROCESS_WRP_SP;
5508: END IF ;
5509:
5510: IF l_debug_mode = 'Y' THEN

Line 5517: (p_encoded => FND_API.G_TRUE,

5513: END IF;
5514:
5515: IF l_msg_count = 1 THEN
5516: PA_INTERFACE_UTILS_PUB.get_messages
5517: (p_encoded => FND_API.G_TRUE,
5518: p_msg_index => 1,
5519: p_msg_count => l_msg_count,
5520: p_msg_data => l_msg_data,
5521: p_data => l_data,

Line 5531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5527: pa_debug.reset_curr_function;
5528: END IF ;
5529: RETURN;
5530: WHEN OTHERS THEN
5531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5532: x_msg_count := 1;
5533: x_msg_data := SQLERRM;
5534:
5535: -- 3671408 cursor is not used now, removed below code

Line 5548: IF (p_commit = FND_API.G_TRUE) THEN

5544: /*IF c_project_sys_status_code%ISOPEN THEN
5545: CLOSE c_project_sys_status_code;
5546: END IF;*/
5547:
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'

Line 5589: x_return_status := FND_API.G_RET_STS_SUCCESS;

5585: WHERE PROJECT_ID = p_project_id;
5586:
5587: BEGIN
5588: x_msg_count := 0;
5589: x_return_status := FND_API.G_RET_STS_SUCCESS;
5590:
5591: IF p_project_id IS NULL THEN
5592: x_return_status := FND_API.G_RET_STS_ERROR;
5593: PA_UTILS.ADD_MESSAGE

Line 5592: x_return_status := FND_API.G_RET_STS_ERROR;

5588: x_msg_count := 0;
5589: x_return_status := FND_API.G_RET_STS_SUCCESS;
5590:
5591: IF p_project_id IS NULL THEN
5592: x_return_status := FND_API.G_RET_STS_ERROR;
5593: PA_UTILS.ADD_MESSAGE
5594: (p_app_short_name => 'PA',
5595: p_msg_name => 'PA_INV_PARAM_PASSED');
5596: RAISE Invalid_Arg_Exc_Dlv;

Line 5612: ,p_init_msg_list => FND_API.G_FALSE -- 3752898 , Passing False to avoid re-initialization of Message Stack

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
5614: ,p_project_number => l_project_number -- 3671408 , passing retrieved value
5615: ,x_return_status => x_return_status
5616: ,x_msg_count => x_msg_count

Line 5620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5616: ,x_msg_count => x_msg_count
5617: ,x_msg_data => x_msg_data
5618: );
5619:
5620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5621: RAISE Invalid_Arg_Exc_Dlv ;
5622: END IF ;
5623:
5624: EXCEPTION

Line 5632: x_return_status := FND_API.G_RET_STS_ERROR;

5628: IF c_project_details%ISOPEN THEN
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

Line 5637: x_return_status := FND_API.G_RET_STS_UNEXP_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;
5638: x_msg_count := FND_MSG_PUB.count_msg;
5639: x_msg_data := SQLERRM;
5640:
5641: -- 3671408 added code to handle cursor