DBA Data[Home] [Help]

APPS.PA_PROJECT_CHECK_PVT dependencies on FND_MSG_PUB

Line 107: FND_MSG_PUB.initialize;

103: END IF;
104:
105: IF FND_API.TO_BOOLEAN( p_init_msg_list )
106: THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109:
110: p_return_status := FND_API.G_RET_STS_SUCCESS;
111:

Line 210: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

206: OR p_task_version_id IS NULL ) AND
207: l_workplan_enabled = 'Y' AND
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'

Line 262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

258: IF l_structure_version_id IS NOT NULL AND
259: PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable( l_structure_version_id ) = 'N' AND
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'

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

365: IF l_return_status <> 'S' --Project Structure changes done for bug 2765115
366: THEN
367: p_delete_task_ok_flag := 'N';
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'

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

394: END IF;
395: --Project Structure changes done for bug 2765115
396: /* ELSIF l_err_code < 0
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'

Line 442: FND_MSG_PUB.Count_And_Get

438:
439: -- 4537865 : RESET OUT PARAM VALUES
440: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
441:
442: FND_MSG_PUB.Count_And_Get
443: (
444: p_encoded => 'F', -- Added for Issues found during Unit Testing 4096218
445: p_count => p_msg_count ,
446: p_data => p_msg_data );

Line 455: FND_MSG_PUB.Count_And_Get

451:
452: -- 4537865 : RESET OUT PARAM VALUES
453: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
454:
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => p_msg_count ,
457: p_data => p_msg_data );
458:
459: WHEN OTHERS

Line 466: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

462:
463: -- 4537865 : RESET OUT PARAM VALUES
464: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
465:
466: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
467: THEN
468: FND_MSG_PUB.add_exc_msg
469: ( p_pkg_name => G_PKG_NAME
470: , p_procedure_name => l_api_name );

Line 468: FND_MSG_PUB.add_exc_msg

464: p_delete_task_ok_flag := 'N' ; -- Made this value as 'N' as per logic in the API
465:
466: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
467: THEN
468: FND_MSG_PUB.add_exc_msg
469: ( p_pkg_name => G_PKG_NAME
470: , p_procedure_name => l_api_name );
471: END IF;
472: FND_MSG_PUB.Count_And_Get

Line 472: FND_MSG_PUB.Count_And_Get

468: FND_MSG_PUB.add_exc_msg
469: ( p_pkg_name => G_PKG_NAME
470: , p_procedure_name => l_api_name );
471: END IF;
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => p_msg_count ,
474: p_data => p_msg_data );
475:
476:

Line 550: FND_MSG_PUB.initialize;

546:
547:
548: IF FND_API.TO_BOOLEAN( p_init_msg_list )
549: THEN
550: FND_MSG_PUB.initialize;
551: END IF;
552:
553: p_return_status := FND_API.G_RET_STS_SUCCESS;
554:

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

612:
613: IF l_err_code > 0
614: THEN
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'

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

641: END IF;
642:
643: ELSIF l_err_code < 0
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'

Line 690: FND_MSG_PUB.Count_And_Get

686:
687: -- 4537865 RESET OUT param value
688: p_add_subtask_ok_flag := 'N' ;
689:
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => p_msg_count ,
692: p_data => p_msg_data );
693:
694:

Line 702: FND_MSG_PUB.Count_And_Get

698:
699: -- 4537865 RESET OUT param value
700: p_add_subtask_ok_flag := 'N' ;
701:
702: FND_MSG_PUB.Count_And_Get
703: ( p_count => p_msg_count ,
704: p_data => p_msg_data );
705:
706:

Line 714: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

710:
711: -- 4537865 RESET OUT param value
712: p_add_subtask_ok_flag := 'N' ;
713:
714: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.add_exc_msg
717: ( p_pkg_name => G_PKG_NAME
718: , p_procedure_name => l_api_name );

Line 716: FND_MSG_PUB.add_exc_msg

712: p_add_subtask_ok_flag := 'N' ;
713:
714: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.add_exc_msg
717: ( p_pkg_name => G_PKG_NAME
718: , p_procedure_name => l_api_name );
719: END IF;
720: FND_MSG_PUB.Count_And_Get

Line 720: FND_MSG_PUB.Count_And_Get

716: FND_MSG_PUB.add_exc_msg
717: ( p_pkg_name => G_PKG_NAME
718: , p_procedure_name => l_api_name );
719: END IF;
720: FND_MSG_PUB.Count_And_Get
721: ( p_count => p_msg_count ,
722: p_data => p_msg_data );
723:
724: END Check_Add_Subtask_Ok_pvt;

Line 791: FND_MSG_PUB.initialize;

787: END IF;
788:
789: IF FND_API.TO_BOOLEAN( p_init_msg_list )
790: THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793:
794: p_return_status := FND_API.G_RET_STS_SUCCESS;
795:

Line 834: FND_MSG_PUB.Count_And_Get

830: p_return_status := FND_API.G_RET_STS_ERROR;
831: -- 4537865 : RESET OUT param values.
832: p_unique_task_ref_flag := 'N' ;
833:
834: FND_MSG_PUB.Count_And_Get
835: ( p_count => p_msg_count ,
836: p_data => p_msg_data );
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 844: FND_MSG_PUB.Count_And_Get

840: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: -- 4537865 : RESET OUT param values.
842: p_unique_task_ref_flag := 'N' ;
843:
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => p_msg_count ,
846: p_data => p_msg_data );
847:
848: WHEN OTHERS

Line 854: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

850: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: -- 4537865 : RESET OUT param values.
852: p_unique_task_ref_flag := 'N' ;
853:
854: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: FND_MSG_PUB.add_exc_msg
857: ( p_pkg_name => G_PKG_NAME
858: , p_procedure_name => l_api_name );

Line 856: FND_MSG_PUB.add_exc_msg

852: p_unique_task_ref_flag := 'N' ;
853:
854: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: FND_MSG_PUB.add_exc_msg
857: ( p_pkg_name => G_PKG_NAME
858: , p_procedure_name => l_api_name );
859: END IF;
860:

Line 861: FND_MSG_PUB.Count_And_Get

857: ( p_pkg_name => G_PKG_NAME
858: , p_procedure_name => l_api_name );
859: END IF;
860:
861: FND_MSG_PUB.Count_And_Get
862: ( p_count => p_msg_count ,
863: p_data => p_msg_data );
864:
865:

Line 929: FND_MSG_PUB.initialize;

925: END IF;
926:
927: IF FND_API.TO_BOOLEAN( p_init_msg_list )
928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932: p_return_status := FND_API.G_RET_STS_SUCCESS;
933:

Line 956: FND_MSG_PUB.Count_And_Get

952: p_return_status := FND_API.G_RET_STS_ERROR;
953: -- 4537865 : RESET OUT param values
954: p_unique_project_ref_flag := 'N';
955:
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => p_msg_count ,
958: p_data => p_msg_data );
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 966: FND_MSG_PUB.Count_And_Get

962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: -- 4537865 : RESET OUT param values
964: p_unique_project_ref_flag := 'N';
965:
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => p_msg_count ,
968: p_data => p_msg_data );
969:
970: WHEN OTHERS

Line 976: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: -- 4537865 : RESET OUT param values
974: p_unique_project_ref_flag := 'N';
975:
976: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: FND_MSG_PUB.add_exc_msg
979: ( p_pkg_name => G_PKG_NAME
980: , p_procedure_name => l_api_name );

Line 978: FND_MSG_PUB.add_exc_msg

974: p_unique_project_ref_flag := 'N';
975:
976: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: FND_MSG_PUB.add_exc_msg
979: ( p_pkg_name => G_PKG_NAME
980: , p_procedure_name => l_api_name );
981: END IF;
982:

Line 983: FND_MSG_PUB.Count_And_Get

979: ( p_pkg_name => G_PKG_NAME
980: , p_procedure_name => l_api_name );
981: END IF;
982:
983: FND_MSG_PUB.Count_And_Get
984: ( p_count => p_msg_count ,
985: p_data => p_msg_data );
986:
987: END Check_Unique_Project_Ref_pvt;

Line 1049: FND_MSG_PUB.initialize;

1045: END IF;
1046:
1047: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1048: THEN
1049: FND_MSG_PUB.initialize;
1050: END IF;
1051:
1052: p_return_status := FND_API.G_RET_STS_SUCCESS;
1053:

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

1083:
1084: IF l_err_code > 0
1085: THEN
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'

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

1112: END IF;
1113:
1114: ELSIF l_err_code < 0
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'

Line 1160: FND_MSG_PUB.Count_And_Get

1156: p_return_status := FND_API.G_RET_STS_ERROR;
1157: -- 4537865 : RESET OUT PARAM VALUES
1158: p_delete_project_ok_flag := 'N' ;
1159:
1160: FND_MSG_PUB.Count_And_Get
1161: ( p_count => p_msg_count ,
1162: p_data => p_msg_data );
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1170: FND_MSG_PUB.Count_And_Get

1166: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: -- 4537865 : RESET OUT PARAM VALUES
1168: p_delete_project_ok_flag := 'N' ;
1169:
1170: FND_MSG_PUB.Count_And_Get
1171: ( p_count => p_msg_count ,
1172: p_data => p_msg_data );
1173:
1174: WHEN OTHERS

Line 1180: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: -- 4537865 : RESET OUT PARAM VALUES
1178: p_delete_project_ok_flag := 'N' ;
1179:
1180: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: FND_MSG_PUB.add_exc_msg
1183: ( p_pkg_name => G_PKG_NAME
1184: , p_procedure_name => l_api_name );

Line 1182: FND_MSG_PUB.add_exc_msg

1178: p_delete_project_ok_flag := 'N' ;
1179:
1180: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: FND_MSG_PUB.add_exc_msg
1183: ( p_pkg_name => G_PKG_NAME
1184: , p_procedure_name => l_api_name );
1185: END IF;
1186:

Line 1187: FND_MSG_PUB.Count_And_Get

1183: ( p_pkg_name => G_PKG_NAME
1184: , p_procedure_name => l_api_name );
1185: END IF;
1186:
1187: FND_MSG_PUB.Count_And_Get
1188: ( p_count => p_msg_count ,
1189: p_data => p_msg_data );
1190:
1191:

Line 1252: FND_MSG_PUB.initialize;

1248: END IF;
1249:
1250: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1251: THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: p_return_status := FND_API.G_RET_STS_SUCCESS;
1256:

Line 1358: FND_MSG_PUB.Count_And_Get

1354:
1355: -- 4537865
1356: p_change_parent_ok_flag := 'N' ;
1357:
1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => p_msg_count ,
1360: p_data => p_msg_data );
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1368: FND_MSG_PUB.Count_And_Get

1364: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: -- 4537865
1366: p_change_parent_ok_flag := 'N' ;
1367:
1368: FND_MSG_PUB.Count_And_Get
1369: ( p_count => p_msg_count ,
1370: p_data => p_msg_data );
1371:
1372: WHEN OTHERS

Line 1379: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1375:
1376: -- 4537865
1377: p_change_parent_ok_flag := 'N' ;
1378:
1379: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.add_exc_msg
1382: ( p_pkg_name => G_PKG_NAME
1383: , p_procedure_name => l_api_name );

Line 1381: FND_MSG_PUB.add_exc_msg

1377: p_change_parent_ok_flag := 'N' ;
1378:
1379: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1380: THEN
1381: FND_MSG_PUB.add_exc_msg
1382: ( p_pkg_name => G_PKG_NAME
1383: , p_procedure_name => l_api_name );
1384: END IF;
1385:

Line 1386: FND_MSG_PUB.Count_And_Get

1382: ( p_pkg_name => G_PKG_NAME
1383: , p_procedure_name => l_api_name );
1384: END IF;
1385:
1386: FND_MSG_PUB.Count_And_Get
1387: ( p_count => p_msg_count ,
1388: p_data => p_msg_data );
1389:
1390: END Check_Change_Parent_OK_pvt;

Line 1454: FND_MSG_PUB.initialize;

1450: END IF;
1451:
1452: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1453: THEN
1454: FND_MSG_PUB.initialize;
1455: END IF;
1456:
1457: p_return_status := FND_API.G_RET_STS_SUCCESS;
1458:

Line 1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1486:
1487: IF l_err_code > 0
1488: THEN
1489: p_change_project_org_ok_flag := 'N';
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

Line 1520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1516: END IF;
1517:
1518: ELSIF l_err_code < 0
1519: THEN
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

Line 1563: FND_MSG_PUB.Count_And_Get

1559: p_return_status := FND_API.G_RET_STS_ERROR;
1560: -- 4537865 : RESET OUT PARAM VALUES
1561: p_change_project_org_ok_flag := 'N' ;
1562:
1563: FND_MSG_PUB.Count_And_Get
1564: ( p_count => p_msg_count ,
1565: p_data => p_msg_data );
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1573: FND_MSG_PUB.Count_And_Get

1569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1570: -- 4537865 : RESET OUT PARAM VALUES
1571: p_change_project_org_ok_flag := 'N' ;
1572:
1573: FND_MSG_PUB.Count_And_Get
1574: ( p_count => p_msg_count ,
1575: p_data => p_msg_data );
1576:
1577: WHEN OTHERS

Line 1584: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1580:
1581: -- 4537865 : RESET OUT PARAM VALUES
1582: p_change_project_org_ok_flag := 'N' ;
1583:
1584: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1585: THEN
1586: FND_MSG_PUB.add_exc_msg
1587: ( p_pkg_name => G_PKG_NAME
1588: , p_procedure_name => l_api_name );

Line 1586: FND_MSG_PUB.add_exc_msg

1582: p_change_project_org_ok_flag := 'N' ;
1583:
1584: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1585: THEN
1586: FND_MSG_PUB.add_exc_msg
1587: ( p_pkg_name => G_PKG_NAME
1588: , p_procedure_name => l_api_name );
1589: END IF;
1590: FND_MSG_PUB.Count_And_Get

Line 1590: FND_MSG_PUB.Count_And_Get

1586: FND_MSG_PUB.add_exc_msg
1587: ( p_pkg_name => G_PKG_NAME
1588: , p_procedure_name => l_api_name );
1589: END IF;
1590: FND_MSG_PUB.Count_And_Get
1591: ( p_count => p_msg_count ,
1592: p_data => p_msg_data );
1593:
1594:

Line 1659: FND_MSG_PUB.initialize;

1655: END IF;
1656:
1657: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1658: THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:
1662: p_return_status := FND_API.G_RET_STS_SUCCESS;
1663:

Line 1702: FND_MSG_PUB.Count_And_Get

1698: p_return_status := FND_API.G_RET_STS_ERROR;
1699: -- 4537865 : RESET OUT PARAM VALUES
1700: p_unique_task_number_flag := 'N';
1701:
1702: FND_MSG_PUB.Count_And_Get
1703: ( p_count => p_msg_count ,
1704: p_data => p_msg_data );
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1712: FND_MSG_PUB.Count_And_Get

1708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1709: -- 4537865 : RESET OUT PARAM VALUES
1710: p_unique_task_number_flag := 'N';
1711:
1712: FND_MSG_PUB.Count_And_Get
1713: ( p_count => p_msg_count ,
1714: p_data => p_msg_data );
1715:
1716: WHEN OTHERS

Line 1722: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1718: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: -- 4537865 : RESET OUT PARAM VALUES
1720: p_unique_task_number_flag := 'N';
1721:
1722: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: FND_MSG_PUB.add_exc_msg
1725: ( p_pkg_name => G_PKG_NAME
1726: , p_procedure_name => l_api_name );

Line 1724: FND_MSG_PUB.add_exc_msg

1720: p_unique_task_number_flag := 'N';
1721:
1722: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: FND_MSG_PUB.add_exc_msg
1725: ( p_pkg_name => G_PKG_NAME
1726: , p_procedure_name => l_api_name );
1727: END IF;
1728:

Line 1729: FND_MSG_PUB.Count_And_Get

1725: ( p_pkg_name => G_PKG_NAME
1726: , p_procedure_name => l_api_name );
1727: END IF;
1728:
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_count => p_msg_count ,
1731: p_data => p_msg_data );
1732:
1733: END Check_Unique_Task_Number_pvt;

Line 1807: FND_MSG_PUB.initialize;

1803: END IF;
1804:
1805: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1806: THEN
1807: FND_MSG_PUB.initialize;
1808: END IF;
1809:
1810: p_return_status := FND_API.G_RET_STS_SUCCESS;
1811:

Line 1869: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1865:
1866: IF l_err_code > 0
1867: THEN
1868: p_task_number_change_Ok_flag := 'N';
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

Line 1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1896:
1897: ELSIF l_err_code < 0
1898: THEN
1899:
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

Line 1944: FND_MSG_PUB.Count_And_Get

1940: p_return_status := FND_API.G_RET_STS_ERROR;
1941: -- 4537865 : RESET OUT PARAM VALUES
1942: p_task_number_change_Ok_flag := 'N' ;
1943:
1944: FND_MSG_PUB.Count_And_Get
1945: ( p_count => p_msg_count ,
1946: p_data => p_msg_data );
1947:
1948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1954: FND_MSG_PUB.Count_And_Get

1950: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1951: -- 4537865 : RESET OUT PARAM VALUES
1952: p_task_number_change_Ok_flag := 'N' ;
1953:
1954: FND_MSG_PUB.Count_And_Get
1955: ( p_count => p_msg_count ,
1956: p_data => p_msg_data );
1957:
1958: WHEN OTHERS

Line 1964: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961: -- 4537865 : RESET OUT PARAM VALUES
1962: p_task_number_change_Ok_flag := 'N' ;
1963:
1964: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1965: FND_MSG_PUB.add_exc_msg
1966: ( p_pkg_name => G_PKG_NAME
1967: , p_procedure_name => l_api_name );
1968: END IF;

Line 1965: FND_MSG_PUB.add_exc_msg

1961: -- 4537865 : RESET OUT PARAM VALUES
1962: p_task_number_change_Ok_flag := 'N' ;
1963:
1964: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1965: FND_MSG_PUB.add_exc_msg
1966: ( p_pkg_name => G_PKG_NAME
1967: , p_procedure_name => l_api_name );
1968: END IF;
1969:

Line 1970: FND_MSG_PUB.Count_And_Get

1966: ( p_pkg_name => G_PKG_NAME
1967: , p_procedure_name => l_api_name );
1968: END IF;
1969:
1970: FND_MSG_PUB.Count_And_Get
1971: ( p_count => p_msg_count ,
1972: p_data => p_msg_data );
1973:
1974: END Check_Task_Numb_Change_Ok_Pvt;

Line 2161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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)
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'

Line 2181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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)
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'

Line 2202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2205: ( p_old_message_code => 'PA_LBR_ORG_ID_NOT_VALID'
2206: ,p_msg_attribute => 'CHANGE'

Line 2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2226: ( p_old_message_code => 'PA_NON_LBR_ORG_ID_NOT_VALID'
2227: ,p_msg_attribute => 'CHANGE'

Line 2249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
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'

Line 2269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
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'

Line 2293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2289: IF l_burden_sch_csr%NOTFOUND
2290: THEN
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'

Line 2318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2314:
2315: IF l_burden_sch_csr%NOTFOUND
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'

Line 2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2348: ( p_old_message_code => 'PA_LBR_ORG_ID_REQD'
2349: ,p_msg_attribute => 'CHANGE'

Line 2367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2363:
2364: IF l_labor_bill_rate_org_csr%NOTFOUND
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'

Line 2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2392:
2393: IF l_labor_brs_csr%NOTFOUND
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'

Line 2429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2432: ( p_old_message_code => 'PA_JOB_SCH_ID_NOT_NULL'
2433: ,p_msg_attribute => 'CHANGE'

Line 2450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2453: ( p_old_message_code => 'PA_EJ_BILL_RT_SCH_NOT_NULL'
2454: ,p_msg_attribute => 'CHANGE'

Line 2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2471:
2472: IF l_job_brs_csr%NOTFOUND
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'

Line 2502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2498:
2499: IF l_emp_brs_csr%NOTFOUND
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'

Line 2531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2534: ( p_old_message_code => 'PA_NON_LBR_ORG_ID_REQD'
2535: ,p_msg_attribute => 'CHANGE'

Line 2554: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2550:
2551: IF l_non_labor_bill_rate_org_csr%NOTFOUND
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'

Line 2584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2580:
2581: IF l_non_labor_brs_csr%NOTFOUND
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'

Line 2619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2615:
2616: WHEN OTHERS THEN
2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618:
2619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2620: THEN
2621: FND_MSG_PUB.add_exc_msg
2622: ( p_pkg_name => G_PKG_NAME
2623: , p_procedure_name => l_api_name );

Line 2621: FND_MSG_PUB.add_exc_msg

2617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2618:
2619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2620: THEN
2621: FND_MSG_PUB.add_exc_msg
2622: ( p_pkg_name => G_PKG_NAME
2623: , p_procedure_name => l_api_name );
2624:
2625: END IF;

Line 2691: IF FND_MSG_PUB.check_msg_level

2687: END IF;
2688:
2689: IF l_start_date > l_end_date
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'

Line 2692: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2688:
2689: IF l_start_date > l_end_date
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'

Line 2726: IF FND_MSG_PUB.check_msg_level

2722: NULL;
2723: ELSE
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'

Line 2727: (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2723: ELSE
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'

Line 2756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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
2758: pa_interface_utils_pub.map_new_amg_msg
2759: ( p_old_message_code => 'PA_DATES_INVALID_3'
2760: ,p_msg_attribute => 'CHANGE'

Line 2786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2782: p_update_end_date_flag := 'N';
2783:
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'

Line 2818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2814:
2815: IF p_old_start_date IS NULL
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'

Line 2882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2878: -- 4537865
2879: p_update_end_date_flag := NULL ;
2880: p_update_start_date_flag := NULL ;
2881:
2882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2883: THEN
2884: FND_MSG_PUB.add_exc_msg
2885: ( p_pkg_name => G_PKG_NAME
2886: , p_procedure_name => l_api_name );

Line 2884: FND_MSG_PUB.add_exc_msg

2880: p_update_start_date_flag := NULL ;
2881:
2882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2883: THEN
2884: FND_MSG_PUB.add_exc_msg
2885: ( p_pkg_name => G_PKG_NAME
2886: , p_procedure_name => l_api_name );
2887:
2888: END IF;

Line 3226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3222: WHEN OTHERS THEN
3223:
3224: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225:
3226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3227: THEN
3228: FND_MSG_PUB.add_exc_msg
3229: ( p_pkg_name => G_PKG_NAME
3230: , p_procedure_name => 'check_for_one_manager_Pvt');

Line 3228: FND_MSG_PUB.add_exc_msg

3224: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225:
3226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3227: THEN
3228: FND_MSG_PUB.add_exc_msg
3229: ( p_pkg_name => G_PKG_NAME
3230: , p_procedure_name => 'check_for_one_manager_Pvt');
3231:
3232: END IF;

Line 3359: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

Line 3424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3420: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3421: -- 4537865
3422: p_proceed_with_update_flag := 'N';
3423:
3424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3425: THEN
3426: FND_MSG_PUB.add_exc_msg
3427: ( p_pkg_name => G_PKG_NAME
3428: , p_procedure_name =>

Line 3426: FND_MSG_PUB.add_exc_msg

3422: p_proceed_with_update_flag := 'N';
3423:
3424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3425: THEN
3426: FND_MSG_PUB.add_exc_msg
3427: ( p_pkg_name => G_PKG_NAME
3428: , p_procedure_name =>
3429: 'handle_task_number_change' );
3430:

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

3520: FETCH l_get_parent_dates_csr INTO
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'

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

3539: ELSE
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'

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

3557: -- RAISE FND_API.G_EXC_ERROR;
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'

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

3587: IF l_min_child_start_date IS NOT NULL THEN
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'

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

3608: IF l_get_tasks_rec.completion_date < l_max_child_completion_date
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'

Line 3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3658: END IF;
3659:
3660: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3661:
3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3663: THEN
3664: FND_MSG_PUB.add_exc_msg
3665: ( p_pkg_name => G_PKG_NAME
3666: , p_procedure_name =>

Line 3664: FND_MSG_PUB.add_exc_msg

3660: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3661:
3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3663: THEN
3664: FND_MSG_PUB.add_exc_msg
3665: ( p_pkg_name => G_PKG_NAME
3666: , p_procedure_name =>
3667: 'check_parent_child_task_dates' );
3668:

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

3696:
3697: --dbms_output.put_line('Value of l_error_occured'||l_error_occured);
3698: IF l_error_occured = 'PA_PR_NO_MGR_DATE_RANGE' THEN
3699:
3700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3701:
3702: pa_utils.add_message
3703: ( p_app_short_name => 'PA'
3704: ,p_msg_name => 'PA_PR_NO_MGR_DATE_RANGE'

Line 3724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3720:
3721: WHEN OTHERS THEN
3722: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3723:
3724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3725: THEN
3726: FND_MSG_PUB.add_exc_msg
3727: ( p_pkg_name => G_PKG_NAME
3728: , p_procedure_name => 'check_manager_date_range' );

Line 3726: FND_MSG_PUB.add_exc_msg

3722: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3723:
3724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3725: THEN
3726: FND_MSG_PUB.add_exc_msg
3727: ( p_pkg_name => G_PKG_NAME
3728: , p_procedure_name => 'check_manager_date_range' );
3729:
3730: END IF;