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.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.add;

88:
89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
90: p_mr_header_id IS NULL ) THEN
91: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: IF G_DEBUG = 'Y' THEN
96: AHL_DEBUG_PUB.debug('MR_HEADER_ID is null to validate_api_inputs' );

Line 104: FND_MSG_PUB.ADD;

100:
101: IF G_APPLN_USAGE IS NULL
102: THEN
103: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
104: FND_MSG_PUB.ADD;
105: IF G_DEBUG = 'Y' THEN
106: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
107: END IF;
108: END IF;

Line 120: FND_MSG_PUB.add;

116: --check if mr is terminated and get the mr status.
117: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
118: IF l_mr_status_code IS NULL THEN
119: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: RETURN;
123: END IF;
124:

Line 150: FND_MSG_PUB.add;

146:
147: IF l_error_code is not null THEN
148: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);
149: FND_MESSAGE.set_name( 'AHL', l_error_code );
150: FND_MSG_PUB.add;
151: RETURN;
152: END IF;
153:
154:

Line 161: FND_MSG_PUB.add;

157: -- Check if atleast one record is passed in p_effectivity_tbl
158: IF ( p_effectivity_tbl.count < 1 ) THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
160: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
161: FND_MSG_PUB.add;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: RETURN;
164: END IF;
165:

Line 175: FND_MSG_PUB.add;

171: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
175: FND_MSG_PUB.add;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;
178:
179: IF ( l_pm_install_flag = 'Y' AND

Line 193: FND_MSG_PUB.add;

189: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
190: );
191: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
192: FND_MESSAGE.set_name( 'AHL', l_error_code );
193: FND_MSG_PUB.add;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: RETURN;
196: END IF;
197: END IF;

Line 215: FND_MSG_PUB.add;

211: );
212:
213: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
214: FND_MESSAGE.set_name( 'AHL', l_error_code );
215: FND_MSG_PUB.add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RETURN;
218: END IF;
219: END IF;

Line 228: FND_MSG_PUB.add;

224: p_super_user ='Y' AND
225: l_mr_status_code = 'COMPLETE') THEN
226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
228: FND_MSG_PUB.add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RETURN;
231: END IF;
232:

Line 244: FND_MSG_PUB.add;

240: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
244: FND_MSG_PUB.add;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247:
248: IF ( ( p_effectivity_tbl(i).position_inventory_item_id IS NOT NULL AND

Line 254: FND_MSG_PUB.add;

250: ( p_effectivity_tbl(i).position_item_number IS NOT NULL AND
251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
254: FND_MSG_PUB.add;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257:
258: IF ( ( p_effectivity_tbl(i).pc_node_id IS NOT NULL AND

Line 264: FND_MSG_PUB.add;

260: ( p_effectivity_tbl(i).pc_node_name IS NOT NULL AND
261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
264: FND_MSG_PUB.add;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;
267:
268: END IF;

Line 355: FND_MSG_PUB.add;

351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
352: END IF;
353:
354: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
355: FND_MSG_PUB.add;
356: END IF;
357:
358: END IF;
359:

Line 386: FND_MSG_PUB.add;

382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
383: END IF;
384:
385: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
386: FND_MSG_PUB.add;
387: END IF;
388:
389: END IF;
390:

Line 418: FND_MSG_PUB.add;

414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
415: END IF;
416:
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
418: FND_MSG_PUB.add;
419: END IF;
420:
421: END IF;
422:

Line 448: FND_MSG_PUB.add;

444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
445: END IF;
446:
447: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
448: FND_MSG_PUB.add;
449: END IF;
450:
451: END IF;
452:

Line 479: FND_MSG_PUB.add;

475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );
476: END IF;
477:
478: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
479: FND_MSG_PUB.add;
480: END IF;
481:
482: END IF;
483:

Line 702: FND_MSG_PUB.add;

698:
699: IF get_old_rec%NOTFOUND THEN
700: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
701: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
702: FND_MSG_PUB.add;
703: CLOSE get_old_rec;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706:

Line 890: FND_MSG_PUB.add;

886: IF ( p_effectivity_rec.name IS NULL OR
887: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
888: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
889: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
890: FND_MSG_PUB.add;
891: END IF;
892: RETURN;
893: END IF;
894:

Line 900: FND_MSG_PUB.add;

896: -- Check if the Effectivity Name column does not contains a null value.
897: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
898: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
899: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
900: FND_MSG_PUB.add;
901: END IF;
902: END IF;
903:
904: -- Check if the mandatory Effectivity ID column contains a null value.

Line 909: FND_MSG_PUB.add;

905: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
906: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
907: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
908: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
909: FND_MSG_PUB.add;
910: RETURN;
911: END IF;
912:
913: -- Check if the mandatory Object Version Number column contains a null value.

Line 918: FND_MSG_PUB.add;

914: IF ( p_effectivity_rec.object_version_number IS NULL OR
915: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
916: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
917: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
918: FND_MSG_PUB.add;
919: RETURN;
920: END IF;
921:
922: END validate_attributes;

Line 997: FND_MSG_PUB.add;

993: IF ( p_effectivity_rec.inventory_item_id IS NULL AND
994: p_effectivity_rec.item_number IS NULL ) THEN
995: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );
996: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
997: FND_MSG_PUB.add;
998: END IF;
999:
1000: ELSE
1001:

Line 1018: FND_MSG_PUB.add;

1014: nvl(l_prog_type, 'X') <> 'MO_PROC') THEN
1015: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ITEM_POS_NULL' );
1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1018: FND_MSG_PUB.add;
1019: END IF;
1020:
1021: -- Check if Master Configuration Item contains a value but, the Position is NULL
1022: IF ( p_effectivity_rec.relationship_id IS NULL AND

Line 1028: FND_MSG_PUB.add;

1024: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1025: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1026: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );
1027: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1028: FND_MSG_PUB.add;
1029: END IF;
1030:
1031: -- Check if both Item and Master Configuration Position contain values
1032: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR

Line 1038: FND_MSG_PUB.add;

1034: ( p_effectivity_rec.relationship_id IS NOT NULL OR
1035: p_effectivity_rec.position_ref_meaning IS NOT NULL ) ) THEN
1036: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );
1037: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1038: FND_MSG_PUB.add;
1039: END IF;
1040:
1041: -- Check if both Item and Master Configuration Item contain values
1042: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR

Line 1048: FND_MSG_PUB.add;

1044: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1045: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1046: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );
1047: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1048: FND_MSG_PUB.add;
1049: END IF;
1050:
1051: -- sansatpa - Check if both Item and MC position are null and fleet contains value
1052: /*IF ( ( (p_effectivity_rec.inventory_item_id IS NULL OR

Line 1060: FND_MSG_PUB.add;

1056: ( p_effectivity_rec.FLEET_HEADER_ID IS NOT NULL OR
1057: p_effectivity_rec.FLEET_NAME IS NOT NULL )) THEN
1058: FND_MESSAGE.set_name( 'AHL','AHL_FMP_FLEET_REQ_ITEM_OR_PC' );
1059: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1060: FND_MSG_PUB.add;
1061: END IF;*/
1062:
1063: -- Check if the given Item can be installed in the given Master Configuration Position
1064: IF ( p_effectivity_rec.relationship_id IS NOT NULL AND

Line 1093: FND_MSG_PUB.add;

1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1090: END IF;
1091:
1092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1093: FND_MSG_PUB.add;
1094: END IF; */
1095:
1096: --pdoki added for Bug 6719371
1097: OPEN check_alternate( p_effectivity_rec.relationship_id , p_effectivity_rec.position_inventory_item_id );

Line 1121: FND_MSG_PUB.add;

1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1118: END IF;
1119:
1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1121: FND_MSG_PUB.add;
1122: END IF;
1123: CLOSE check_alternate;
1124: END IF;
1125:

Line 1165: FND_MSG_PUB.add;

1161:
1162: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1163: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: END IF;
1169:

Line 1215: FND_MSG_PUB.add;

1211:
1212: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1213: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1214: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1215: FND_MSG_PUB.add;
1216: END IF;
1217:
1218: END IF;
1219:

Line 1281: FND_MSG_PUB.add;

1277: EXIT WHEN get_dup_name%NOTFOUND;
1278:
1279: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1280: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );
1281: FND_MSG_PUB.add;
1282:
1283: END LOOP;
1284:
1285: IF ( get_dup_name%ROWCOUNT > 0 ) THEN

Line 1312: FND_MSG_PUB.add;

1308: l_item_number := to_char(l_inventory_item_id);
1309: end if;
1310: close get_item_number;
1311: FND_MESSAGE.set_token( 'RECORD', l_item_number );
1312: FND_MSG_PUB.add;
1313: end if;
1314:
1315: END LOOP;
1316:

Line 1369: FND_MSG_PUB.initialize;

1365: END IF;
1366:
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF FND_API.to_boolean( p_init_msg_list ) THEN
1369: FND_MSG_PUB.initialize;
1370: END IF;
1371:
1372: -- Enable Debug (optional)
1373: IF ( G_DEBUG = 'Y' ) THEN

Line 1398: l_msg_count := FND_MSG_PUB.count_msg;

1394: RTRIM(LTRIM(g_appln_usage)), -- IN
1395: x_return_status, -- OUT
1396: p_super_user
1397: );
1398: l_msg_count := FND_MSG_PUB.count_msg;
1399: IF l_msg_count > 0 THEN
1400: AHL_DEBUG_PUB.debug('After validate with error ' );
1401: x_msg_count := l_msg_count;
1402: RAISE FND_API.G_EXC_ERROR;

Line 1534: l_msg_count := FND_MSG_PUB.count_msg;

1530: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
1531: END IF;
1532:
1533: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1534: l_msg_count := FND_MSG_PUB.count_msg;
1535: IF l_msg_count > 0 THEN
1536: x_msg_count := l_msg_count;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;

Line 1626: FND_MSG_PUB.add;

1622: WHEN OTHERS THEN
1623: IF ( SQLCODE = -1 ) THEN
1624: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1625: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1626: FND_MSG_PUB.add;
1627: END IF;
1628: END;
1629:
1630: ELSIF ( p_x_effectivity_tbl(i).dml_operation = 'U' ) THEN

Line 1671: FND_MSG_PUB.add;

1667: -- If the record does not exist, then, abort API.
1668: IF ( SQL%ROWCOUNT = 0 ) THEN
1669: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );
1671: FND_MSG_PUB.add;
1672: END IF;
1673:
1674: -- Set OUT values
1675: p_x_effectivity_tbl(i).object_version_number := p_x_effectivity_tbl(i).object_version_number + 1;

Line 1682: FND_MSG_PUB.add;

1678: WHEN OTHERS THEN
1679: IF ( SQLCODE = -1 ) THEN
1680: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1681: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1682: FND_MSG_PUB.add;
1683: END IF;
1684: END;
1685:
1686: ELSIF ( p_x_effectivity_tbl(i).dml_operation = 'D' ) THEN

Line 1697: FND_MSG_PUB.add;

1693: -- If the record does not exist, then, abort API.
1694: IF ( SQL%ROWCOUNT = 0 ) THEN
1695: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1696: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1697: FND_MSG_PUB.add;
1698: END IF;
1699:
1700: -- Delete the record in related Tables
1701: DELETE AHL_MR_EFFECTIVITY_DTLS

Line 1729: l_msg_count := FND_MSG_PUB.count_msg;

1725: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1726: END IF;
1727:
1728: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1729: l_msg_count := FND_MSG_PUB.count_msg;
1730: IF l_msg_count > 0 THEN
1731: x_msg_count := l_msg_count;
1732: RAISE FND_API.G_EXC_ERROR;
1733: END IF;

Line 1755: l_msg_count := FND_MSG_PUB.count_msg;

1751: END IF;
1752:
1753:
1754: -- If any severe error occurs, then, abort API.
1755: l_msg_count := FND_MSG_PUB.count_msg;
1756: IF l_msg_count > 0 THEN
1757: x_msg_count := l_msg_count;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;

Line 1771: FND_MSG_PUB.count_and_get

1767: COMMIT WORK;
1768: END IF;
1769:
1770: -- Count and Get messages (optional)
1771: FND_MSG_PUB.count_and_get
1772: (
1773: p_encoded => FND_API.G_FALSE,
1774: p_count => x_msg_count,
1775: p_data => x_msg_data

Line 1788: FND_MSG_PUB.count_and_get

1784:
1785: WHEN FND_API.G_EXC_ERROR THEN
1786: ROLLBACK TO process_effectivity_PVT;
1787: x_return_status := FND_API.G_RET_STS_ERROR ;
1788: FND_MSG_PUB.count_and_get
1789: (
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data

Line 1803: FND_MSG_PUB.count_and_get

1799:
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: ROLLBACK TO process_effectivity_PVT;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1803: FND_MSG_PUB.count_and_get
1804: (
1805: p_encoded => FND_API.G_FALSE,
1806: p_count => x_msg_count,
1807: p_data => x_msg_data

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

1814:
1815: WHEN OTHERS THEN
1816: ROLLBACK TO process_effectivity_PVT;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1818: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1819: THEN
1820: FND_MSG_PUB.add_exc_msg
1821: (
1822: p_pkg_name => G_PKG_NAME,

Line 1820: FND_MSG_PUB.add_exc_msg

1816: ROLLBACK TO process_effectivity_PVT;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1818: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1819: THEN
1820: FND_MSG_PUB.add_exc_msg
1821: (
1822: p_pkg_name => G_PKG_NAME,
1823: p_procedure_name => G_API_NAME,
1824: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1827: FND_MSG_PUB.count_and_get

1823: p_procedure_name => G_API_NAME,
1824: p_error_text => SUBSTRB(SQLERRM,1,240)
1825: );
1826: END IF;
1827: FND_MSG_PUB.count_and_get
1828: (
1829: p_encoded => FND_API.G_FALSE,
1830: p_count => x_msg_count,
1831: p_data => x_msg_data