DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on FND_MSG_PUB

Line 565: FND_MSG_PUB.initialize;

561:
562: -- Standard call to check for call compatibility.
563: IF FND_API.to_boolean(p_init_msg_list)
564: THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567: -- Initialize API return status to success
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569:

Line 575: Fnd_Msg_Pub.ADD;

571: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
572: p_api_version,
573: l_api_name,G_PKG_NAME)
574: THEN
575: Fnd_Msg_Pub.ADD;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: --
579:

Line 588: FND_MSG_PUB.ADD;

584: L_DEBUG_KEY,
585: 'Passed Mandatory fields Org id or Display window is null');
586: END IF;
587: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');
588: FND_MSG_PUB.ADD;
589: RAISE Fnd_Api.G_EXC_ERROR;
590:
591: ELSIF(p_org_sch_search_rec.START_FROM_DATE IS NULL) AND
592: (p_org_sch_search_rec.START_BEFORE_DATE IS NULL) THEN

Line 595: Fnd_Msg_Pub.ADD;

591: ELSIF(p_org_sch_search_rec.START_FROM_DATE IS NULL) AND
592: (p_org_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
593:
594: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_DATE_MANDATORY');
595: Fnd_Msg_Pub.ADD;
596: RAISE Fnd_Api.G_EXC_ERROR;
597: END IF;
598:
599: IF (p_org_sch_search_rec.RESULT_FILTER IS NOT NULL) THEN

Line 670: l_msg_count := Fnd_Msg_Pub.count_msg;

666: END IF;
667: END LOOP;
668: CLOSE c_space_dept_for_org;
669:
670: l_msg_count := Fnd_Msg_Pub.count_msg;
671: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
672: IF (l_log_statement >= l_log_current_level) THEN
673: fnd_log.string(l_log_statement,
674: L_DEBUG_KEY,

Line 694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

690: EXCEPTION
691: WHEN Fnd_Api.G_EXC_ERROR THEN
692: x_return_status := Fnd_Api.G_RET_STS_ERROR;
693: ROLLBACK TO GET_ORG_SCH_GRAPH;
694: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => Fnd_Api.g_false);
697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

696: p_encoded => Fnd_Api.g_false);
697: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: ROLLBACK TO GET_ORG_SCH_GRAPH;
700: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
701: p_data => x_msg_data,
702: p_encoded => Fnd_Api.g_false);
703: WHEN OTHERS THEN
704: ROLLBACK TO GET_ORG_SCH_GRAPH;

Line 706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

702: p_encoded => Fnd_Api.g_false);
703: WHEN OTHERS THEN
704: ROLLBACK TO GET_ORG_SCH_GRAPH;
705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
707: THEN
708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
709: END IF;
710: Fnd_Msg_Pub.count_and_get (

Line 708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

704: ROLLBACK TO GET_ORG_SCH_GRAPH;
705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
707: THEN
708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
709: END IF;
710: Fnd_Msg_Pub.count_and_get (
711: p_encoded => Fnd_Api.g_false,
712: p_count => x_msg_count,

Line 710: Fnd_Msg_Pub.count_and_get (

706: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
707: THEN
708: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
709: END IF;
710: Fnd_Msg_Pub.count_and_get (
711: p_encoded => Fnd_Api.g_false,
712: p_count => x_msg_count,
713: p_data => x_msg_data);
714:

Line 832: FND_MSG_PUB.initialize;

828:
829: -- Standard call to check for call compatibility.
830: IF FND_API.to_boolean(p_init_msg_list)
831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834: -- Initialize API return status to success
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:

Line 842: Fnd_Msg_Pub.ADD;

838: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
839: p_api_version,
840: l_api_name,G_PKG_NAME)
841: THEN
842: Fnd_Msg_Pub.ADD;
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845: --
846:

Line 857: FND_MSG_PUB.ADD;

853: L_DEBUG_KEY,
854: 'One of the Passed Mandatory fields is null');
855: END IF;
856: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');
857: FND_MSG_PUB.ADD;
858: RAISE Fnd_Api.G_EXC_ERROR;
859: END IF;
860:
861: l_loop_window := p_org_sch_search_rec.DISPLAY_WINDOW;

Line 929: l_msg_count := Fnd_Msg_Pub.count_msg;

925: x_sch_visits_tbl := l_sch_visits_tbl;
926: x_sch_graph_rec := l_sch_graph_rec;
927:
928:
929: l_msg_count := Fnd_Msg_Pub.count_msg;
930: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
931: IF (l_log_statement >= l_log_current_level) THEN
932: fnd_log.string(l_log_statement,
933: L_DEBUG_KEY,

Line 953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

949: EXCEPTION
950: WHEN Fnd_Api.G_EXC_ERROR THEN
951: x_return_status := Fnd_Api.G_RET_STS_ERROR;
952: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
953: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => Fnd_Api.g_false);
956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

955: p_encoded => Fnd_Api.g_false);
956: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
958: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
959: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => Fnd_Api.g_false);
962: WHEN OTHERS THEN
963: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;

Line 965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

961: p_encoded => Fnd_Api.g_false);
962: WHEN OTHERS THEN
963: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
964: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
966: THEN
967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
968: END IF;
969: Fnd_Msg_Pub.count_and_get (

Line 967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

963: ROLLBACK TO GET_VISITS_FOR_DATE_ORG;
964: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
966: THEN
967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
968: END IF;
969: Fnd_Msg_Pub.count_and_get (
970: p_encoded => Fnd_Api.g_false,
971: p_count => x_msg_count,

Line 969: Fnd_Msg_Pub.count_and_get (

965: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
966: THEN
967: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
968: END IF;
969: Fnd_Msg_Pub.count_and_get (
970: p_encoded => Fnd_Api.g_false,
971: p_count => x_msg_count,
972: p_data => x_msg_data);
973:

Line 1077: FND_MSG_PUB.initialize;

1073:
1074: -- Standard call to check for call compatibility.
1075: IF FND_API.to_boolean(p_init_msg_list)
1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079: -- Initialize API return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:

Line 1087: Fnd_Msg_Pub.ADD;

1083: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1084: p_api_version,
1085: l_api_name,G_PKG_NAME)
1086: THEN
1087: Fnd_Msg_Pub.ADD;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: --
1091:

Line 1100: FND_MSG_PUB.ADD;

1096: L_DEBUG_KEY,
1097: 'Passed Mandatory fields Org id or Display window is null');
1098: END IF;
1099: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');
1100: FND_MSG_PUB.ADD;
1101: RAISE Fnd_Api.G_EXC_ERROR;
1102:
1103: ELSIF(p_flt_sch_search_rec.START_FROM_DATE IS NULL) AND
1104: (p_flt_sch_search_rec.START_BEFORE_DATE IS NULL) THEN

Line 1107: Fnd_Msg_Pub.ADD;

1103: ELSIF(p_flt_sch_search_rec.START_FROM_DATE IS NULL) AND
1104: (p_flt_sch_search_rec.START_BEFORE_DATE IS NULL) THEN
1105:
1106: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_DATE_MANDATORY');
1107: Fnd_Msg_Pub.ADD;
1108: RAISE Fnd_Api.G_EXC_ERROR;
1109: END IF;
1110:
1111: l_loop_window := p_flt_sch_search_rec.DISPLAY_WINDOW;

Line 1181: l_msg_count := Fnd_Msg_Pub.count_msg;

1177:
1178: END LOOP;
1179: CLOSE c_unit_for_flt;
1180:
1181: l_msg_count := Fnd_Msg_Pub.count_msg;
1182: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1183: IF (l_log_statement >= l_log_current_level) THEN
1184: fnd_log.string(l_log_statement,
1185: L_DEBUG_KEY,

Line 1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

1201: EXCEPTION
1202: WHEN Fnd_Api.G_EXC_ERROR THEN
1203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1204: ROLLBACK TO GET_FLT_SCH_GRAPH;
1205: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => Fnd_Api.g_false);
1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

1207: p_encoded => Fnd_Api.g_false);
1208: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1210: ROLLBACK TO GET_FLT_SCH_GRAPH;
1211: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1212: p_data => x_msg_data,
1213: p_encoded => Fnd_Api.g_false);
1214: WHEN OTHERS THEN
1215: ROLLBACK TO GET_FLT_SCH_GRAPH;

Line 1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1213: p_encoded => Fnd_Api.g_false);
1214: WHEN OTHERS THEN
1215: ROLLBACK TO GET_FLT_SCH_GRAPH;
1216: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1218: THEN
1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1220: END IF;
1221: Fnd_Msg_Pub.count_and_get (

Line 1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1215: ROLLBACK TO GET_FLT_SCH_GRAPH;
1216: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1218: THEN
1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1220: END IF;
1221: Fnd_Msg_Pub.count_and_get (
1222: p_encoded => Fnd_Api.g_false,
1223: p_count => x_msg_count,

Line 1221: Fnd_Msg_Pub.count_and_get (

1217: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1218: THEN
1219: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1220: END IF;
1221: Fnd_Msg_Pub.count_and_get (
1222: p_encoded => Fnd_Api.g_false,
1223: p_count => x_msg_count,
1224: p_data => x_msg_data);
1225:

Line 1343: FND_MSG_PUB.initialize;

1339:
1340: -- Standard call to check for call compatibility.
1341: IF FND_API.to_boolean(p_init_msg_list)
1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345: -- Initialize API return status to success
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:

Line 1353: Fnd_Msg_Pub.ADD;

1349: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1350: p_api_version,
1351: l_api_name,G_PKG_NAME)
1352: THEN
1353: Fnd_Msg_Pub.ADD;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356: --
1357:

Line 1368: FND_MSG_PUB.ADD;

1364: L_DEBUG_KEY,
1365: 'One of the Passed Mandatory fields is null');
1366: END IF;
1367: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');
1368: FND_MSG_PUB.ADD;
1369: RAISE Fnd_Api.G_EXC_ERROR;
1370: END IF;
1371:
1372: l_loop_window := p_flt_sch_search_rec.DISPLAY_WINDOW;

Line 1421: l_msg_count := Fnd_Msg_Pub.count_msg;

1417: END LOOP;
1418: x_sch_visits_tbl := l_sch_visits_tbl;
1419: x_sch_graph_rec := l_sch_graph_rec;
1420:
1421: l_msg_count := Fnd_Msg_Pub.count_msg;
1422: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1423: IF (l_log_statement >= l_log_current_level) THEN
1424: fnd_log.string(l_log_statement,
1425: L_DEBUG_KEY,

Line 1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

1441: EXCEPTION
1442: WHEN Fnd_Api.G_EXC_ERROR THEN
1443: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1444: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1445: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1446: p_data => x_msg_data,
1447: p_encoded => Fnd_Api.g_false);
1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

1447: p_encoded => Fnd_Api.g_false);
1448: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1449: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1450: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1451: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.g_false);
1454: WHEN OTHERS THEN
1455: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;

Line 1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1453: p_encoded => Fnd_Api.g_false);
1454: WHEN OTHERS THEN
1455: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1456: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1458: THEN
1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1460: END IF;
1461: Fnd_Msg_Pub.count_and_get (

Line 1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1455: ROLLBACK TO GET_VISITS_FOR_DATE_FLT;
1456: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1458: THEN
1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1460: END IF;
1461: Fnd_Msg_Pub.count_and_get (
1462: p_encoded => Fnd_Api.g_false,
1463: p_count => x_msg_count,

Line 1461: Fnd_Msg_Pub.count_and_get (

1457: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1458: THEN
1459: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1460: END IF;
1461: Fnd_Msg_Pub.count_and_get (
1462: p_encoded => Fnd_Api.g_false,
1463: p_count => x_msg_count,
1464: p_data => x_msg_data);
1465:

Line 1656: FND_MSG_PUB.ADD;

1652: p_x_sch_graph_rec.SCHEDULE_TYPE_21 := l_schedule_type;
1653: p_x_sch_graph_rec.VISIT_DATE_21 := p_graph_rec_date;
1654: p_x_sch_graph_rec.VISIT_ID_21 := l_visit_id;
1655: ELSE
1656: FND_MSG_PUB.ADD;
1657: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1658: END CASE;
1659:
1660: IF(p_filter_criteria IN (l_filter_open, l_filter_conflict)) THEN