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 3160: IF p_commit = FND_API.G_TRUE THEN

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

Line 3164: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

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

Line 3169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3173: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 3185: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3305: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3306: RAISE FND_API.G_EXC_ERROR;

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

Line 3319: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3321: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

3318:
3319: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3321: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324:
3325: 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
3326:

Line 3343: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3344: RAISE FND_API.G_EXC_ERROR;

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

Line 3561: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 3566: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3569: RAISE FND_API.G_EXC_ERROR;

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

Line 3596: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3598: RAISE FND_API.G_EXC_ERROR;

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

Line 3629: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3631: RAISE FND_API.G_EXC_ERROR;

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

Line 3665: ,p_validate_only => FND_API.G_FALSE

3661:
3662: Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK (
3663: p_init_msg_list => p_init_msg_list
3664: ,p_commit => p_commit
3665: ,p_validate_only => FND_API.G_FALSE
3666: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3667: ,p_calling_module => 'AMG'
3668: ,p_debug_mode => p_debug_mode
3669: ,p_max_msg_count => NULL

Line 3666: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3662: Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK (
3663: p_init_msg_list => p_init_msg_list
3664: ,p_commit => p_commit
3665: ,p_validate_only => FND_API.G_FALSE
3666: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3667: ,p_calling_module => 'AMG'
3668: ,p_debug_mode => p_debug_mode
3669: ,p_max_msg_count => NULL
3670: ,p_name_tbl => l_action_name_tbl

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

3710: IF p_debug_mode = 'Y' THEN
3711: pa_debug.write(g_module_name,'Returned from Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK ['||x_return_status||']',5);
3712: END IF;
3713:
3714: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3716: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3717: RAISE FND_API.G_EXC_ERROR;
3718: END IF;

Line 3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3711: pa_debug.write(g_module_name,'Returned from Pa_Actions_Pub.CR_UP_DLV_ACTIONS_IN_BULK ['||x_return_status||']',5);
3712: END IF;
3713:
3714: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3716: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3717: RAISE FND_API.G_EXC_ERROR;
3718: END IF;
3719:

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

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

Line 3717: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3763: ']status['||x_return_status||']',5);
3764: END IF;
3765:
3766: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771:

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

3764: END IF;
3765:
3766: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771:
3772: IF p_debug_mode = 'Y' THEN

Line 3769: RAISE FND_API.G_EXC_ERROR;

3765:
3766: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771:
3772: IF p_debug_mode = 'Y' THEN
3773: pa_debug.write(g_module_name,'Should we update OKE attributes? '||l_update_oke_yn);

Line 4054: x_return_status := FND_API.G_RET_STS_ERROR;

4050: p_value2 => l_deliverable_number,
4051: p_token3 => 'MESSAGE',
4052: p_value3 => l_err_message
4053: );
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055: CLOSE C_org_name;
4056:
4057: -- Added for bug# 3810957 , throwing invalid cursor error
4058: -- here, C_org_name cursor was closed and second time closing it was throwing above error

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

4055: CLOSE C_org_name;
4056:
4057: -- Added for bug# 3810957 , throwing invalid cursor error
4058: -- here, C_org_name cursor was closed and second time closing it was throwing above error
4059: -- if invalid event org id , set return status to 'E' , close the cursor and raise FND_API.G_EXC_ERROR exception
4060: RAISE FND_API.G_EXC_ERROR;
4061: -- 3810957 end
4062: END IF;
4063: CLOSE C_org_name;

Line 4060: RAISE FND_API.G_EXC_ERROR;

4056:
4057: -- Added for bug# 3810957 , throwing invalid cursor error
4058: -- here, C_org_name cursor was closed and second time closing it was throwing above error
4059: -- if invalid event org id , set return status to 'E' , close the cursor and raise FND_API.G_EXC_ERROR exception
4060: RAISE FND_API.G_EXC_ERROR;
4061: -- 3810957 end
4062: END IF;
4063: CLOSE C_org_name;
4064: END IF;

Line 4212: , p_init_msg_list => FND_API.G_FALSE

4208: l_dlv_ship_action_rec.quantity := l_dlv_ship_action_tbl(i_ship1).quantity ;
4209:
4210: oke_amg_grp.manage_dlv_action
4211: ( p_api_version => p_api_version
4212: , p_init_msg_list => FND_API.G_FALSE
4213: , p_commit => p_commit
4214: , p_action => l_action
4215: , p_dlv_action_type => g_dlv_action_ship
4216: , p_master_inv_org_id => l_org_id

Line 4269: , p_init_msg_list => FND_API.G_FALSE

4265: l_dlv_req_action_rec.currency := l_dlv_req_action_tbl(i_proc1).currency ;
4266:
4267: oke_amg_grp.manage_dlv_action
4268: ( p_api_version => p_api_version
4269: , p_init_msg_list => FND_API.G_FALSE
4270: , p_commit => p_commit
4271: , p_action => l_action
4272: , p_dlv_action_type => g_dlv_action_proc
4273: , p_master_inv_org_id => l_org_id

Line 4299: ,p_init_msg_list => FND_API.G_FALSE

4295:
4296: Pa_Event_Pub.create_event
4297: ( p_api_version_number => p_api_version
4298: ,p_commit => p_commit
4299: ,p_init_msg_list => FND_API.G_FALSE
4300: ,p_pm_product_code => l_pm_source_code
4301: ,p_event_in_tbl => l_event_in_tbl
4302: ,p_event_out_tbl => l_event_out_tbl
4303: ,p_msg_count => x_msg_count

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

4308: IF p_debug_mode = 'Y' THEN
4309: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.create_event for billing action ['||x_return_status||']',5);
4310: END IF;
4311:
4312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;

Line 4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4309: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.create_event for billing action ['||x_return_status||']',5);
4310: END IF;
4311:
4312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;
4317:

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

4310: END IF;
4311:
4312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;
4317:
4318: ELSIF ( p_insert_or_update = g_update) THEN

Line 4315: RAISE FND_API.G_EXC_ERROR;

4311:
4312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4315: RAISE FND_API.G_EXC_ERROR;
4316: END IF;
4317:
4318: ELSIF ( p_insert_or_update = g_update) THEN
4319:

Line 4323: , p_init_msg_list => FND_API.G_FALSE

4319:
4320: Pa_Event_Pub.Update_Event
4321: ( p_api_version_number => p_api_version
4322: , p_commit => p_commit
4323: , p_init_msg_list => FND_API.G_FALSE
4324: , p_pm_product_code => l_pm_source_code
4325: , p_event_in_tbl => l_event_in_tbl
4326: , p_event_out_tbl => l_event_out_tbl
4327: , p_msg_count => x_msg_count

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

4332: IF p_debug_mode = 'Y' THEN
4333: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.update_event for billing action ['||x_return_status||']',5);
4334: END IF;
4335:
4336: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: END IF;

Line 4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4333: pa_debug.write(g_module_name,'Returned from Pa_Event_Pub.update_event for billing action ['||x_return_status||']',5);
4334: END IF;
4335:
4336: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: END IF;
4341:

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

4334: END IF;
4335:
4336: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: END IF;
4341:
4342: END IF; -- p_insert_or_update values

Line 4339: RAISE FND_API.G_EXC_ERROR;

4335:
4336: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4339: RAISE FND_API.G_EXC_ERROR;
4340: END IF;
4341:
4342: END IF; -- p_insert_or_update values
4343: END IF; -- i_bill > 0

Line 4351: WHEN FND_API.G_EXC_ERROR THEN

4347: pa_debug.write(g_module_name,l_api_name||': Exiting without error',5);
4348: END IF;
4349:
4350: EXCEPTION
4351: WHEN FND_API.G_EXC_ERROR THEN
4352: IF (p_commit = FND_API.G_TRUE) THEN
4353: ROLLBACK TO create_dlvr_actions_wrapper;
4354: END IF;
4355: x_return_status := FND_API.G_RET_STS_ERROR;

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

4348: END IF;
4349:
4350: EXCEPTION
4351: WHEN FND_API.G_EXC_ERROR THEN
4352: IF (p_commit = FND_API.G_TRUE) THEN
4353: ROLLBACK TO create_dlvr_actions_wrapper;
4354: END IF;
4355: x_return_status := FND_API.G_RET_STS_ERROR;
4356: l_msg_count := FND_MSG_PUB.count_msg;

Line 4355: x_return_status := FND_API.G_RET_STS_ERROR;

4351: WHEN FND_API.G_EXC_ERROR THEN
4352: IF (p_commit = FND_API.G_TRUE) THEN
4353: ROLLBACK TO create_dlvr_actions_wrapper;
4354: END IF;
4355: x_return_status := FND_API.G_RET_STS_ERROR;
4356: l_msg_count := FND_MSG_PUB.count_msg;
4357:
4358: IF l_msg_count = 1 AND x_msg_data IS NULL
4359: THEN

Line 4361: (p_encoded => FND_API.G_FALSE,

4357:
4358: IF l_msg_count = 1 AND x_msg_data IS NULL
4359: THEN
4360: PA_INTERFACE_UTILS_PUB.get_messages
4361: (p_encoded => FND_API.G_FALSE,
4362: p_msg_index => 1,
4363: p_msg_count => x_msg_count,
4364: p_msg_data => l_msg_data,
4365: p_data => l_data,

Line 4380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4376: pa_debug.reset_curr_function;
4377: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
4378: END IF;
4379:
4380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4381: IF (p_commit = FND_API.G_TRUE) THEN
4382: ROLLBACK TO create_dlvr_actions_wrapper;
4383: END IF;
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4377: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
4378: END IF;
4379:
4380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4381: IF (p_commit = FND_API.G_TRUE) THEN
4382: ROLLBACK TO create_dlvr_actions_wrapper;
4383: END IF;
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4385: l_msg_count := FND_MSG_PUB.count_msg;

Line 4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4381: IF (p_commit = FND_API.G_TRUE) THEN
4382: ROLLBACK TO create_dlvr_actions_wrapper;
4383: END IF;
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4385: l_msg_count := FND_MSG_PUB.count_msg;
4386:
4387: IF l_msg_count = 1 AND x_msg_data IS NULL
4388: THEN

Line 4390: (p_encoded => FND_API.G_FALSE,

4386:
4387: IF l_msg_count = 1 AND x_msg_data IS NULL
4388: THEN
4389: PA_INTERFACE_UTILS_PUB.get_messages
4390: (p_encoded => FND_API.G_FALSE,
4391: p_msg_index => 1,
4392: p_msg_count => x_msg_count,
4393: p_msg_data => l_msg_data,
4394: p_data => l_data,

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

4406: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);
4407: END IF;
4408:
4409: WHEN OTHERS THEN
4410: IF (p_commit = FND_API.G_TRUE) THEN
4411: ROLLBACK TO create_dlvr_actions_wrapper;
4412: END IF;
4413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4414: x_msg_count := 1;

Line 4413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4409: WHEN OTHERS THEN
4410: IF (p_commit = FND_API.G_TRUE) THEN
4411: ROLLBACK TO create_dlvr_actions_wrapper;
4412: END IF;
4413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4414: x_msg_count := 1;
4415: x_msg_data := SQLERRM;
4416:
4417: IF p_debug_mode = 'Y' THEN

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

4456: -- 3752898
4457: -- We need this variable only for passing to OKE API
4458: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,
4459: -- Its not correct to initialise this variable as TRUE .By default this value should be FALSE
4460: l_init_msg_list VARCHAR2(20) := FND_API.G_FALSE ;
4461:
4462: l_valid VARCHAR2(1);
4463:
4464: /* Commented for Bug Number 4907103

Line 4495: l_return_status := FND_API.G_RET_STS_SUCCESS;

4491: retcode := '0';
4492: errbuf := NULL;
4493:
4494: -- Initialize the return status to success
4495: l_return_status := FND_API.G_RET_STS_SUCCESS;
4496: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4497:
4498: IF l_debug_mode = 'Y' THEN
4499: pa_debug.set_curr_function( p_function => 'RUN_ACTION_CONC_PROCESS',

Line 4527: l_return_status := FND_API.G_RET_STS_ERROR;

4523: IF l_debug_mode = 'Y' THEN
4524: pa_debug.g_err_stage:= 'RUN_ACTION_CONC_PROCESS : Invalid value entered for Project Number From';
4525: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4526: END IF;
4527: l_return_status := FND_API.G_RET_STS_ERROR;
4528: PA_UTILS.ADD_MESSAGE
4529: (p_app_short_name => 'PA',
4530: p_msg_name => 'PA_INV_PARAM_PASSED');
4531: CLOSE c_valid_project_number_entry ;

Line 4543: l_return_status := FND_API.G_RET_STS_ERROR;

4539: IF l_debug_mode = 'Y' THEN
4540: pa_debug.g_err_stage:= 'RUN_ACTION_CONC_PROCESS : Invalid value entered for Project Number To' ;
4541: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4542: END IF;
4543: l_return_status := FND_API.G_RET_STS_ERROR;
4544: PA_UTILS.ADD_MESSAGE
4545: (p_app_short_name => 'PA',
4546: p_msg_name => 'PA_INV_PARAM_PASSED');
4547: CLOSE c_valid_project_number_entry ;

Line 4559: l_return_status := FND_API.G_RET_STS_ERROR;

4555: IF l_debug_mode = 'Y' THEN
4556: pa_debug.g_err_stage:= 'Mandatory parameter to this API : Function is NULL';
4557: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4558: END IF;
4559: l_return_status := FND_API.G_RET_STS_ERROR;
4560: PA_UTILS.ADD_MESSAGE
4561: (p_app_short_name => 'PA',
4562: p_msg_name => 'PA_INV_PARAM_PASSED');
4563: RAISE Invalid_Arg_Exc_Dlv;

Line 4616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4612: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4613: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4614: END IF;
4615:
4616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4617: RAISE Invalid_Arg_Exc_Dlv ;
4618: END IF ;
4619: ELSIF p_function = 'PROCUREMENT' THEN
4620: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

Line 4634: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4630: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4631: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4632: END IF;
4633:
4634: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4635: RAISE Invalid_Arg_Exc_Dlv ;
4636: END IF ;
4637:
4638: ELSIF p_function = 'BOTH' THEN

Line 4653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4649: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4650: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4651: END IF;
4652:
4653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4654: RAISE Invalid_Arg_Exc_Dlv ;
4655: END IF ;
4656: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4657: P_PROJECT_ID => l_project_id_tbl(l_count)

Line 4670: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4666: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4667: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4668: END IF;
4669:
4670: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4671: RAISE Invalid_Arg_Exc_Dlv ;
4672: END IF ;
4673:
4674: END IF;

Line 4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4707: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4708: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4709: END IF;
4710:
4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4712: RAISE Invalid_Arg_Exc_Dlv ;
4713: END IF ;
4714:
4715: ELSIF p_function = 'PROCUREMENT' THEN

Line 4735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4731: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4732: END IF;
4733:
4734:
4735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4736: RAISE Invalid_Arg_Exc_Dlv ;
4737: END IF ;
4738: ELSIF p_function = 'BOTH' THEN
4739:

Line 4758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4754: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4755: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4756: END IF;
4757:
4758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4759: RAISE Invalid_Arg_Exc_Dlv ;
4760: END IF ;
4761:
4762: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

Line 4776: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4772: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4773: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4774: END IF;
4775:
4776: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4777: RAISE Invalid_Arg_Exc_Dlv ;
4778: END IF ;
4779: END IF;
4780:

Line 4793: l_return_status := FND_API.G_RET_STS_ERROR;

4789:
4790: EXCEPTION
4791:
4792: WHEN Invalid_Arg_Exc_Dlv THEN
4793: l_return_status := FND_API.G_RET_STS_ERROR;
4794: l_msg_count := FND_MSG_PUB.count_msg;
4795: retcode := '-1';
4796:
4797: IF l_debug_mode = 'Y' THEN

Line 4816: (p_encoded => FND_API.G_TRUE,

4812: END IF ;
4813:
4814: IF l_msg_count >= 1 THEN
4815: PA_INTERFACE_UTILS_PUB.get_messages
4816: (p_encoded => FND_API.G_TRUE,
4817: p_msg_index => 1,
4818: p_msg_count => l_msg_count,
4819: p_msg_data => l_msg_data,
4820: p_data => l_data,

Line 4833: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4829: END IF ;
4830: 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 */
4831:
4832: WHEN OTHERS THEN
4833: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4834: retcode := '-1';
4835: errbuf := SQLERRM;
4836:
4837: IF c_project_id_range%ISOPEN THEN

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

4914: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
4915:
4916: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4917: (p_api_version IN NUMBER :=1.0
4918: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4919: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4920: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4921: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4922: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

4915:
4916: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4917: (p_api_version IN NUMBER :=1.0
4918: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4919: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4920: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4921: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4922: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4923: ,p_debug_mode IN VARCHAR2 :='N'

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

4916: PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
4917: (p_api_version IN NUMBER :=1.0
4918: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4919: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4920: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4921: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4922: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4923: ,p_debug_mode IN VARCHAR2 :='N'
4924: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4917: (p_api_version IN NUMBER :=1.0
4918: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
4919: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4920: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4921: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4922: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4923: ,p_debug_mode IN VARCHAR2 :='N'
4924: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4925: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

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

5011: l_object_id NUMBER;
5012: l_object_version_id NUMBER;
5013: l_project_id NUMBER;
5014:
5015: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5016: l_count NUMBER;
5017:
5018: BEGIN
5019:

Line 5026: x_return_status := FND_API.G_RET_STS_SUCCESS;

5022: -- to validation actions api for validations
5023: -- if validations are successful, call UPDATE_DLV_ACTIONS_IN_BULK api
5024:
5025: x_msg_count := 0;
5026: x_return_status := FND_API.G_RET_STS_SUCCESS;
5027: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5028:
5029: IF l_debug_mode = 'Y' THEN
5030: PA_DEBUG.set_curr_function( p_function => 'UPD_DLV_ACTIONS_IN_BULK_TM',

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

5038: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5039: pa_debug.write(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,3) ;
5040: END IF;
5041:
5042: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
5043: FND_MSG_PUB.initialize;
5044: END IF;
5045:
5046: IF (p_commit = FND_API.G_TRUE) THEN

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

5042: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
5043: FND_MSG_PUB.initialize;
5044: END IF;
5045:
5046: IF (p_commit = FND_API.G_TRUE) THEN
5047: savepoint CR_UP_DLV_ACTIONS_SP ;
5048: END IF;
5049:
5050: -- Call the validation API. It will

Line 5106: ( p_init_msg_list => FND_API.G_FALSE

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

Line 5131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5127: ,x_msg_count => x_msg_count
5128: ,x_msg_data => x_msg_data
5129: ) ;
5130:
5131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5132: l_return_status := FND_API.G_RET_STS_ERROR;
5133: END IF;
5134:
5135: END LOOP ;

Line 5132: l_return_status := FND_API.G_RET_STS_ERROR;

5128: ,x_msg_data => x_msg_data
5129: ) ;
5130:
5131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5132: l_return_status := FND_API.G_RET_STS_ERROR;
5133: END IF;
5134:
5135: END LOOP ;
5136:

Line 5139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5135: END LOOP ;
5136:
5137: END IF;
5138:
5139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5140: RAISE Invalid_Arg_Exc_Dlv ;
5141: END IF ;
5142:
5143: -- Loop through p_name_tbl to find out the

Line 5236: ,p_init_msg_list => FND_API.G_FALSE

5232: END IF;
5233:
5234: PA_ACTIONS_PUB.UPDATE_DLV_ACTIONS_IN_BULK
5235: (p_api_version => p_api_version
5236: ,p_init_msg_list => FND_API.G_FALSE
5237: ,p_commit => p_commit
5238: ,p_validate_only => p_validate_only
5239: ,p_validation_level => p_validation_level
5240: ,p_calling_module => p_calling_module

Line 5282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5278: ,x_msg_data => x_msg_data
5279: ) ;
5280:
5281:
5282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5283: RAISE Invalid_Arg_Exc_Dlv ;
5284: END IF ;
5285:
5286: END IF ;

Line 5289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5285:
5286: END IF ;
5287:
5288:
5289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5290: RAISE Invalid_Arg_Exc_Dlv ;
5291: END IF ;
5292:
5293: END IF ; -- Only if something is fetched

Line 5303: x_return_status := FND_API.G_RET_STS_ERROR;

5299: END IF;
5300:
5301: EXCEPTION
5302: WHEN Invalid_Arg_Exc_Dlv THEN
5303: x_return_status := FND_API.G_RET_STS_ERROR;
5304: l_msg_count := FND_MSG_PUB.count_msg;
5305:
5306: IF (p_commit = FND_API.G_TRUE) THEN
5307: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;

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

5302: WHEN Invalid_Arg_Exc_Dlv THEN
5303: x_return_status := FND_API.G_RET_STS_ERROR;
5304: l_msg_count := FND_MSG_PUB.count_msg;
5305:
5306: IF (p_commit = FND_API.G_TRUE) THEN
5307: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
5308: END IF ;
5309:
5310: IF l_debug_mode = 'Y' THEN

Line 5317: (p_encoded => FND_API.G_TRUE,

5313: END IF;
5314:
5315: IF l_msg_count = 1 THEN
5316: PA_INTERFACE_UTILS_PUB.get_messages
5317: (p_encoded => FND_API.G_TRUE,
5318: p_msg_index => 1,
5319: p_msg_count => l_msg_count,
5320: p_msg_data => l_msg_data,
5321: p_data => l_data,

Line 5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5329: pa_debug.reset_curr_function;
5330: END IF ;
5331: RETURN;
5332: WHEN OTHERS THEN
5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5334: x_msg_count := 1;
5335: x_msg_data := SQLERRM;
5336:
5337: IF (p_commit = FND_API.G_TRUE) THEN

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

5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5334: x_msg_count := 1;
5335: x_msg_data := SQLERRM;
5336:
5337: IF (p_commit = FND_API.G_TRUE) THEN
5338: ROLLBACK TO CR_UP_DLV_ACTIONS_SP;
5339: END IF ;
5340:
5341: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

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

5366:
5367: PROCEDURE RUN_ACTION_CONC_PROCESS_WRP
5368: (
5369: p_api_version IN NUMBER :=1.0
5370: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5371: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

5367: PROCEDURE RUN_ACTION_CONC_PROCESS_WRP
5368: (
5369: p_api_version IN NUMBER :=1.0
5370: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5371: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'

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

5368: (
5369: p_api_version IN NUMBER :=1.0
5370: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5371: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'
5376: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

5369: p_api_version IN NUMBER :=1.0
5370: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
5371: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
5372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'
5376: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5377: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

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

5380: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5381: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5382: )
5383: IS
5384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5385: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5386: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5387: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5388:

Line 5416: x_return_status := FND_API.G_RET_STS_SUCCESS;

5412:
5413: BEGIN
5414:
5415: x_msg_count := 0;
5416: x_return_status := FND_API.G_RET_STS_SUCCESS;
5417: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5418:
5419: IF l_debug_mode = 'Y' THEN
5420: pa_debug.g_err_stage:= 'Entering RUN_ACTION_CONC_PROCESS_WRP';

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

5424: p_debug_mode => l_debug_mode );
5425: END IF;
5426:
5427: -- Initialise Message Stack
5428: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
5429: FND_MSG_PUB.initialize;
5430: END IF;
5431:
5432: -- Define Save Point

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

5429: FND_MSG_PUB.initialize;
5430: END IF;
5431:
5432: -- Define Save Point
5433: IF (p_commit = FND_API.G_TRUE) THEN
5434: savepoint RUN_ACTION_CONC_PROCESS_WRP_SP ;
5435: END IF;
5436:
5437: --Printing Input Parameters

Line 5455: l_return_status := FND_API.G_RET_STS_ERROR;

5451: IF l_debug_mode = 'Y' THEN
5452: pa_debug.g_err_stage:= 'Mandatory parameter to this API : Project ID is NULL';
5453: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5454: END IF;
5455: l_return_status := FND_API.G_RET_STS_ERROR;
5456: PA_UTILS.ADD_MESSAGE
5457: (p_app_short_name => 'PA',
5458: p_msg_name => 'PA_INV_PARAM_PASSED');
5459: RAISE Invalid_Arg_Exc_Dlv;

Line 5479: l_return_status := FND_API.G_RET_STS_ERROR;

5475: IF l_debug_mode = 'Y' THEN
5476: pa_debug.g_err_stage:= 'No Project Number returned for the passed Project ID ';
5477: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5478: END IF;
5479: l_return_status := FND_API.G_RET_STS_ERROR;
5480: PA_UTILS.ADD_MESSAGE
5481: (p_app_short_name => 'PA',
5482: p_msg_name => 'PA_INV_PARAM_PASSED');
5483: RAISE Invalid_Arg_Exc_Dlv;

Line 5496: l_return_status := FND_API.G_RET_STS_ERROR;

5492: IF l_debug_mode = 'Y' THEN
5493: pa_debug.g_err_stage:= 'No Project Number returned for the passed Project ID ';
5494: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5495: END IF;
5496: l_return_status := FND_API.G_RET_STS_ERROR;
5497: PA_UTILS.ADD_MESSAGE
5498: (p_app_short_name => 'PA',
5499: p_msg_name => 'PA_INV_PARAM_PASSED');
5500: RAISE Invalid_Arg_Exc_Dlv;

Line 5560: x_return_status := FND_API.G_RET_STS_ERROR;

5556: pa_debug.reset_curr_function; --Added for bug 4945876
5557: END IF;
5558: EXCEPTION
5559: WHEN Invalid_Arg_Exc_Dlv THEN
5560: x_return_status := FND_API.G_RET_STS_ERROR;
5561: l_msg_count := FND_MSG_PUB.count_msg;
5562:
5563: -- 3671408 cursor is not used now , commented below code
5564: /*

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

5571: /* IF c_project_sys_status_code%ISOPEN THEN
5572: CLOSE c_project_sys_status_code;
5573: END IF;*/
5574:
5575: IF (p_commit = FND_API.G_TRUE) THEN
5576: ROLLBACK TO RUN_ACTION_CONC_PROCESS_WRP_SP;
5577: END IF ;
5578:
5579: IF l_debug_mode = 'Y' THEN

Line 5586: (p_encoded => FND_API.G_TRUE,

5582: END IF;
5583:
5584: IF l_msg_count = 1 THEN
5585: PA_INTERFACE_UTILS_PUB.get_messages
5586: (p_encoded => FND_API.G_TRUE,
5587: p_msg_index => 1,
5588: p_msg_count => l_msg_count,
5589: p_msg_data => l_msg_data,
5590: p_data => l_data,

Line 5600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5596: pa_debug.reset_curr_function;
5597: END IF ;
5598: RETURN;
5599: WHEN OTHERS THEN
5600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5601: x_msg_count := 1;
5602: x_msg_data := SQLERRM;
5603:
5604: -- 3671408 cursor is not used now, removed below code

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

5613: /*IF c_project_sys_status_code%ISOPEN THEN
5614: CLOSE c_project_sys_status_code;
5615: END IF;*/
5616:
5617: IF (p_commit = FND_API.G_TRUE) THEN
5618: ROLLBACK TO RUN_ACTION_CONC_PROCESS_WRP_SP;
5619: END IF ;
5620:
5621: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PUB'

Line 5658: x_return_status := FND_API.G_RET_STS_SUCCESS;

5654: WHERE PROJECT_ID = p_project_id;
5655:
5656: BEGIN
5657: x_msg_count := 0;
5658: x_return_status := FND_API.G_RET_STS_SUCCESS;
5659:
5660: IF p_project_id IS NULL THEN
5661: x_return_status := FND_API.G_RET_STS_ERROR;
5662: PA_UTILS.ADD_MESSAGE

Line 5661: x_return_status := FND_API.G_RET_STS_ERROR;

5657: x_msg_count := 0;
5658: x_return_status := FND_API.G_RET_STS_SUCCESS;
5659:
5660: IF p_project_id IS NULL THEN
5661: x_return_status := FND_API.G_RET_STS_ERROR;
5662: PA_UTILS.ADD_MESSAGE
5663: (p_app_short_name => 'PA',
5664: p_msg_name => 'PA_INV_PARAM_PASSED');
5665: RAISE Invalid_Arg_Exc_Dlv;

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

5677:
5678: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS_WRP
5679: (
5680: p_calling_module => 'FORMS'
5681: ,p_init_msg_list => FND_API.G_FALSE -- 3752898 , Passing False to avoid re-initialization of Message Stack
5682: ,p_project_id => p_project_id
5683: ,p_project_number => l_project_number -- 3671408 , passing retrieved value
5684: ,x_return_status => x_return_status
5685: ,x_msg_count => x_msg_count

Line 5689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5685: ,x_msg_count => x_msg_count
5686: ,x_msg_data => x_msg_data
5687: );
5688:
5689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5690: RAISE Invalid_Arg_Exc_Dlv ;
5691: END IF ;
5692:
5693: EXCEPTION

Line 5701: x_return_status := FND_API.G_RET_STS_ERROR;

5697: IF c_project_details%ISOPEN THEN
5698: CLOSE c_project_details;
5699: END IF;
5700:
5701: x_return_status := FND_API.G_RET_STS_ERROR;
5702: x_msg_count := FND_MSG_PUB.count_msg;
5703: x_msg_data :='Invalid Argument Exception inside RUN_ACTION_CONC_FRM_WRP' || x_msg_data;
5704: RETURN;
5705: WHEN OTHERS THEN

Line 5706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5702: x_msg_count := FND_MSG_PUB.count_msg;
5703: x_msg_data :='Invalid Argument Exception inside RUN_ACTION_CONC_FRM_WRP' || x_msg_data;
5704: RETURN;
5705: WHEN OTHERS THEN
5706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5707: x_msg_count := FND_MSG_PUB.count_msg;
5708: x_msg_data := SQLERRM;
5709:
5710: -- 3671408 added code to handle cursor