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_DI_ASSO_DOC_ASO_PVT dependencies on FND_MSG_PUB

Line 143: FND_MSG_PUB.ADD;

139: FETCH get_operation_status INTO l_status;
140: CLOSE get_operation_status;
141: IF l_status <> 'DRAFT' THEN
142: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OP_STAT_DRFT_ASO');
143: FND_MSG_PUB.ADD;
144: RETURN;
145: END IF;
146: END IF;
147:

Line 154: FND_MSG_PUB.ADD;

150: FETCH get_route_status INTO l_status;
151: CLOSE get_route_status;
152: IF l_status <> 'DRAFT' THEN
153: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ROU_STAT_DRFT_ASO');
154: FND_MSG_PUB.ADD;
155: RETURN;
156: END IF;
157: END IF;
158:

Line 169: FND_MSG_PUB.ADD;

165: --IF l_status <> 'CURRENT' OR l_obsolete_date < sysdate THEN
166: IF l_obsolete_date < sysdate THEN
167: FND_MESSAGE.SET_NAME('AHL','AHL_RM_DOC_INVALID');
168: FND_MESSAGE.SET_TOKEN('RECORD',l_document_no);
169: FND_MSG_PUB.ADD;
170: RETURN;
171: END IF;
172: END IF;
173:

Line 214: FND_MSG_PUB.ADD;

210: ((p_doc_title_asso_id IS NOT NULL OR p_doc_title_asso_id <> FND_API.G_MISS_NUM)
211: AND l_document_id IS NULL)
212: THEN
213: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
214: FND_MSG_PUB.ADD;
215: END IF;
216: -- This condition checks for Aso Object Type Code is Null
217: IF ((p_doc_title_asso_id IS NULL OR p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
218: (p_aso_object_type_code IS NULL OR p_aso_object_type_code = FND_API.G_MISS_CHAR))

Line 225: FND_MSG_PUB.ADD;

221: ((p_doc_title_asso_id IS NOT NULL OR p_doc_title_asso_id <> FND_API.G_MISS_NUM)
222: AND l_aso_object_type_code IS NULL)
223: THEN
224: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
225: FND_MSG_PUB.ADD;
226: END IF;
227: -- This condiiton checks for Aso Object Id Value Is Null
228: IF ((p_doc_title_asso_id IS NULL OR p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
229: (p_aso_object_id IS NULL OR p_aso_object_id = FND_API.G_MISS_NUM))

Line 236: FND_MSG_PUB.ADD;

232: ((p_doc_title_asso_id IS NOT NULL OR p_doc_title_asso_id <> FND_API.G_MISS_NUM)
233: AND l_aso_object_id IS NULL)
234: THEN
235: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
236: FND_MSG_PUB.ADD;
237: END IF;
238: --Check for Aso Object Type Code in fnd lookups
239: IF p_aso_object_type_code IS NOT NULL AND p_aso_object_type_code <> FND_API.G_MISS_CHAR
240: THEN

Line 246: FND_MSG_PUB.ADD;

242: FETCH get_aso_obj_type_code INTO l_dummy;
243: IF get_aso_obj_type_code%NOTFOUND
244: THEN
245: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYPE_NOT_EXISTS');
246: FND_MSG_PUB.ADD;
247: END IF;
248: CLOSE get_aso_obj_type_code;
249: END IF;
250: -- Validates for existence of document id in ahl documents table

Line 258: FND_MSG_PUB.ADD;

254: FETCH Check_doc_info INTO l_dummy;
255: IF Check_doc_info%NOTFOUND
256: THEN
257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NOT_EXISTS');
258: FND_MSG_PUB.ADD;
259: END IF;
260: CLOSE Check_doc_info;
261: END IF;
262: --Check for Duplicate Record

Line 272: FND_MSG_PUB.ADD;

268: IF dup_rec%FOUND
269: THEN
270: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
271: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
272: FND_MSG_PUB.ADD;
273: END IF;
274: CLOSE dup_rec;
275: END IF;
276: END IF;

Line 328: FND_MSG_PUB.initialize;

324: END IF;
325: -- Standard call to check for call compatibility.
326: IF FND_API.to_boolean(p_init_msg_list)
327: THEN
328: FND_MSG_PUB.initialize;
329: END IF;
330: -- Initialize API return status to success
331: x_return_status := 'S';
332: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 346: FND_MSG_PUB.ADD;

342: l_object_version_number;
343: IF (get_doc_assos_rec_b_info%NOTFOUND)
344: THEN
345: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_INVALID');
346: FND_MSG_PUB.ADD;
347: END IF;
348: CLOSE get_doc_assos_rec_b_info;
349:
350: -- Check for version number

Line 354: FND_MSG_PUB.ADD;

350: -- Check for version number
351: IF (l_object_version_number <> p_association_rec.object_version_number)
352: THEN
353: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_TL_REC_CHANGED');
354: FND_MSG_PUB.ADD;
355: END IF;
356: /*-------------------------------------------------------- */
357: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.DELETE_ROW */
358: /* description : Added by Senthil to call Table Handler */

Line 394: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

390: EXCEPTION
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO delete_association;
393: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397: --Debug Info
398: IF G_DEBUG='Y' THEN

Line 412: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

408:
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO delete_association;
411: X_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,
414: p_data => X_msg_data);
415: -- Debug info.
416: IF G_DEBUG='Y' THEN

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

425:
426: WHEN OTHERS THEN
427: ROLLBACK TO delete_association;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
432: p_procedure_name => 'DELETE_ASSOCIATION',
433: p_error_text => SUBSTR(SQLERRM,1,240));

Line 431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

427: ROLLBACK TO delete_association;
428: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
432: p_procedure_name => 'DELETE_ASSOCIATION',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
432: p_procedure_name => 'DELETE_ASSOCIATION',
433: p_error_text => SUBSTR(SQLERRM,1,240));
434: END IF;
435: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => X_msg_data);
438: -- Debug info.
439: IF G_DEBUG='Y' THEN

Line 541: FND_MSG_PUB.initialize;

537: END IF;
538: -- Standard call to check for call compatibility.
539: IF FND_API.to_boolean(p_init_msg_list)
540: THEN
541: FND_MSG_PUB.initialize;
542: END IF;
543: -- Initialize API return status to success
544: x_return_status := 'S';
545: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 569: l_msg_count := FND_MSG_PUB.count_msg;

565: p_delete_flag => p_x_association_tbl(i).delete_flag
566: );
567: END LOOP;
568: --Standard call to message count
569: l_msg_count := FND_MSG_PUB.count_msg;
570:
571: IF l_msg_count > 0 THEN
572: X_msg_count := l_msg_count;
573: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 813: FND_MSG_PUB.ADD;

809:
810:
811: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
812: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816: CLOSE dup_rec;
817: ELSE

Line 841: FND_MSG_PUB.ADD;

837:
838: END IF;
839: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
840: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: CLOSE dup_rec_check;
845: END IF;

Line 898: l_msg_count := FND_MSG_PUB.count_msg;

894: --Assign the doc title asso id,object version number
895: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
896: p_x_association_tbl(i).object_version_number := 1;
897: --Standard check to count messages
898: l_msg_count := FND_MSG_PUB.count_msg;
899:
900: IF l_msg_count > 0 THEN
901: X_msg_count := l_msg_count;
902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 928: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

924: EXCEPTION
925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
926: ROLLBACK TO create_association;
927: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data);
931:
932: --Debug Info

Line 946: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

942:
943: WHEN FND_API.G_EXC_ERROR THEN
944: ROLLBACK TO create_association;
945: X_return_status := FND_API.G_RET_STS_ERROR;
946: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
947: p_count => x_msg_count,
948: p_data => X_msg_data);
949:
950: -- Debug info.

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

960:
961: WHEN OTHERS THEN
962: ROLLBACK TO create_association;
963: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
967: p_procedure_name => 'CREATE_ASSOCIATION',
968: p_error_text => SUBSTR(SQLERRM,1,240));

Line 966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

962: ROLLBACK TO create_association;
963: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
967: p_procedure_name => 'CREATE_ASSOCIATION',
968: p_error_text => SUBSTR(SQLERRM,1,240));
969: END IF;
970: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 970: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
967: p_procedure_name => 'CREATE_ASSOCIATION',
968: p_error_text => SUBSTR(SQLERRM,1,240));
969: END IF;
970: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
971: p_count => x_msg_count,
972: p_data => X_msg_data);
973: -- Debug info.
974: IF G_DEBUG='Y' THEN

Line 1126: FND_MSG_PUB.initialize;

1122: END IF;
1123: -- Standard call to check for call compatibility.
1124: IF FND_API.to_boolean(p_init_msg_list)
1125: THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;
1128: -- Initialize API return status to success
1129: x_return_status := 'S';
1130: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1154: l_msg_count := FND_MSG_PUB.count_msg;

1150: p_delete_flag => p_x_association_tbl(i).delete_flag
1151: );
1152: END LOOP;
1153: --Standard check to count messages
1154: l_msg_count := FND_MSG_PUB.count_msg;
1155:
1156: IF l_msg_count > 0 THEN
1157: X_msg_count := l_msg_count;
1158: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1186: FND_MSG_PUB.ADD;

1182:
1183: if (l_association_info.object_version_number <>p_x_association_tbl(i).object_version_number)
1184: then
1185: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1186: FND_MSG_PUB.ADD;
1187: RAISE FND_API.G_EXC_ERROR;
1188: end if;
1189: IF NVL(p_x_association_tbl(i).document_id, 0) <> FND_API.G_MISS_NUM
1190: THEN

Line 1372: FND_MSG_PUB.ADD;

1368: THEN
1369:
1370: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1371: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374:
1375: END IF;
1376: END IF;

Line 1383: FND_MSG_PUB.ADD;

1379: IF l_found_flag = 'N'
1380: THEN
1381: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1382: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
1383: FND_MSG_PUB.ADD;
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:
1387: END IF;

Line 1424: FND_MSG_PUB.ADD;

1420: THEN
1421:
1422: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1423: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
1424: FND_MSG_PUB.ADD;
1425: RAISE FND_API.G_EXC_ERROR;
1426:
1427: END IF;
1428: END IF;

Line 1435: FND_MSG_PUB.ADD;

1431: IF l_found_flag = 'N'
1432: THEN
1433: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1434: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:
1439: END IF;

Line 1503: l_msg_count := FND_MSG_PUB.count_msg;

1499: END IF;
1500: END LOOP;
1501: END IF;
1502: --Standard check to count messages
1503: l_msg_count := FND_MSG_PUB.count_msg;
1504:
1505: IF l_msg_count > 0 THEN
1506: X_msg_count := l_msg_count;
1507: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1529: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1525: EXCEPTION
1526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1527: ROLLBACK TO modify_association;
1528: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1530: p_count => x_msg_count,
1531: p_data => x_msg_data);
1532:
1533: --Debug Info

Line 1547: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1543:
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: ROLLBACK TO modify_association;
1546: X_return_status := FND_API.G_RET_STS_ERROR;
1547: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1548: p_count => x_msg_count,
1549: p_data => X_msg_data);
1550: -- Debug info.
1551: IF G_DEBUG='Y' THEN

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

1560:
1561: WHEN OTHERS THEN
1562: ROLLBACK TO modify_association;
1563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
1567: p_procedure_name => 'MODIFY_ASSOCIATION',
1568: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',

1562: ROLLBACK TO modify_association;
1563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
1567: p_procedure_name => 'MODIFY_ASSOCIATION',
1568: p_error_text => SUBSTR(SQLERRM,1,240));
1569: END IF;
1570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_ASO_PVT',
1567: p_procedure_name => 'MODIFY_ASSOCIATION',
1568: p_error_text => SUBSTR(SQLERRM,1,240));
1569: END IF;
1570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,
1572: p_data => X_msg_data);
1573:
1574: -- Debug info.

Line 1646: Fnd_Msg_Pub.initialize;

1642: END IF;
1643: -- Standard call to check for call compatibility.
1644: IF Fnd_Api.to_boolean(p_init_msg_list)
1645: THEN
1646: Fnd_Msg_Pub.initialize;
1647: END IF;
1648: -- Initialize API return status to success
1649: x_return_status := 'S';
1650: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1669: l_msg_count := Fnd_Msg_Pub.count_msg;

1665: p_aso_object_id => p_association_rec.aso_object_id,
1666: p_delete_flag => 'N'
1667: );
1668: --Standard call to message count
1669: l_msg_count := Fnd_Msg_Pub.count_msg;
1670:
1671: IF l_msg_count > 0 THEN
1672: X_msg_count := l_msg_count;
1673: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1881: Fnd_Msg_Pub.ADD;

1877: FETCH dup_rec INTO l_dummy;
1878: IF dup_rec%FOUND THEN
1879: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1880: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1881: Fnd_Msg_Pub.ADD;
1882: RAISE Fnd_Api.G_EXC_ERROR;
1883: END IF;
1884: CLOSE dup_rec;
1885: --Gets the sequence Number

Line 1933: l_msg_count := Fnd_Msg_Pub.count_msg;

1929: X_LAST_UPDATE_DATE => sysdate,
1930: X_LAST_UPDATED_BY => fnd_global.user_id,
1931: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1932: --Standard check to count messages
1933: l_msg_count := Fnd_Msg_Pub.count_msg;
1934:
1935: IF l_msg_count > 0 THEN
1936: X_msg_count := l_msg_count;
1937: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1960: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1956: EXCEPTION
1957: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1958: ROLLBACK TO insert_assoc_rec;
1959: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1960: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:
1964: --Debug Info

Line 1978: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1974:
1975: WHEN Fnd_Api.G_EXC_ERROR THEN
1976: ROLLBACK TO insert_assoc_rec;
1977: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1978: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1979: p_count => x_msg_count,
1980: p_data => X_msg_data);
1981:
1982: -- Debug info.

Line 1996: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1992:
1993: WHEN OTHERS THEN
1994: ROLLBACK TO insert_assoc_rec;
1995: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1996: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1997: THEN
1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
1999: p_procedure_name => 'INSERT_ASSOC_REC',
2000: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',

1994: ROLLBACK TO insert_assoc_rec;
1995: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1996: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1997: THEN
1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
1999: p_procedure_name => 'INSERT_ASSOC_REC',
2000: p_error_text => SUBSTR(SQLERRM,1,240));
2001: END IF;
2002: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2002: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1998: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
1999: p_procedure_name => 'INSERT_ASSOC_REC',
2000: p_error_text => SUBSTR(SQLERRM,1,240));
2001: END IF;
2002: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => X_msg_data);
2005: -- Debug info.
2006: IF G_DEBUG='Y' THEN

Line 2073: Fnd_Msg_Pub.initialize;

2069: END IF;
2070: -- Standard call to check for call compatibility.
2071: IF Fnd_Api.to_boolean(p_init_msg_list)
2072: THEN
2073: Fnd_Msg_Pub.initialize;
2074: END IF;
2075: -- Initialize API return status to success
2076: x_return_status := 'S';
2077: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2105: Fnd_Msg_Pub.ADD;

2101: = l_association_rec.object_version_number
2102: FOR UPDATE OF aso_object_id NOWAIT;
2103: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
2104: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2105: Fnd_Msg_Pub.ADD;
2106: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2107: x_return_status := 'E' ;
2108: WHEN NO_DATA_FOUND THEN
2109: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 2110: Fnd_Msg_Pub.ADD;

2106: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2107: x_return_status := 'E' ;
2108: WHEN NO_DATA_FOUND THEN
2109: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2110: Fnd_Msg_Pub.ADD;
2111: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2112: x_return_status := 'E' ;
2113: WHEN OTHERS THEN
2114: IF SQLCODE = -54 THEN

Line 2116: Fnd_Msg_Pub.ADD;

2112: x_return_status := 'E' ;
2113: WHEN OTHERS THEN
2114: IF SQLCODE = -54 THEN
2115: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2116: Fnd_Msg_Pub.ADD;
2117: x_msg_data := 'AHL_COM_RECORD_CHANGED';
2118: x_return_status := 'E' ;
2119: ELSE
2120: RAISE;

Line 2123: l_msg_count := Fnd_Msg_Pub.count_msg;

2119: ELSE
2120: RAISE;
2121: END IF;
2122: END;
2123: l_msg_count := Fnd_Msg_Pub.count_msg;
2124: IF l_msg_count > 0 THEN
2125: x_msg_count := l_msg_count;
2126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2127: RAISE Fnd_Api.G_EXC_ERROR;

Line 2149: l_msg_count := Fnd_Msg_Pub.count_msg;

2145:
2146: END LOOP;
2147: CLOSE get_assos_b_cur;
2148: --Standard check to count messages
2149: l_msg_count := Fnd_Msg_Pub.count_msg;
2150:
2151: IF l_msg_count > 0 THEN
2152: X_msg_count := l_msg_count;
2153: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2175: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2171: EXCEPTION
2172: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2173: ROLLBACK TO copy_association;
2174: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2175: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2176: p_count => x_msg_count,
2177: p_data => x_msg_data);
2178:
2179: --Debug Info

Line 2193: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2189:
2190: WHEN Fnd_Api.G_EXC_ERROR THEN
2191: ROLLBACK TO copy_association;
2192: X_return_status := Fnd_Api.G_RET_STS_ERROR;
2193: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2194: p_count => x_msg_count,
2195: p_data => X_msg_data);
2196: -- Debug info.
2197: IF G_DEBUG='Y' THEN

Line 2210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

2206:
2207: WHEN OTHERS THEN
2208: ROLLBACK TO copy_association;
2209: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2211: THEN
2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
2213: p_procedure_name => 'COPY_ASSOCIATION',
2214: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',

2208: ROLLBACK TO copy_association;
2209: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2211: THEN
2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
2213: p_procedure_name => 'COPY_ASSOCIATION',
2214: p_error_text => SUBSTR(SQLERRM,1,240));
2215: END IF;
2216: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 2216: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2212: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'Ahl_Di_Asso_Doc_Aso_Pvt',
2213: p_procedure_name => 'COPY_ASSOCIATION',
2214: p_error_text => SUBSTR(SQLERRM,1,240));
2215: END IF;
2216: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2217: p_count => x_msg_count,
2218: p_data => X_msg_data);
2219:
2220: -- Debug info.