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_DELIVERABLE_PROGRESS_PUB dependencies on FND_API

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_DELIVERABLE_PROGRESS_PUB';
5:
6: PROCEDURE UPDATE_DELIVERABLE_PROGRESS(
7: p_api_version IN NUMBER := 1.0 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
12: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

5:
6: PROCEDURE UPDATE_DELIVERABLE_PROGRESS(
7: p_api_version IN NUMBER := 1.0 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
12: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
13: p_action IN VARCHAR2 := 'SAVE' ,

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

6: PROCEDURE UPDATE_DELIVERABLE_PROGRESS(
7: p_api_version IN NUMBER := 1.0 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
12: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
13: p_action IN VARCHAR2 := 'SAVE' ,
14: p_bulk_load_flag IN VARCHAR2 := 'N' ,

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

7: p_api_version IN NUMBER := 1.0 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
12: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
13: p_action IN VARCHAR2 := 'SAVE' ,
14: p_bulk_load_flag IN VARCHAR2 := 'N' ,
15: p_progress_mode IN VARCHAR2 := 'FUTURE' ,

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

180: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'p_structure_type='||p_structure_type, x_Log_Level=> 3);
181: END IF;
182:
183:
184: IF (p_commit = FND_API.G_TRUE) THEN
185: savepoint UPDATE_DELIVERABLE_PROGRESS;
186: END IF;
187:
188: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 188: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

184: IF (p_commit = FND_API.G_TRUE) THEN
185: savepoint UPDATE_DELIVERABLE_PROGRESS;
186: END IF;
187:
188: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: savepoint UPDATE_DELIVERABLE_PROGRESS;
186: END IF;
187:
188: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
193: FND_MSG_PUB.initialize;

Line 192: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

188: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
193: FND_MSG_PUB.initialize;
194: END IF;
195:
196: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS;

192: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
193: FND_MSG_PUB.initialize;
194: END IF;
195:
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198:
199: --bug 4185364, start
200: -- if action is SAVE then delete al the present and future working records.

Line 290: RAISE FND_API.G_EXC_ERROR;

286: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
287: ,p_msg_name => 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL');
288: x_msg_data := 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL';
289: x_return_status := 'E';
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: */
293:
294: IF g1_debug_mode = 'Y' THEN

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: THEN
307: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
308: ,p_msg_name => 'PA_TP_CANT_NTER_DEL_PRG_CANCEL');
309: x_msg_data := 'PA_TP_CANT_NTER_DEL_PRG_CANCEL';
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: IF g1_debug_mode = 'Y' THEN

Line 311: RAISE FND_API.G_EXC_ERROR;

307: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
308: ,p_msg_name => 'PA_TP_CANT_NTER_DEL_PRG_CANCEL');
309: x_msg_data := 'PA_TP_CANT_NTER_DEL_PRG_CANCEL';
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: IF g1_debug_mode = 'Y' THEN
315: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Cancelled/On Hold Status', x_Log_Level=> 3);

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: THEN
350: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
351: ,p_msg_name => 'PA_TP_CANT_ENTER_DEL_PROG');
352: x_msg_data := 'PA_TP_CANT_ENTER_DEL_PROG';
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: IF p_progress_mode <> 'FUTURE'

Line 354: RAISE FND_API.G_EXC_ERROR;

350: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
351: ,p_msg_name => 'PA_TP_CANT_ENTER_DEL_PROG');
352: x_msg_data := 'PA_TP_CANT_ENTER_DEL_PROG';
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: IF p_progress_mode <> 'FUTURE'
358: THEN

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: THEN
359: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
361: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL

Line 363: RAISE FND_API.G_EXC_ERROR;

359: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
360: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
361: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
367: THEN

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367: THEN
368: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
369: ,p_msg_name => 'PA_TP_INV_AOD');
370: x_msg_data := 'PA_TP_INV_AOD';
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: /* FPM Dev CR 3

Line 372: RAISE FND_API.G_EXC_ERROR;

368: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
369: ,p_msg_name => 'PA_TP_INV_AOD');
370: x_msg_data := 'PA_TP_INV_AOD';
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: /* FPM Dev CR 3
376: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377: THEN
378: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
379: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
380: x_msg_data := 'PA_TP_INV_PRG_STAT';
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: */
385: -- FPM Dev CR 3 : Defaulting Progress Status

Line 382: RAISE FND_API.G_EXC_ERROR;

378: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
379: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
380: x_msg_data := 'PA_TP_INV_PRG_STAT';
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: */
385: -- FPM Dev CR 3 : Defaulting Progress Status
386: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: THEN
395: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
396: ,p_msg_name => 'PA_TP_INV_DLV_STAT'); -- FPM Dev CR 1 : Changed message
397: x_msg_data := 'PA_TP_INV_DLV_STAT';
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: IF g1_debug_mode = 'Y' THEN

Line 399: RAISE FND_API.G_EXC_ERROR;

395: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
396: ,p_msg_name => 'PA_TP_INV_DLV_STAT'); -- FPM Dev CR 1 : Changed message
397: x_msg_data := 'PA_TP_INV_DLV_STAT';
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: IF g1_debug_mode = 'Y' THEN
403: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After mode, status, as of date check', x_Log_Level=> 3);

Line 429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

425: ,x_msg_count => l_msg_count
426: ,x_msg_data => l_msg_data
427: );
428:
429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: IF g1_debug_mode = 'Y' THEN

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: ,x_msg_data => l_msg_data
427: );
428:
429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: IF g1_debug_mode = 'Y' THEN
434: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Status Change allowed', x_Log_Level=> 3);

Line 431: RAISE FND_API.G_EXC_ERROR;

427: );
428:
429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: IF g1_debug_mode = 'Y' THEN
434: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Status Change allowed', x_Log_Level=> 3);
435: END IF;

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: IF (l_percent_complete < 0 or l_percent_complete > 100) THEN
485: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
486: ,p_msg_name => 'PA_PERC_COMP_INV');
487: x_msg_data := 'PA_PERC_COMP_INV';
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492:

Line 489: RAISE FND_API.G_EXC_ERROR;

485: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
486: ,p_msg_name => 'PA_PERC_COMP_INV');
487: x_msg_data := 'PA_PERC_COMP_INV';
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492:
493: /* IF (l_percent_complete < 100 AND l_percent_complete_flag = 'Y') THEN

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: p_msg_name => 'PA_TP_INV_DEL_STATUS',
510: P_TOKEN1 => 'OBJECT_ID',
511: P_VALUE1 => p_object_id);
512: x_msg_data := 'PA_TP_INV_DEL_STATUS';
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: RAISE FND_API.G_EXC_ERROR;
515: END;
516:
517: --l_task_id is validated in pa_status_pub itself

Line 514: RAISE FND_API.G_EXC_ERROR;

510: P_TOKEN1 => 'OBJECT_ID',
511: P_VALUE1 => p_object_id);
512: x_msg_data := 'PA_TP_INV_DEL_STATUS';
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: RAISE FND_API.G_EXC_ERROR;
515: END;
516:
517: --l_task_id is validated in pa_status_pub itself
518: --l_as_of_date is validated in pa_status_pub

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: p_msg_name => 'PA_INVALID_PROG_STATUS',
529: P_TOKEN1 => 'OBJECT_ID',
530: P_VALUE1 => p_object_id);
531: x_msg_data := 'PA_INVALID_PROG_STATUS';
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: RAISE FND_API.G_EXC_ERROR;
534: END;
535: END IF; --p_calling_module = 'AMG'
536: -- Moved this from below while fixing for 3668168

Line 533: RAISE FND_API.G_EXC_ERROR;

529: P_TOKEN1 => 'OBJECT_ID',
530: P_VALUE1 => p_object_id);
531: x_msg_data := 'PA_INVALID_PROG_STATUS';
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: RAISE FND_API.G_EXC_ERROR;
534: END;
535: END IF; --p_calling_module = 'AMG'
536: -- Moved this from below while fixing for 3668168
537: -- Changed by rtarway for BUG 3668168

Line 604: x_return_status := FND_API.G_RET_STS_ERROR;

600: --THEN
601: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
602: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
603: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: RAISE FND_API.G_EXC_ERROR;
606: --END IF;
607: END IF;
608: --Added by rtarway for BUG 3668168, Else if

Line 605: RAISE FND_API.G_EXC_ERROR;

601: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
602: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
603: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: RAISE FND_API.G_EXC_ERROR;
606: --END IF;
607: END IF;
608: --Added by rtarway for BUG 3668168, Else if
609: ELSIF l_percent_complete_flag = 'N'

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: THEN
613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
614: p_msg_name => 'PA_TP_PCC_DISABL');
615: x_msg_data := 'PA_TP_PCC_DISABL';
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619: -- Added by rtarway , date validation check
620: IF l_del_status2 = 'DLVR_NOT_STARTED' AND NOT( l_actual_finish_date IS NULL ) OR

Line 617: RAISE FND_API.G_EXC_ERROR;

613: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
614: p_msg_name => 'PA_TP_PCC_DISABL');
615: x_msg_data := 'PA_TP_PCC_DISABL';
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619: -- Added by rtarway , date validation check
620: IF l_del_status2 = 'DLVR_NOT_STARTED' AND NOT( l_actual_finish_date IS NULL ) OR
621: l_del_status2 = 'DLVR_IN_PROGRESS' AND NOT ( l_actual_finish_date IS NULL ) OR

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: THEN
625: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
626: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
627: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631: END IF;
632:

Line 629: RAISE FND_API.G_EXC_ERROR;

625: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
626: ,p_msg_name => 'PA_DELP_STAT_DTES_PC_COMB' );
627: x_msg_data := 'PA_DELP_STAT_DTES_PC_COMB';
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631: END IF;
632:
633: -- 3982374 Calling deliverable status change validation to check deliverable status

Line 649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

645: ,x_msg_count => l_msg_count
646: ,x_msg_data => l_msg_data
647: );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653: IF g1_debug_mode = 'Y' THEN

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: ,x_msg_data => l_msg_data
647: );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653: IF g1_debug_mode = 'Y' THEN
654: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Status Change allowed', x_Log_Level=> 3);

Line 651: RAISE FND_API.G_EXC_ERROR;

647: );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653: IF g1_debug_mode = 'Y' THEN
654: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Status Change allowed', x_Log_Level=> 3);
655: END IF;

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: p_msg_name => 'PA_TP_INV_DEL_STATUS',
674: P_TOKEN1 => 'OBJECT_ID',
675: P_VALUE1 => p_object_id);
676: x_msg_data := 'PA_TP_INV_DEL_STATUS';
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: RAISE FND_API.G_EXC_ERROR;
679: END;
680:
681: --l_task_id is validated in pa_status_pub itself

Line 678: RAISE FND_API.G_EXC_ERROR;

674: P_TOKEN1 => 'OBJECT_ID',
675: P_VALUE1 => p_object_id);
676: x_msg_data := 'PA_TP_INV_DEL_STATUS';
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: RAISE FND_API.G_EXC_ERROR;
679: END;
680:
681: --l_task_id is validated in pa_status_pub itself
682: --l_as_of_date is validated in pa_status_pub

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692: p_msg_name => 'PA_INVALID_PROG_STATUS',
693: P_TOKEN1 => 'OBJECT_ID',
694: P_VALUE1 => p_object_id);
695: x_msg_data := 'PA_INVALID_PROG_STATUS';
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: RAISE FND_API.G_EXC_ERROR;
698: END;
699: END IF; --p_calling_module = 'AMG'
700: */

Line 697: RAISE FND_API.G_EXC_ERROR;

693: P_TOKEN1 => 'OBJECT_ID',
694: P_VALUE1 => p_object_id);
695: x_msg_data := 'PA_INVALID_PROG_STATUS';
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: RAISE FND_API.G_EXC_ERROR;
698: END;
699: END IF; --p_calling_module = 'AMG'
700: */
701: --Commented by rtarway, 3668168

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
758: p_msg_name => 'PA_TP_INV_AOD2');
759:
760: x_msg_data := 'PA_TP_WRONG_DEL_PRG_MODE3';
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: RAISE FND_API.G_EXC_ERROR;
763: --Commented by rtarway for Correction flow
764: -- FPM Dev CR 1 : Added the following IF condition
765: /*ELSIF trunc(p_as_of_date) <= trunc(NVL( l_last_progress_date, p_as_of_date-1)) AND l_progress_exists_on_aod = 'PUBLISHED' THEN

Line 762: RAISE FND_API.G_EXC_ERROR;

758: p_msg_name => 'PA_TP_INV_AOD2');
759:
760: x_msg_data := 'PA_TP_WRONG_DEL_PRG_MODE3';
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: RAISE FND_API.G_EXC_ERROR;
763: --Commented by rtarway for Correction flow
764: -- FPM Dev CR 1 : Added the following IF condition
765: /*ELSIF trunc(p_as_of_date) <= trunc(NVL( l_last_progress_date, p_as_of_date-1)) AND l_progress_exists_on_aod = 'PUBLISHED' THEN
766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: /*ELSIF trunc(p_as_of_date) <= trunc(NVL( l_last_progress_date, p_as_of_date-1)) AND l_progress_exists_on_aod = 'PUBLISHED' THEN
766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
767: ,p_msg_name => 'PA_TP_INV_AOD2');
768: x_msg_data := 'PA_TP_INV_AOD2';
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: RAISE FND_API.G_EXC_ERROR;*/
771: --End Commented by rtarway for Correction flow
772: ELSE
773: --Validate as of date

Line 770: RAISE FND_API.G_EXC_ERROR;*/

766: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
767: ,p_msg_name => 'PA_TP_INV_AOD2');
768: x_msg_data := 'PA_TP_INV_AOD2';
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: RAISE FND_API.G_EXC_ERROR;*/
771: --End Commented by rtarway for Correction flow
772: ELSE
773: --Validate as of date
774: -- Bug 3627315 : Check valid as of date should not be called from AMG or Task Progress Details page

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

785: --Message Changed by rtarway during Correction flow changes
786: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
787: ,p_msg_name => 'PA_TP_INV_AOD2');
788: x_msg_data := 'PA_TP_INV_AOD2';
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: RAISE FND_API.G_EXC_ERROR;
791:
792: END IF;*/
793: --

Line 790: RAISE FND_API.G_EXC_ERROR;

786: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
787: ,p_msg_name => 'PA_TP_INV_AOD2');
788: x_msg_data := 'PA_TP_INV_AOD2';
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: RAISE FND_API.G_EXC_ERROR;
791:
792: END IF;*/
793: --
794: --bug 4185364, not needed

Line 1021: RAISE FND_API.G_EXC_ERROR;

1017: );
1018:
1019: -- FPM Dev CR 3 : Raising Error
1020: IF Fnd_Msg_Pub.count_msg > 0 THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024:
1025:

Line 1196: RAISE FND_API.G_EXC_ERROR;

1192: );
1193:
1194:
1195: IF Fnd_Msg_Pub.count_msg > 0 THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198:
1199:
1200: ELSE

Line 1338: RAISE FND_API.G_EXC_ERROR;

1334: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
1335: );
1336:
1337: IF Fnd_Msg_Pub.count_msg > 0 THEN
1338: RAISE FND_API.G_EXC_ERROR;
1339: END IF;
1340:
1341: END IF;
1342:

Line 1430: RAISE FND_API.G_EXC_ERROR;

1426:
1427: );
1428:
1429: IF Fnd_Msg_Pub.count_msg > 0 THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
1434: p_project_id => p_project_id

Line 1583: RAISE FND_API.G_EXC_ERROR;

1579: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
1580: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
1581: );
1582: IF Fnd_Msg_Pub.count_msg > 0 THEN
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585:
1586: ELSE
1587:

Line 1724: RAISE FND_API.G_EXC_ERROR;

1720: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
1721: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
1722: );
1723: IF Fnd_Msg_Pub.count_msg > 0 THEN
1724: RAISE FND_API.G_EXC_ERROR;
1725: END IF;
1726:
1727: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Inserting progress rollup table', x_Log_Level=> 3);
1728: END IF;

Line 1774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1770: ,x_return_status => l_return_status
1771: ,x_msg_count => l_msg_count
1772: ,x_msg_data => l_msg_data );
1773:
1774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1775: THEN
1776: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1777: p_msg_name => l_msg_data
1778: );

Line 1780: x_return_status := FND_API.G_RET_STS_ERROR;

1776: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1777: p_msg_name => l_msg_data
1778: );
1779: x_msg_data := l_msg_data;
1780: x_return_status := FND_API.G_RET_STS_ERROR;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: */
1784:

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: p_msg_name => l_msg_data
1778: );
1779: x_msg_data := l_msg_data;
1780: x_return_status := FND_API.G_RET_STS_ERROR;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: */
1784:
1785: END IF;

Line 1793: when FND_API.G_EXC_ERROR then

1789: END IF;
1790:
1791:
1792: EXCEPTION
1793: when FND_API.G_EXC_ERROR then
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: l_msg_count := Fnd_Msg_Pub.count_msg;
1796:
1797: if p_commit = FND_API.G_TRUE then

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790:
1791:
1792: EXCEPTION
1793: when FND_API.G_EXC_ERROR then
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: l_msg_count := Fnd_Msg_Pub.count_msg;
1796:
1797: if p_commit = FND_API.G_TRUE then
1798: rollback to UPDATE_DELIVERABLE_PROGRESS;

Line 1797: if p_commit = FND_API.G_TRUE then

1793: when FND_API.G_EXC_ERROR then
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: l_msg_count := Fnd_Msg_Pub.count_msg;
1796:
1797: if p_commit = FND_API.G_TRUE then
1798: rollback to UPDATE_DELIVERABLE_PROGRESS;
1799: end if;
1800:
1801: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 1804: ( p_encoded => Fnd_Api.G_TRUE

1800:
1801: IF l_msg_count = 1 AND x_msg_data IS NULL
1802: THEN
1803: Pa_Interface_Utils_Pub.get_messages
1804: ( p_encoded => Fnd_Api.G_TRUE
1805: , p_msg_index => 1
1806: , p_msg_count => l_msg_count
1807: , p_msg_data => l_msg_data
1808: , p_data => l_data

Line 1817: when FND_API.G_EXC_UNEXPECTED_ERROR then

1813: x_msg_count := l_msg_count;
1814: END IF;
1815:
1816:
1817: when FND_API.G_EXC_UNEXPECTED_ERROR then
1818: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1819: x_msg_count := 1;
1820: x_msg_data := SQLERRM;
1821:

Line 1818: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1814: END IF;
1815:
1816:
1817: when FND_API.G_EXC_UNEXPECTED_ERROR then
1818: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1819: x_msg_count := 1;
1820: x_msg_data := SQLERRM;
1821:
1822: if p_commit = FND_API.G_TRUE then

Line 1822: if p_commit = FND_API.G_TRUE then

1818: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1819: x_msg_count := 1;
1820: x_msg_data := SQLERRM;
1821:
1822: if p_commit = FND_API.G_TRUE then
1823: rollback to UPDATE_DELIVERABLE_PROGRESS;
1824: end if;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_DELIVERABLE_PROGRESS_PUB',

Line 1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1821:
1822: if p_commit = FND_API.G_TRUE then
1823: rollback to UPDATE_DELIVERABLE_PROGRESS;
1824: end if;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_DELIVERABLE_PROGRESS_PUB',
1827: p_procedure_name => 'UPDATE_DELIVERABLE_PROGRESS',
1828: p_error_text => SUBSTRB(SQLERRM,1,240));
1829: when OTHERS then

Line 1831: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1827: p_procedure_name => 'UPDATE_DELIVERABLE_PROGRESS',
1828: p_error_text => SUBSTRB(SQLERRM,1,240));
1829: when OTHERS then
1830:
1831: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1832: x_msg_count := 1;
1833: x_msg_data := SUBSTRB(SQLERRM,1,240);
1834: if p_commit = FND_API.G_TRUE then
1835: rollback to UPDATE_DELIVERABLE_PROGRESS;

Line 1834: if p_commit = FND_API.G_TRUE then

1830:
1831: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1832: x_msg_count := 1;
1833: x_msg_data := SUBSTRB(SQLERRM,1,240);
1834: if p_commit = FND_API.G_TRUE then
1835: rollback to UPDATE_DELIVERABLE_PROGRESS;
1836: end if;
1837:
1838: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_DELIVERABLE_PROGRESS_PUB',