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_PROJECT_CHECK_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

33: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
34: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
35: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
36: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: --Project Structure changes done for bug 2765115

Line 38: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

34: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
35: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
36: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: --Project Structure changes done for bug 2765115
42: , p_structure_type IN VARCHAR2 := 'FINANCIAL'

Line 39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

35: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
36: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: --Project Structure changes done for bug 2765115
42: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
43: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

36: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
37: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: --Project Structure changes done for bug 2765115
42: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
43: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: --END Project Structure changes done for bug 2765115

Line 43: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

39: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: --Project Structure changes done for bug 2765115
42: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
43: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: --END Project Structure changes done for bug 2765115
45: , p_delete_task_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
46: )
47: IS

Line 205: IF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

201:
202: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id_out );
203: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id_out );
204:
205: IF ( p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
206: OR p_task_version_id IS NULL ) AND
207: l_workplan_enabled = 'Y' AND
208: l_versioning_enabled = 'Y'
209: THEN

Line 212: pa_interface_utils_pub.map_new_amg_msg

208: l_versioning_enabled = 'Y'
209: THEN
210: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
211: THEN
212: pa_interface_utils_pub.map_new_amg_msg
213: ( p_old_message_code => 'PA_PS_TSK_VER_REQ_WP'
214: ,p_msg_attribute => 'CHANGE'
215: ,p_resize_flag => 'N'
216: ,p_msg_context => 'GENERAL'

Line 264: pa_interface_utils_pub.map_new_amg_msg

260: l_workplan_enabled = 'Y'
261: THEN
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
263: THEN
264: pa_interface_utils_pub.map_new_amg_msg
265: ( p_old_message_code => 'PA_STRUCT_VER_NO_UPDATE'
266: ,p_msg_attribute => 'CHANGE'
267: ,p_resize_flag => 'N'
268: ,p_msg_context => 'GENERAL'

Line 282: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

278:
279: IF p_structure_type = 'FINANCIAL' --Project Structure changes done for bug 2765115
280: THEN
281:
282: IF p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
283: THEN
284: l_amg_task_number := null;
285: OPEN l_amg_task_csr( p_task_id );
286: FETCH l_amg_task_csr INTO l_amg_task_number;

Line 317: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

313:
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: */
317: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
318: (p_task_number=> ''
319: ,p_task_reference => p_pm_task_reference
320: ,p_task_id => l_task_id_out);
321:

Line 336: /* l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

332: OPEN l_amg_task_csr( l_task_id_out );
333: FETCH l_amg_task_csr INTO l_amg_task_number;
334: CLOSE l_amg_task_csr;
335: */
336: /* l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
337: (p_task_number=> ''
338: ,p_task_reference => p_pm_task_reference
339: ,p_task_id => l_task_id_out);
340: */

Line 372: pa_interface_utils_pub.map_new_amg_msg

368:
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
370: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
371: THEN
372: pa_interface_utils_pub.map_new_amg_msg
373: ( p_old_message_code => 'PA_CHECK_DELETE_TASK_FAILED'
374: ,p_msg_attribute => 'CHANGE'
375: ,p_resize_flag => 'Y'
376: ,p_msg_context => 'DELT'

Line 383: pa_interface_utils_pub.map_new_amg_msg

379: ,p_attribute3 => ''
380: ,p_attribute4 => ''
381: ,p_attribute5 => '');
382: ELSE
383: pa_interface_utils_pub.map_new_amg_msg
384: ( p_old_message_code => l_error_message_code
385: ,p_msg_attribute => 'SPLIT'
386: ,p_resize_flag => 'Y'
387: ,p_msg_context => 'DELT'

Line 401: pa_interface_utils_pub.map_new_amg_msg

397: THEN
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
399: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
400: THEN
401: pa_interface_utils_pub.map_new_amg_msg
402: ( p_old_message_code => 'PA_CHECK_DELETE_TASK_FAILED'
403: ,p_msg_attribute => 'CHANGE'
404: ,p_resize_flag => 'Y'
405: ,p_msg_context => 'DELT'

Line 412: pa_interface_utils_pub.map_new_amg_msg

408: ,p_attribute3 => ''
409: ,p_attribute4 => ''
410: ,p_attribute5 => '');
411: ELSE
412: pa_interface_utils_pub.map_new_amg_msg
413: ( p_old_message_code => l_err_stage
414: ,p_msg_attribute => 'SPLIT'
415: ,p_resize_flag => 'Y'
416: ,p_msg_context => 'DELT'

Line 500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

496: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
497: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
498: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
499: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
501: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
502: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */

Line 501: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

497: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
498: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
499: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
501: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
502: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
505: )

Line 502: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

498: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
499: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
501: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
502: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
505: )
506: IS

Line 503: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

499: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
500: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
501: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
502: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
505: )
506: IS
507: l_api_name CONSTANT VARCHAR2(30) := 'Check_Add_Subtask_Ok_Pvt';

Line 600: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

596: OPEN l_amg_task_csr( l_task_id_out );
597: FETCH l_amg_task_csr INTO l_amg_task_number;
598: CLOSE l_amg_task_csr;
599: */
600: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
601: (p_task_number=> ''
602: ,p_task_reference => p_pm_task_reference
603: ,p_task_id => l_task_id_out);
604:

Line 619: pa_interface_utils_pub.map_new_amg_msg

615: p_add_subtask_ok_flag := 'N';
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
617: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
618: THEN
619: pa_interface_utils_pub.map_new_amg_msg
620: ( p_old_message_code => 'PA_CHECK_ADD_SUBTASK_FAILED'
621: ,p_msg_attribute => 'CHANGE'
622: ,p_resize_flag => 'Y'
623: ,p_msg_context => 'ADDT'

Line 630: pa_interface_utils_pub.map_new_amg_msg

626: ,p_attribute3 => ''
627: ,p_attribute4 => ''
628: ,p_attribute5 => '');
629: ELSE
630: pa_interface_utils_pub.map_new_amg_msg
631: ( p_old_message_code => l_err_stage
632: ,p_msg_attribute => 'SPLIT'
633: ,p_resize_flag => 'Y'
634: ,p_msg_context => 'ADDST'

Line 648: pa_interface_utils_pub.map_new_amg_msg

644: THEN
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
647: THEN
648: pa_interface_utils_pub.map_new_amg_msg
649: ( p_old_message_code => 'PA_CHECK_ADD_SUBTASK_FAILED'
650: ,p_msg_attribute => 'CHANGE'
651: ,p_resize_flag => 'Y'
652: ,p_msg_context => 'ADDT'

Line 659: pa_interface_utils_pub.map_new_amg_msg

655: ,p_attribute3 => ''
656: ,p_attribute4 => ''
657: ,p_attribute5 => '');
658: ELSE
659: pa_interface_utils_pub.map_new_amg_msg
660: ( p_old_message_code => l_err_stage
661: ,p_msg_attribute => 'SPLIT'
662: ,p_resize_flag => 'Y'
663: ,p_msg_context => 'ADDST'

Line 748: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

744: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
745: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
746: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
747: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
748: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
749: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
750: , p_pm_task_reference IN VARCHAR2
751: , p_unique_task_ref_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
752: )

Line 749: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

745: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
746: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
747: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
748: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
749: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
750: , p_pm_task_reference IN VARCHAR2
751: , p_unique_task_ref_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
752: )
753: IS

Line 1010: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1006: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1007: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1008: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1009: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1010: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1011: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1012: , p_delete_project_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1013: )
1014: IS

Line 1011: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1007: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1008: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1009: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1010: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1011: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1012: , p_delete_project_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1013: )
1014: IS
1015: l_api_name CONSTANT VARCHAR2(30) := 'Check_Delete_Project_Ok_Pvt';

Line 1090: pa_interface_utils_pub.map_new_amg_msg

1086: p_delete_project_ok_flag := 'N';
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
1089: THEN
1090: pa_interface_utils_pub.map_new_amg_msg
1091: ( p_old_message_code => 'PA_CHECK_DEL_PROJECT_FAILED'
1092: ,p_msg_attribute => 'CHANGE'
1093: ,p_resize_flag => 'Y'
1094: ,p_msg_context => 'PROJ'

Line 1101: pa_interface_utils_pub.map_new_amg_msg

1097: ,p_attribute3 => ''
1098: ,p_attribute4 => ''
1099: ,p_attribute5 => '');
1100: ELSE
1101: pa_interface_utils_pub.map_new_amg_msg
1102: ( p_old_message_code => l_err_stage
1103: ,p_msg_attribute => 'SPLIT'
1104: ,p_resize_flag => 'Y'
1105: ,p_msg_context => 'DELP'

Line 1119: pa_interface_utils_pub.map_new_amg_msg

1115: THEN
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1117: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
1118: THEN
1119: pa_interface_utils_pub.map_new_amg_msg
1120: ( p_old_message_code => 'PA_CHECK_DEL_PROJECT_FAILED'
1121: ,p_msg_attribute => 'CHANGE'
1122: ,p_resize_flag => 'Y'
1123: ,p_msg_context => 'PROJ'

Line 1130: pa_interface_utils_pub.map_new_amg_msg

1126: ,p_attribute3 => ''
1127: ,p_attribute4 => ''
1128: ,p_attribute5 => '');
1129: ELSE
1130: pa_interface_utils_pub.map_new_amg_msg
1131: ( p_old_message_code => l_err_stage
1132: ,p_msg_attribute => 'SPLIT'
1133: ,p_resize_flag => 'Y'
1134: ,p_msg_context => 'DELP'

Line 1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1210: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1211: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1212: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1213: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1211: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1212: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1213: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1212: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1213: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1220: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */

Line 1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1213: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1220: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1221: )

Line 1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1214: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1220: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1221: )
1222: IS

Line 1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1215: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1216: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1217: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1218: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1219: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1220: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1221: )
1222: IS
1223:

Line 1413: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1410: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1411: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1412: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1413: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1414: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1415: , p_change_project_org_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1416: )
1417: IS

Line 1414: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1410: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1411: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1412: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1413: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1414: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1415: , p_change_project_org_ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1416: )
1417: IS
1418:

Line 1494: pa_interface_utils_pub.map_new_amg_msg

1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1491: THEN
1492: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1493: THEN
1494: pa_interface_utils_pub.map_new_amg_msg
1495: ( p_old_message_code => 'PA_PR_CANT_CHG_PROJ_TYPE'
1496: ,p_msg_attribute => 'CHANGE'
1497: ,p_resize_flag => 'N'
1498: ,p_msg_context => 'PROJ'

Line 1505: pa_interface_utils_pub.map_new_amg_msg

1501: ,p_attribute3 => ''
1502: ,p_attribute4 => ''
1503: ,p_attribute5 => '');
1504: ELSE
1505: pa_interface_utils_pub.map_new_amg_msg
1506: ( p_old_message_code => l_err_stage
1507: ,p_msg_attribute => 'CHANGE'
1508: ,p_resize_flag => 'N'
1509: ,p_msg_context => 'PROJ'

Line 1524: pa_interface_utils_pub.map_new_amg_msg

1520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1521: THEN
1522: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1523: THEN
1524: pa_interface_utils_pub.map_new_amg_msg
1525: ( p_old_message_code => 'PA_PR_CANT_CHG_PROJ_TYPE'
1526: ,p_msg_attribute => 'CHANGE'
1527: ,p_resize_flag => 'N'
1528: ,p_msg_context => 'PROJ'

Line 1535: pa_interface_utils_pub.map_new_amg_msg

1531: ,p_attribute3 => ''
1532: ,p_attribute4 => ''
1533: ,p_attribute5 => '');
1534: ELSE
1535: pa_interface_utils_pub.map_new_amg_msg
1536: ( p_old_message_code => l_err_stage
1537: ,p_msg_attribute => 'CHANGE'
1538: ,p_resize_flag => 'N'
1539: ,p_msg_context => 'PROJ'

Line 1618: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1615: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1616: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1617: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1618: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1619: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1620: , p_task_number IN VARCHAR2
1621: , p_unique_task_number_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1622: )

Line 1619: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1615: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1616: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1617: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1618: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1619: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1620: , p_task_number IN VARCHAR2
1621: , p_unique_task_number_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1622: )
1623: IS

Line 1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1752: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1753: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1754: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1755: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1757: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1758: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1759: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1760: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */

Line 1757: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1753: , p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1754: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1755: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1757: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1758: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1759: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1760: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1761: )

Line 1758: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1754: , p_msg_count OUT NOCOPY NUMBER /*Added the nocopy check for 4537865 */
1755: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1757: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1758: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1759: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1760: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1761: )
1762: IS

Line 1759: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1755: , p_msg_data OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1756: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1757: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1758: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1759: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1760: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1761: )
1762: IS
1763:

Line 1854: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

1850: OPEN l_amg_task_csr( l_task_id_out );
1851: FETCH l_amg_task_csr INTO l_amg_task_number;
1852: CLOSE l_amg_task_csr;
1853: */
1854: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
1855: (p_task_number=> ''
1856: ,p_task_reference => p_pm_task_reference
1857: ,p_task_id => l_task_id_out);
1858:

Line 1873: pa_interface_utils_pub.map_new_amg_msg

1869: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1870: THEN
1871: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1872: THEN
1873: pa_interface_utils_pub.map_new_amg_msg
1874: ( p_old_message_code => 'PA_CHANGE_TASK_NUM_OK_FAILED'
1875: ,p_msg_attribute => 'CHANGE'
1876: ,p_resize_flag => 'Y'
1877: ,p_msg_context => 'MODT'

Line 1884: pa_interface_utils_pub.map_new_amg_msg

1880: ,p_attribute3 => ''
1881: ,p_attribute4 => ''
1882: ,p_attribute5 => '');
1883: ELSE
1884: pa_interface_utils_pub.map_new_amg_msg
1885: ( p_old_message_code => l_err_stage
1886: ,p_msg_attribute => 'CHANGE'
1887: ,p_resize_flag => 'N'
1888: ,p_msg_context => 'MODT'

Line 1904: pa_interface_utils_pub.map_new_amg_msg

1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1903: THEN
1904: pa_interface_utils_pub.map_new_amg_msg
1905: ( p_old_message_code => 'PA_CHANGE_TASK_NUM_OK_FAILED'
1906: ,p_msg_attribute => 'CHANGE'
1907: ,p_resize_flag => 'Y'
1908: ,p_msg_context => 'MODT'

Line 1915: pa_interface_utils_pub.map_new_amg_msg

1911: ,p_attribute3 => ''
1912: ,p_attribute4 => ''
1913: ,p_attribute5 => '');
1914: ELSE
1915: pa_interface_utils_pub.map_new_amg_msg
1916: ( p_old_message_code => l_err_stage
1917: ,p_msg_attribute => 'CHANGE'
1918: ,p_resize_flag => 'N'
1919: ,p_msg_context => 'MODT'

Line 2157: IF (l_task_rec.labor_sch_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2153:
2154: -- Need to validate all fields if CONTRACT project
2155: IF p_project_class_code = 'CONTRACT' THEN
2156:
2157: IF (l_task_rec.labor_sch_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2158: AND l_task_rec.labor_sch_type IS NOT NULL)
2159: AND l_task_rec.labor_sch_type NOT IN ('I','B')
2160: THEN
2161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2163: pa_interface_utils_pub.map_new_amg_msg

2159: AND l_task_rec.labor_sch_type NOT IN ('I','B')
2160: THEN
2161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2162: THEN
2163: pa_interface_utils_pub.map_new_amg_msg
2164: ( p_old_message_code => 'PA_INVALID_LABOR_SCH_TYPE'
2165: ,p_msg_attribute => 'CHANGE'
2166: ,p_resize_flag => 'N'
2167: ,p_msg_context => 'GENERAL'

Line 2177: IF (l_task_rec.non_labor_sch_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2173: END IF;
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176:
2177: IF (l_task_rec.non_labor_sch_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2178: AND l_task_rec.non_labor_sch_type IS NOT NULL)
2179: AND l_task_rec.non_labor_sch_type NOT IN ('I','B')
2180: THEN
2181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2183: pa_interface_utils_pub.map_new_amg_msg

2179: AND l_task_rec.non_labor_sch_type NOT IN ('I','B')
2180: THEN
2181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2182: THEN
2183: pa_interface_utils_pub.map_new_amg_msg
2184: ( p_old_message_code => 'PA_INVALID_NON_LABOR_SCH_TYPE'
2185: ,p_msg_attribute => 'CHANGE'
2186: ,p_resize_flag => 'Y'
2187: ,p_msg_context => 'GENERAL'

Line 2200: AND l_task_rec.labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2196: /* Commented for Bug No 4721987
2197: IF l_task_rec.labor_sch_type = 'I' -- (I- burden schedule B-Bill rate sch)
2198: -- ensure that bill rate orgid is not supplied
2199: AND (l_task_rec.labor_bill_rate_org_id IS NOT NULL
2200: AND l_task_rec.labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2201: THEN
2202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2203: THEN
2204: pa_interface_utils_pub.map_new_amg_msg

Line 2204: pa_interface_utils_pub.map_new_amg_msg

2200: AND l_task_rec.labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2201: THEN
2202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2203: THEN
2204: pa_interface_utils_pub.map_new_amg_msg
2205: ( p_old_message_code => 'PA_LBR_ORG_ID_NOT_VALID'
2206: ,p_msg_attribute => 'CHANGE'
2207: ,p_resize_flag => 'N'
2208: ,p_msg_context => 'GENERAL'

Line 2221: AND l_task_rec.non_labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2217:
2218: IF l_task_rec.non_labor_sch_type = 'I' --(I- burden schedule B-Bill rate sch)
2219: -- ensure that bill rate orgid is not supplied
2220: AND (l_task_rec.non_labor_bill_rate_org_id IS NOT NULL
2221: AND l_task_rec.non_labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2222: THEN
2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2224: THEN
2225: pa_interface_utils_pub.map_new_amg_msg

Line 2225: pa_interface_utils_pub.map_new_amg_msg

2221: AND l_task_rec.non_labor_bill_rate_org_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2222: THEN
2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2224: THEN
2225: pa_interface_utils_pub.map_new_amg_msg
2226: ( p_old_message_code => 'PA_NON_LBR_ORG_ID_NOT_VALID'
2227: ,p_msg_attribute => 'CHANGE'
2228: ,p_resize_flag => 'Y'
2229: ,p_msg_context => 'GENERAL'

Line 2246: IF l_task_rec.inv_ind_rate_sch_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2242:
2243: -- ensure that invoice schedule is specified if labor or non labor
2244: -- sch types are burden schedules
2245:
2246: IF l_task_rec.inv_ind_rate_sch_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2247: OR l_task_rec.inv_ind_rate_sch_id IS NULL
2248: THEN
2249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2250: THEN

Line 2251: pa_interface_utils_pub.map_new_amg_msg

2247: OR l_task_rec.inv_ind_rate_sch_id IS NULL
2248: THEN
2249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2250: THEN
2251: pa_interface_utils_pub.map_new_amg_msg
2252: ( p_old_message_code => 'PA_INV_IND_RATE_SCH_ID_REQD'
2253: ,p_msg_attribute => 'CHANGE'
2254: ,p_resize_flag => 'Y'
2255: ,p_msg_context => 'GENERAL'

Line 2266: IF l_task_rec.rev_ind_rate_sch_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264:
2265: -- ensure that revenue schedule is specified
2266: IF l_task_rec.rev_ind_rate_sch_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2267: OR l_task_rec.rev_ind_rate_sch_id IS NULL
2268: THEN
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2270: THEN

Line 2271: pa_interface_utils_pub.map_new_amg_msg

2267: OR l_task_rec.rev_ind_rate_sch_id IS NULL
2268: THEN
2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2270: THEN
2271: pa_interface_utils_pub.map_new_amg_msg
2272: ( p_old_message_code => 'PA_REV_IND_RATE_SCH_ID_REQD'
2273: ,p_msg_attribute => 'CHANGE'
2274: ,p_resize_flag => 'Y'
2275: ,p_msg_context => 'GENERAL'

Line 2295: pa_interface_utils_pub.map_new_amg_msg

2291:
2292: CLOSE l_burden_sch_csr;
2293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN
2295: pa_interface_utils_pub.map_new_amg_msg
2296: ( p_old_message_code => 'PA_INV_IND_RATE_SCH_ID_INV'
2297: ,p_msg_attribute => 'CHANGE'
2298: ,p_resize_flag => 'N'
2299: ,p_msg_context => 'GENERAL'

Line 2320: pa_interface_utils_pub.map_new_amg_msg

2316: THEN
2317: CLOSE l_burden_sch_csr;
2318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2319: THEN
2320: pa_interface_utils_pub.map_new_amg_msg
2321: ( p_old_message_code => 'PA_REV_IND_RATE_SCH_ID_INV'
2322: ,p_msg_attribute => 'CHANGE'
2323: ,p_resize_flag => 'N'
2324: ,p_msg_context => 'GENERAL'

Line 2343: OR l_task_rec.labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2339: IF l_task_rec.labor_sch_type = 'B' -- (I- burden schedule B-Bill rate sch)
2340: THEN
2341:
2342: IF (l_task_rec.labor_bill_rate_org_id IS NULL
2343: OR l_task_rec.labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2344: THEN
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2346: THEN
2347: pa_interface_utils_pub.map_new_amg_msg

Line 2347: pa_interface_utils_pub.map_new_amg_msg

2343: OR l_task_rec.labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2344: THEN
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2346: THEN
2347: pa_interface_utils_pub.map_new_amg_msg
2348: ( p_old_message_code => 'PA_LBR_ORG_ID_REQD'
2349: ,p_msg_attribute => 'CHANGE'
2350: ,p_resize_flag => 'N'
2351: ,p_msg_context => 'GENERAL'

Line 2369: pa_interface_utils_pub.map_new_amg_msg

2365: THEN
2366: CLOSE l_labor_bill_rate_org_csr;
2367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2368: THEN
2369: pa_interface_utils_pub.map_new_amg_msg
2370: ( p_old_message_code => 'PA_LBR_ORG_ID_INVALID'
2371: ,p_msg_attribute => 'CHANGE'
2372: ,p_resize_flag => 'N'
2373: ,p_msg_context => 'GENERAL'

Line 2387: AND l_task_rec.labor_std_bill_rate_schdl <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

2383: CLOSE l_labor_bill_rate_org_csr;
2384: END IF;
2385:
2386: IF (l_task_rec.labor_std_bill_rate_schdl IS NOT NULL
2387: AND l_task_rec.labor_std_bill_rate_schdl <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
2388: THEN
2389: OPEN l_labor_brs_csr (l_task_rec.labor_bill_rate_org_id,
2390: l_task_rec.labor_std_bill_rate_schdl );
2391: FETCH l_labor_brs_csr INTO l_dummy;

Line 2398: pa_interface_utils_pub.map_new_amg_msg

2394: THEN
2395: CLOSE l_labor_brs_csr;
2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2397: THEN
2398: pa_interface_utils_pub.map_new_amg_msg
2399: ( p_old_message_code => 'PA_LBR_BRS_INVALID'
2400: ,p_msg_attribute => 'CHANGE'
2401: ,p_resize_flag => 'N'
2402: ,p_msg_context => 'GENERAL'

Line 2427: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2423: THEN
2424: IF PA_INSTALL.IS_PRM_LICENSED = 'Y'
2425: THEN
2426: IF (l_task_rec.job_bill_rate_schedule_id IS NULL
2427: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2428: THEN
2429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2430: THEN
2431: pa_interface_utils_pub.map_new_amg_msg

Line 2431: pa_interface_utils_pub.map_new_amg_msg

2427: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2428: THEN
2429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2430: THEN
2431: pa_interface_utils_pub.map_new_amg_msg
2432: ( p_old_message_code => 'PA_JOB_SCH_ID_NOT_NULL'
2433: ,p_msg_attribute => 'CHANGE'
2434: ,p_resize_flag => 'N'
2435: ,p_msg_context => 'GENERAL'

Line 2446: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND

2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: ELSE
2445: IF (l_task_rec.job_bill_rate_schedule_id IS NULL
2446: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
2447: (l_task_rec.emp_bill_rate_schedule_id IS NULL
2448: OR l_task_rec.emp_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2449: THEN
2450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2448: OR l_task_rec.emp_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2444: ELSE
2445: IF (l_task_rec.job_bill_rate_schedule_id IS NULL
2446: OR l_task_rec.job_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
2447: (l_task_rec.emp_bill_rate_schedule_id IS NULL
2448: OR l_task_rec.emp_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2449: THEN
2450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2451: THEN
2452: pa_interface_utils_pub.map_new_amg_msg

Line 2452: pa_interface_utils_pub.map_new_amg_msg

2448: OR l_task_rec.emp_bill_rate_schedule_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2449: THEN
2450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2451: THEN
2452: pa_interface_utils_pub.map_new_amg_msg
2453: ( p_old_message_code => 'PA_EJ_BILL_RT_SCH_NOT_NULL'
2454: ,p_msg_attribute => 'CHANGE'
2455: ,p_resize_flag => 'N'
2456: ,p_msg_context => 'GENERAL'

Line 2467: AND l_task_rec.job_bill_rate_schedule_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2463: RAISE FND_API.G_EXC_ERROR;
2464: END IF;
2465: END IF; -- end PA_INSTALL.IS_PRM_LICENSED = 'Y'
2466: IF (l_task_rec.job_bill_rate_schedule_id IS NOT NULL
2467: AND l_task_rec.job_bill_rate_schedule_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2468: THEN
2469: OPEN l_job_brs_csr (l_task_rec.job_bill_rate_schedule_id );
2470: FETCH l_job_brs_csr INTO l_dummy;
2471:

Line 2477: pa_interface_utils_pub.map_new_amg_msg

2473: THEN
2474: CLOSE l_job_brs_csr;
2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2476: THEN
2477: pa_interface_utils_pub.map_new_amg_msg
2478: ( p_old_message_code => 'PA_JOB_SCH_ID_NOT_NULL'
2479: ,p_msg_attribute => 'CHANGE'
2480: ,p_resize_flag => 'N'
2481: ,p_msg_context => 'GENERAL'

Line 2494: AND l_task_rec.emp_bill_rate_schedule_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2490: CLOSE l_job_brs_csr;
2491: END IF;
2492: END IF;
2493: IF (l_task_rec.emp_bill_rate_schedule_id IS NOT NULL
2494: AND l_task_rec.emp_bill_rate_schedule_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2495: THEN
2496: OPEN l_emp_brs_csr (l_task_rec.emp_bill_rate_schedule_id );
2497: FETCH l_emp_brs_csr INTO l_dummy;
2498:

Line 2504: pa_interface_utils_pub.map_new_amg_msg

2500: THEN
2501: CLOSE l_emp_brs_csr;
2502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2503: THEN
2504: pa_interface_utils_pub.map_new_amg_msg
2505: ( p_old_message_code => 'PA_INVALID_EMP_SCH_ID'
2506: ,p_msg_attribute => 'CHANGE'
2507: ,p_resize_flag => 'N'
2508: ,p_msg_context => 'GENERAL'

Line 2529: OR l_task_rec.non_labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2525: IF l_task_rec.non_labor_sch_type = 'B'--(I- burden schedule B-Bill rate sch)
2526: THEN
2527:
2528: IF (l_task_rec.non_labor_bill_rate_org_id IS NULL
2529: OR l_task_rec.non_labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2530: THEN
2531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2532: THEN
2533: pa_interface_utils_pub.map_new_amg_msg

Line 2533: pa_interface_utils_pub.map_new_amg_msg

2529: OR l_task_rec.non_labor_bill_rate_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2530: THEN
2531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2532: THEN
2533: pa_interface_utils_pub.map_new_amg_msg
2534: ( p_old_message_code => 'PA_NON_LBR_ORG_ID_REQD'
2535: ,p_msg_attribute => 'CHANGE'
2536: ,p_resize_flag => 'N'
2537: ,p_msg_context => 'GENERAL'

Line 2556: pa_interface_utils_pub.map_new_amg_msg

2552: THEN
2553: CLOSE l_non_labor_bill_rate_org_csr;
2554: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2555: THEN
2556: pa_interface_utils_pub.map_new_amg_msg
2557: ( p_old_message_code => 'PA_NON_LBR_ORG_ID_INVALID'
2558: ,p_msg_attribute => 'CHANGE'
2559: ,p_resize_flag => 'N'
2560: ,p_msg_context => 'GENERAL'

Line 2574: AND l_task_rec.non_labor_std_bill_rate_schdl <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

2570: CLOSE l_non_labor_bill_rate_org_csr;
2571: END IF;
2572:
2573: IF (l_task_rec.non_labor_std_bill_rate_schdl IS NOT NULL
2574: AND l_task_rec.non_labor_std_bill_rate_schdl <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
2575: THEN
2576:
2577: OPEN l_non_labor_brs_csr (l_task_rec.non_labor_bill_rate_org_id,
2578: l_task_rec.non_labor_std_bill_rate_schdl );

Line 2586: pa_interface_utils_pub.map_new_amg_msg

2582: THEN
2583: CLOSE l_non_labor_brs_csr;
2584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2585: THEN
2586: pa_interface_utils_pub.map_new_amg_msg
2587: ( p_old_message_code => 'PA_NON_LBR_BRS_INVALID'
2588: ,p_msg_attribute => 'CHANGE'
2589: ,p_resize_flag => 'N'
2590: ,p_msg_context => 'GENERAL'

Line 2665: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2661: BEGIN
2662:
2663: p_return_status := FND_API.G_RET_STS_SUCCESS;
2664:
2665: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2666: AND p_new_start_date IS NOT NULL --redundant, but added for clarity
2667: THEN
2668: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2669: THEN

Line 2668: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

2664:
2665: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2666: AND p_new_start_date IS NOT NULL --redundant, but added for clarity
2667: THEN
2668: IF p_new_start_date <> NVL(p_old_start_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2669: THEN
2670: p_update_start_date_flag := 'Y';
2671: l_start_date := p_new_start_date;
2672: ELSE

Line 2677: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2673: p_update_start_date_flag := 'N';
2674: l_start_date := p_new_start_date;
2675: END IF;
2676:
2677: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2678: AND p_new_end_date IS NOT NULL --redundant, but added for clarity
2679: THEN
2680: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2681: THEN

Line 2680: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

2676:
2677: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2678: AND p_new_end_date IS NOT NULL --redundant, but added for clarity
2679: THEN
2680: IF p_new_end_date <> NVL(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2681: THEN
2682: p_update_end_date_flag := 'Y';
2683: l_end_date := p_new_end_date;
2684: ELSE

Line 2694: pa_interface_utils_pub.map_new_amg_msg

2690: THEN
2691: IF FND_MSG_PUB.check_msg_level
2692: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2693: THEN
2694: pa_interface_utils_pub.map_new_amg_msg
2695: ( p_old_message_code => 'PA_INVALID_START_DATE'
2696: ,p_msg_attribute => 'CHANGE'
2697: ,p_resize_flag => 'N'
2698: ,p_msg_context => 'GENERAL'

Line 2728: pa_interface_utils_pub.map_new_amg_msg

2724:
2725: IF l_start_date > p_old_end_date THEN
2726: IF FND_MSG_PUB.check_msg_level
2727: (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2728: pa_interface_utils_pub.map_new_amg_msg
2729: ( p_old_message_code => 'PA_INVALID_START_DATE'
2730: ,p_msg_attribute => 'CHANGE'
2731: ,p_resize_flag => 'N'
2732: ,p_msg_context => 'GENERAL'

Line 2753: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2749: ELSE
2750: p_update_start_date_flag := 'N';
2751: END IF;
2752:
2753: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2754: AND p_new_end_date IS NOT NULL
2755: THEN
2756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2757: THEN

Line 2758: pa_interface_utils_pub.map_new_amg_msg

2754: AND p_new_end_date IS NOT NULL
2755: THEN
2756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2757: THEN
2758: pa_interface_utils_pub.map_new_amg_msg
2759: ( p_old_message_code => 'PA_DATES_INVALID_3'
2760: ,p_msg_attribute => 'CHANGE'
2761: ,p_resize_flag => 'N'
2762: ,p_msg_context => 'GENERAL'

Line 2788: pa_interface_utils_pub.map_new_amg_msg

2784: IF p_old_end_date IS NOT NULL --start_date is null
2785: THEN
2786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2787: THEN
2788: pa_interface_utils_pub.map_new_amg_msg
2789: ( p_old_message_code => 'PA_DATES_INVALID_3'
2790: ,p_msg_attribute => 'CHANGE'
2791: ,p_resize_flag => 'N'
2792: ,p_msg_context => 'GENERAL'

Line 2808: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

2804: ELSE --p_new_start_date was not passed
2805:
2806: p_update_start_date_flag := 'N';
2807:
2808: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2809: AND p_new_end_date IS NOT NULL
2810: THEN
2811: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2812: THEN

Line 2811: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

2807:
2808: IF p_new_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2809: AND p_new_end_date IS NOT NULL
2810: THEN
2811: IF p_new_end_date <> nvl(p_old_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
2812: THEN
2813: p_update_end_date_flag := 'Y';
2814:
2815: IF p_old_start_date IS NULL

Line 2820: pa_interface_utils_pub.map_new_amg_msg

2816: OR p_old_start_date > p_new_end_date
2817: THEN
2818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2819: THEN
2820: pa_interface_utils_pub.map_new_amg_msg
2821: ( p_old_message_code => 'PA_INVALID_START_DATE'
2822: ,p_msg_attribute => 'CHANGE'
2823: ,p_resize_flag => 'N'
2824: ,p_msg_context => 'GENERAL'

Line 2934: AND nvl(end_date_active,nvl(p_start_date,sysdate)) between nvl(p_start_date,sysdate) and nvl(p_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE); -- Added for Bug 5183218

2930: FROM pa_project_players
2931: WHERE project_id = p_project_id
2932: AND project_role_type = 'PROJECT MANAGER'
2933: -- AND nvl(end_date_active,nvl(p_start_date,sysdate)) between nvl(p_start_date,sysdate) and nvl(p_end_date,sysdate);
2934: AND nvl(end_date_active,nvl(p_start_date,sysdate)) between nvl(p_start_date,sysdate) and nvl(p_end_date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE); -- Added for Bug 5183218
2935:
2936: l_wf_type VARCHAR2(250);
2937: l_wf_item_type VARCHAR2(250);
2938: l_wf_process VARCHAR2(250);

Line 3025: pa_interface_utils_pub.map_new_amg_msg

3021: -- Bug 4300015
3022: If l_current_project_man_rec.start_date_active < nvl(p_end_date,sysdate)
3023: THEN
3024:
3025: pa_interface_utils_pub.map_new_amg_msg
3026: ( p_old_message_code => 'PA_PR_TOO_MANY_MGRS'
3027: ,p_msg_attribute => 'CHANGE'
3028: ,p_resize_flag => 'N'
3029: ,p_msg_context => 'PROJ'

Line 3058: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

3054: ELSE
3055: UPDATE pa_project_players
3056: SET end_date_active =
3057: Decode( nvl(p_start_date,
3058: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
3059: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
3060: SYSDATE-1,p_start_date-1)
3061: WHERE project_id = p_project_id
3062: AND person_id =

Line 3059: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

3055: UPDATE pa_project_players
3056: SET end_date_active =
3057: Decode( nvl(p_start_date,
3058: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
3059: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
3060: SYSDATE-1,p_start_date-1)
3061: WHERE project_id = p_project_id
3062: AND person_id =
3063: l_current_project_man_rec.person_id

Line 3074: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

3070: THEN
3071: v_end_date := p_key_members(i).end_date;
3072: ELSE
3073: Select Decode( nvl(p_start_date,
3074: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
3075: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
3076: SYSDATE-1,p_start_date-1)
3077: Into v_end_date
3078: From dual;

Line 3075: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

3071: v_end_date := p_key_members(i).end_date;
3072: ELSE
3073: Select Decode( nvl(p_start_date,
3074: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
3075: ,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
3076: SYSDATE-1,p_start_date-1)
3077: Into v_end_date
3078: From dual;
3079: END IF;

Line 3126: p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) THEN

3122: END IF;
3123: END LOOP;
3124: IF l_current_manager_updated = 'N' THEN
3125: IF ( p_start_date IS NULL OR
3126: p_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) THEN
3127: l_new_end_date := SYSDATE - 1;
3128: ELSE
3129: l_new_end_date := p_start_date - 1;
3130: END IF;

Line 3287: IF p_in_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR

3283: p_proceed_with_update_flag := 'Y';
3284:
3285: -- check whether task number is changing
3286:
3287: IF p_in_task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
3288: p_in_task_number IS NULL THEN
3289: p_proceed_with_update_flag := 'Y';
3290: RETURN;
3291: END IF;

Line 3354: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

3350: -- It is getting changed to 2.3. There is already a task
3351: -- in the database with task number = 2.3. Unless, this
3352: -- is getting changed to something else, we cannot update
3353: -- 2.1 to 2.3
3354: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
3355: (p_task_number=> p_in_task_tbl(i).task_name
3356: ,p_task_reference => p_in_task_tbl(i).pm_task_reference
3357: ,p_task_id => l_task_id);
3358:

Line 3361: pa_interface_utils_pub.map_new_amg_msg

3357: ,p_task_id => l_task_id);
3358:
3359: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3360: THEN
3361: pa_interface_utils_pub.map_new_amg_msg
3362: ( p_old_message_code => 'PA_TASK_NUMBER_NOT_UNIQUE'
3363: ,p_msg_attribute => 'CHANGE'
3364: ,p_resize_flag => 'N'
3365: ,p_msg_context => 'TASK'

Line 3388: SET task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ||

3384: G_task_num_updated_index_tbl(l_count).task_id
3385: := p_task_id;
3386: -- Now update the processing task number to a temporary value
3387: UPDATE pa_tasks
3388: SET task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ||
3389: TO_CHAR(G_index_counter)
3390: WHERE task_id = p_task_id;
3391: p_proceed_with_update_flag := 'N';
3392: EXIT;

Line 3512: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

3508: OPEN l_amg_task_csr( l_get_tasks_rec.task_id );
3509: FETCH l_amg_task_csr INTO l_amg_task_number;
3510: CLOSE l_amg_task_csr;
3511: */
3512: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
3513: (p_task_number=> l_get_tasks_rec.task_name
3514: ,p_task_reference => l_get_tasks_rec.pm_task_reference
3515: ,p_task_id => l_get_tasks_rec.task_id);
3516:

Line 3525: pa_interface_utils_pub.map_new_amg_msg

3521: l_parent_start_date,
3522: l_parent_completion_date;
3523: IF l_get_parent_dates_csr%NOTFOUND THEN
3524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3525: pa_interface_utils_pub.map_new_amg_msg
3526: ( p_old_message_code => 'PA_PARENT_TASK_MISSING'
3527: ,p_msg_attribute => 'CHANGE'
3528: ,p_resize_flag => 'N'
3529: ,p_msg_context => 'TASK'

Line 3544: pa_interface_utils_pub.map_new_amg_msg

3540: CLOSE l_get_parent_dates_csr;
3541: END IF;
3542: IF l_parent_start_date > l_get_tasks_rec.start_date THEN
3543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3544: pa_interface_utils_pub.map_new_amg_msg
3545: ( p_old_message_code => 'PA_PARENT_START_LATER'
3546: ,p_msg_attribute => 'CHANGE'
3547: ,p_resize_flag => 'N'
3548: ,p_msg_context => 'TASK'

Line 3562: pa_interface_utils_pub.map_new_amg_msg

3558: END IF;
3559:
3560: IF l_parent_completion_date < l_get_tasks_rec.completion_date THEN
3561: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3562: pa_interface_utils_pub.map_new_amg_msg
3563: ( p_old_message_code => 'PA_PARENT_COMPLETION_EARLIER'
3564: ,p_msg_attribute => 'CHANGE'
3565: ,p_resize_flag => 'Y'
3566: ,p_msg_context => 'TASK'

Line 3592: pa_interface_utils_pub.map_new_amg_msg

3588: IF l_get_tasks_rec.start_date > l_min_child_start_date
3589: OR
3590: l_min_child_start_date > l_get_tasks_rec.completion_date THEN
3591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3592: pa_interface_utils_pub.map_new_amg_msg
3593: ( p_old_message_code => 'PA_CHILD_START_EARLIER'
3594: ,p_msg_attribute => 'CHANGE'
3595: ,p_resize_flag => 'N'
3596: ,p_msg_context => 'TASK'

Line 3613: pa_interface_utils_pub.map_new_amg_msg

3609: OR
3610: l_max_child_completion_date < l_get_tasks_rec.start_date
3611: THEN
3612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3613: pa_interface_utils_pub.map_new_amg_msg
3614: ( p_old_message_code => 'PA_PARENT_START_LATER'
3615: ,p_msg_attribute => 'CHANGE'
3616: ,p_resize_flag => 'N'
3617: ,p_msg_context => 'TASK'