DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.INITIALIZE;

98: l_error_msg VARCHAR2(2000);
99:
100: BEGIN
101:
102: FND_MSG_PUB.INITIALIZE;
103:
104: l_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 157: fnd_msg_pub.add;

153: CLOSE get_mel_cdl_details;
154:
155: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
156: fnd_message.set_token('HRD_ID', l_object_id, false);
157: fnd_msg_pub.add;
158:
159: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
160: THEN
161: fnd_log.message

Line 444: FND_MSG_PUB.Count_And_Get

440: END IF;
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: FND_MSG_PUB.Count_And_Get
445: (
446: p_encoded => FND_API.G_FALSE,
447: p_count => l_msg_count,
448: p_data => l_msg_data

Line 570: fnd_msg_pub.add;

566: CLOSE get_mel_cdl_details;
567:
568: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
569: fnd_message.set_token('HRD_ID', l_object_id, false);
570: fnd_msg_pub.add;
571:
572: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
573: THEN
574: fnd_log.message

Line 623: FND_MSG_PUB.Count_And_Get

619: RETURN;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: FND_MSG_PUB.Count_And_Get
624: (
625: p_encoded => FND_API.G_FALSE,
626: p_count => l_msg_count,
627: p_data => l_msg_data

Line 743: fnd_msg_pub.add;

739: CLOSE get_mel_cdl_details;
740:
741: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
742: fnd_message.set_token('HRD_ID', l_object_id, false);
743: fnd_msg_pub.add;
744:
745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
746: THEN
747: fnd_log.message

Line 796: FND_MSG_PUB.Count_And_Get

792: RETURN;
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: FND_MSG_PUB.Count_And_Get
797: (
798: p_encoded => FND_API.G_FALSE,
799: p_count => l_msg_count,
800: p_data => l_msg_data

Line 908: fnd_msg_pub.add;

904: CLOSE get_mel_cdl_details;
905:
906: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
907: fnd_message.set_token('HRD_ID', l_object_id, false);
908: fnd_msg_pub.add;
909:
910: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
911: THEN
912: fnd_log.message

Line 960: FND_MSG_PUB.Count_And_Get

956: RETURN;
957:
958: EXCEPTION
959: WHEN FND_API.G_EXC_ERROR THEN
960: FND_MSG_PUB.Count_And_Get
961: (
962: p_encoded => FND_API.G_FALSE,
963: p_count => l_msg_count,
964: p_data => l_msg_data

Line 1080: fnd_msg_pub.add;

1076: CLOSE get_mel_cdl_details;
1077:
1078: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1079: fnd_message.set_token('HRD_ID', l_object_id, false);
1080: fnd_msg_pub.add;
1081:
1082: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1083: THEN
1084: fnd_log.message

Line 1133: FND_MSG_PUB.Count_And_Get

1129: RETURN;
1130:
1131: EXCEPTION
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: FND_MSG_PUB.Count_And_Get
1134: (
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => l_msg_count,
1137: p_data => l_msg_data

Line 1261: fnd_msg_pub.add;

1257: CLOSE get_mel_cdl_details;
1258:
1259: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1260: fnd_message.set_token('HRD_ID', l_object_id, false);
1261: fnd_msg_pub.add;
1262:
1263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1264: THEN
1265: fnd_log.message

Line 1315: FND_MSG_PUB.Count_And_Get

1311: RETURN;
1312:
1313: EXCEPTION
1314: WHEN FND_API.G_EXC_ERROR THEN
1315: FND_MSG_PUB.Count_And_Get
1316: (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => l_msg_count,
1319: p_data => l_msg_data

Line 1443: fnd_msg_pub.add;

1439: CLOSE get_mel_cdl_details;
1440:
1441: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1442: fnd_message.set_token('HRD_ID', l_object_id, false);
1443: fnd_msg_pub.add;
1444:
1445: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1446: THEN
1447: fnd_log.message

Line 1497: FND_MSG_PUB.Count_And_Get

1493: RETURN;
1494:
1495: EXCEPTION
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: FND_MSG_PUB.Count_And_Get
1498: (
1499: p_encoded => FND_API.G_FALSE,
1500: p_count => l_msg_count,
1501: p_data => l_msg_data

Line 1616: fnd_msg_pub.add;

1612: CLOSE get_mel_cdl_details;
1613:
1614: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1615: fnd_message.set_token('HRD_ID', l_object_id, false);
1616: fnd_msg_pub.add;
1617:
1618: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1619: THEN
1620: fnd_log.message

Line 1669: FND_MSG_PUB.Count_And_Get

1665: RETURN;
1666:
1667: EXCEPTION
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: FND_MSG_PUB.Count_And_Get
1670: (
1671: p_encoded => FND_API.G_FALSE,
1672: p_count => l_msg_count,
1673: p_data => l_msg_data

Line 1796: fnd_msg_pub.add;

1792: CLOSE get_mel_cdl_details;
1793:
1794: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
1795: fnd_message.set_token('HRD_ID', l_object_id, false);
1796: fnd_msg_pub.add;
1797:
1798: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1799: THEN
1800: fnd_log.message

Line 1892: FND_MSG_PUB.Count_And_Get

1888: END IF;
1889:
1890: EXCEPTION
1891: WHEN FND_API.G_EXC_ERROR THEN
1892: FND_MSG_PUB.Count_And_Get
1893: (
1894: p_encoded => FND_API.G_FALSE,
1895: p_count => l_msg_count,
1896: p_data => l_msg_data

Line 2006: fnd_msg_pub.add;

2002: CLOSE get_mel_cdl_details;
2003:
2004: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
2005: fnd_message.set_token('HRD_ID', l_object_id, false);
2006: fnd_msg_pub.add;
2007:
2008: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2009: THEN
2010: fnd_log.message

Line 2073: FND_MSG_PUB.Count_And_Get

2069: END IF;
2070:
2071: EXCEPTION
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: FND_MSG_PUB.Count_And_Get
2074: (
2075: p_encoded => FND_API.G_FALSE,
2076: p_count => l_msg_count,
2077: p_data => l_msg_data

Line 2206: FND_MSG_PUB.INITIALIZE;

2202: l_temp_subject VARCHAR2(4000);
2203:
2204: BEGIN
2205:
2206: FND_MSG_PUB.INITIALIZE;
2207:
2208: l_return_status := FND_API.G_RET_STS_SUCCESS;
2209:
2210: IF (l_debug_proc >= l_debug_runtime)

Line 2261: fnd_msg_pub.add;

2257: CLOSE get_nr_details_csr;
2258:
2259: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ID_INVALID');
2260: fnd_message.set_token('HDR_ID', l_object_id, false);
2261: fnd_msg_pub.add;
2262:
2263: IF (l_debug_exception >= l_debug_runtime)
2264: THEN
2265: fnd_log.message

Line 2570: FND_MSG_PUB.Count_And_Get

2566: END IF;
2567:
2568: EXCEPTION
2569: WHEN FND_API.G_EXC_ERROR THEN
2570: FND_MSG_PUB.Count_And_Get
2571: (
2572: p_encoded => FND_API.G_FALSE,
2573: p_count => l_msg_count,
2574: p_data => l_msg_data

Line 2742: FND_MSG_PUB.Count_And_Get

2738: RETURN;
2739:
2740: EXCEPTION
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: FND_MSG_PUB.Count_And_Get
2743: (
2744: p_encoded => FND_API.G_FALSE,
2745: p_count => l_msg_count,
2746: p_data => l_msg_data

Line 2908: FND_MSG_PUB.Count_And_Get

2904:
2905:
2906: EXCEPTION
2907: WHEN FND_API.G_EXC_ERROR THEN
2908: FND_MSG_PUB.Count_And_Get
2909: (
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => l_msg_count,
2912: p_data => l_msg_data

Line 3061: FND_MSG_PUB.Count_And_Get

3057: RETURN;
3058:
3059: EXCEPTION
3060: WHEN FND_API.G_EXC_ERROR THEN
3061: FND_MSG_PUB.Count_And_Get
3062: (
3063: p_encoded => FND_API.G_FALSE,
3064: p_count => l_msg_count,
3065: p_data => l_msg_data

Line 3230: FND_MSG_PUB.Count_And_Get

3226: END IF;
3227:
3228: EXCEPTION
3229: WHEN FND_API.G_EXC_ERROR THEN
3230: FND_MSG_PUB.Count_And_Get
3231: (
3232: p_encoded => FND_API.G_FALSE,
3233: p_count => l_msg_count,
3234: p_data => l_msg_data

Line 3397: FND_MSG_PUB.Count_And_Get

3393: END IF;
3394:
3395: EXCEPTION
3396: WHEN FND_API.G_EXC_ERROR THEN
3397: FND_MSG_PUB.Count_And_Get
3398: (
3399: p_encoded => FND_API.G_FALSE,
3400: p_count => l_msg_count,
3401: p_data => l_msg_data

Line 3536: fnd_msg_pub.add;

3532: THEN
3533: CLOSE get_ue_mel_cdl_details;
3534: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
3535: fnd_message.set_token('HDR_ID', l_object_id, false);
3536: fnd_msg_pub.add;
3537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3538: THEN
3539: fnd_log.message
3540: (

Line 3580: FND_MSG_PUB.Count_And_Get

3576: END IF;
3577:
3578: EXCEPTION
3579: WHEN FND_API.G_EXC_ERROR THEN
3580: FND_MSG_PUB.Count_And_Get
3581: (
3582: p_encoded => FND_API.G_FALSE,
3583: p_count => l_msg_count,
3584: p_data => l_msg_data

Line 3742: FND_MSG_PUB.Count_And_Get

3738: RETURN;
3739:
3740: EXCEPTION
3741: WHEN FND_API.G_EXC_ERROR THEN
3742: FND_MSG_PUB.Count_And_Get
3743: (
3744: p_encoded => FND_API.G_FALSE,
3745: p_count => l_msg_count,
3746: p_data => l_msg_data

Line 3933: FND_MSG_PUB.ADD;

3929: IF (ue_deferral_csr%NOTFOUND) THEN
3930: CLOSE ue_deferral_csr;
3931: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NTF_ID_INVALID');
3932: FND_MESSAGE.Set_Token('HDR_ID',l_object_id);
3933: FND_MSG_PUB.ADD;
3934: RAISE FND_API.G_EXC_ERROR;
3935: END IF;
3936: CLOSE ue_deferral_csr;
3937:

Line 3947: FND_MSG_PUB.ADD;

3943: IF (unit_effect_csr%NOTFOUND) THEN
3944: CLOSE unit_effect_csr;
3945: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_WF_UE_INVALID');
3946: FND_MESSAGE.Set_Token('UE_ID',l_deferral_rec.unit_effectivity_id);
3947: FND_MSG_PUB.ADD;
3948: RAISE FND_API.G_EXC_ERROR;
3949: END IF;
3950: CLOSE unit_effect_csr;
3951:

Line 3963: FND_MSG_PUB.ADD;

3959: -- Unit is locked, therefore cannot proceed for approval.
3960: -- and cannot login to the workorder
3961: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');
3962: FND_MESSAGE.set_token('UE_ID', l_deferral_rec.unit_effectivity_id);
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_ERROR;
3965: END IF;
3966:
3967:

Line 4029: FND_MSG_PUB.Count_And_Get (

4025: EXCEPTION
4026: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
4027: ROLLBACK TO AHL_NR_UPDATE_STATUS;
4028:
4029: FND_MSG_PUB.Count_And_Get (
4030: p_encoded => FND_API.G_FALSE,
4031: p_count => l_msg_count,
4032: p_data => l_msg_data
4033: );

Line 4205: fnd_msg_pub.add;

4201: CLOSE get_ue_mel_cdl_details;
4202:
4203: fnd_message.set_name('AHL', 'AHL_MEL_CDL_NTF_ID_INVALID');
4204: fnd_message.set_token('HDR_ID', l_object_id, false);
4205: fnd_msg_pub.add;
4206:
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN
4209: fnd_log.message

Line 4280: FND_MSG_PUB.Count_And_Get

4276: EXCEPTION
4277: WHEN FND_API.G_EXC_ERROR THEN
4278: ROLLBACK TO AHL_NR_REVERT_STATUS;
4279:
4280: FND_MSG_PUB.Count_And_Get
4281: (
4282: p_encoded => FND_API.G_FALSE,
4283: p_count => l_msg_count,
4284: p_data => l_msg_data

Line 4431: FND_MSG_PUB.Count_And_Get

4427:
4428: EXCEPTION
4429:
4430: WHEN FND_API.G_EXC_ERROR THEN
4431: FND_MSG_PUB.Count_And_Get
4432: (
4433: p_encoded => FND_API.G_FALSE,
4434: p_count => l_msg_count,
4435: p_data => l_msg_data