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

Line 193: FND_MSG_PUB.Initialize;

189: END IF;
190:
191: -- Initialize message list if p_init_msg_list is set to TRUE
192: IF FND_API.To_Boolean( p_init_msg_list) THEN
193: FND_MSG_PUB.Initialize;
194: END IF;
195:
196: -- Initialize Procedure return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 218: FND_MSG_PUB.ADD;

214: END IF;
215: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
216: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
217: FND_MESSAGE.Set_Token('UC_HEADER_ID', p_uc_header_id);
218: FND_MSG_PUB.ADD;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221: CLOSE chk_unit_header_id_csr;
222:

Line 238: FND_MSG_PUB.ADD;

234: END IF;
235: -- Visit id VISIT_ID is invalid.
236: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_VWP_INVALID_VST');
237: FND_MESSAGE.Set_Token('VISIT_ID', p_visit_id);
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: CLOSE chk_visit_id_csr;
242: END IF; -- visit id NULL check

Line 303: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO Check_Unit_Completeness_Pvt;
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
304: p_data => x_msg_data,
305: p_encoded => FND_API.G_FALSE);
306: IF (l_log_exception >= l_log_current_level) THEN
307: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: ROLLBACK TO Check_Unit_Completeness_Pvt;
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF (l_log_unexpected >= l_log_current_level) THEN
317: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

319:
320: WHEN OTHERS THEN
321: ROLLBACK TO Check_Unit_Completeness_Pvt;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
324: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
325: p_procedure_name => l_api_name,
326: p_error_text => SUBSTR(SQLERRM,1,500));
327: END IF;

Line 324: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

320: WHEN OTHERS THEN
321: ROLLBACK TO Check_Unit_Completeness_Pvt;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
324: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
325: p_procedure_name => l_api_name,
326: p_error_text => SUBSTR(SQLERRM,1,500));
327: END IF;
328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

324: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
325: p_procedure_name => l_api_name,
326: p_error_text => SUBSTR(SQLERRM,1,500));
327: END IF;
328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
329: p_data => x_msg_data,
330: p_encoded => fnd_api.G_FALSE);
331: IF (l_log_unexpected >= l_log_current_level) THEN
332: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 461: FND_MSG_PUB.Initialize;

457: END IF;
458:
459: -- Initialize message list if p_init_msg_list is set to TRUE
460: IF FND_API.To_Boolean( p_init_msg_list) THEN
461: FND_MSG_PUB.Initialize;
462: END IF;
463:
464: -- Initialize Procedure return status to success
465: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 473: l_msg_count := FND_MSG_PUB.count_msg;

469: ' p_csi_instance_id = '||p_csi_instance_id);
470: END IF;
471:
472: -- Get the error message count till this point
473: l_msg_count := FND_MSG_PUB.count_msg;
474:
475: -- Check for the instance id
476: OPEN chk_instance_id_csr(p_csi_instance_id);
477: FETCH chk_instance_id_csr INTO l_dummy;

Line 486: FND_MSG_PUB.ADD;

482: END IF;
483: -- The item instance INSTANCE is invalid.
484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_FMP_INVALID_ITEM_INSTANCE');
485: FND_MESSAGE.Set_Token('INSTANCE', p_csi_instance_id);
486: FND_MSG_PUB.ADD;
487: END IF;
488: CLOSE chk_instance_id_csr;
489:
490: -- Get the immediate unit for the instance

Line 502: FND_MSG_PUB.ADD;

498: END IF;
499: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
500: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
501: FND_MESSAGE.Set_Token('UC_HEADER_ID', l_uc_header_id);
502: FND_MSG_PUB.ADD;
503: END IF;
504: CLOSE get_unit_name_csr;
505:
506: -- If any errors occured, then raise them

Line 507: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN

503: END IF;
504: CLOSE get_unit_name_csr;
505:
506: -- If any errors occured, then raise them
507: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN
508: IF (l_log_statement >= l_log_current_level) THEN
509: FND_LOG.string(l_log_statement, l_full_name, 'given instance and / or its unit are invalid');
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;

Line 570: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO Check_Inst_Completeness_Pvt;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
571: p_data => x_msg_data,
572: p_encoded => FND_API.G_FALSE);
573: IF (l_log_exception >= l_log_current_level) THEN
574: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 580: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO Check_Inst_Completeness_Pvt;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => FND_API.G_FALSE);
583: IF (l_log_unexpected >= l_log_current_level) THEN
584: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

586:
587: WHEN OTHERS THEN
588: ROLLBACK TO Check_Inst_Completeness_Pvt;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
591: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
592: p_procedure_name => l_api_name,
593: p_error_text => SUBSTR(SQLERRM,1,500));
594: END IF;

Line 591: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

587: WHEN OTHERS THEN
588: ROLLBACK TO Check_Inst_Completeness_Pvt;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
591: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
592: p_procedure_name => l_api_name,
593: p_error_text => SUBSTR(SQLERRM,1,500));
594: END IF;
595: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 595: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

591: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
592: p_procedure_name => l_api_name,
593: p_error_text => SUBSTR(SQLERRM,1,500));
594: END IF;
595: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
596: p_data => x_msg_data,
597: p_encoded => fnd_api.G_FALSE);
598: IF (l_log_unexpected >= l_log_current_level) THEN
599: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 720: FND_MSG_PUB.Initialize;

716: END IF;
717:
718: -- Initialize message list if p_init_msg_list is set to TRUE
719: IF FND_API.To_Boolean(p_init_msg_list) THEN
720: FND_MSG_PUB.Initialize;
721: END IF;
722:
723: IF (l_log_statement >= l_log_current_level) THEN
724: FND_LOG.string(l_log_statement, l_full_name,

Line 741: FND_MSG_PUB.ADD;

737: IF (l_log_statement >= l_log_current_level) THEN
738: FND_LOG.string(l_log_statement, l_full_name, 'invalid MC and position');
739: END IF;
740: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_NODE_NOT_FOUND'); -- Master Configuration node not found.
741: FND_MSG_PUB.ADD;
742: END IF;
743: CLOSE get_mc_rel_id_csr;
744:
745: -- Get the matching units

Line 765: FND_MSG_PUB.ADD;

761: -- Rule RULE_NAME evaluation failed for the unit UNIT_NAME.
762: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MC_RULE_FAILED');
763: FND_MESSAGE.Set_Token('RULE_NAME',l_rule_name_tbl(i));
764: FND_MESSAGE.Set_Token('UNIT_NAME',l_get_unit_det_csr_rec.name);
765: FND_MSG_PUB.ADD;
766: IF (l_log_statement >= l_log_current_level) THEN
767: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));
768: END IF;
769: END IF;

Line 782: FND_MSG_PUB.ADD;

778: IF (l_log_statement >= l_log_current_level) THEN
779: FND_LOG.string(l_log_statement, l_full_name, 'no matching unit found');
780: END IF;
781: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_PC_UNIT_NOT_FOUND'); -- No such unit found in Unit Configuration.
782: FND_MSG_PUB.ADD;
783: END IF;
784:
785: IF (l_log_procedure >= l_log_current_level) THEN
786: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

Line 873: l_msg_count := FND_MSG_PUB.count_msg;

869: ', p_dst_mr_header_id = '||p_dst_mr_header_id);
870: END IF;
871:
872: -- Get the error message count till this point
873: l_msg_count := FND_MSG_PUB.count_msg;
874:
875: -- Check for the given MR ids
876: OPEN chk_mr_header_id_csr(p_src_mr_header_id);
877: FETCH chk_mr_header_id_csr INTO l_dummy;

Line 885: FND_MSG_PUB.ADD;

881: FND_LOG.string(l_log_statement, l_full_name, 'invalid source MR header id');
882: END IF;
883: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
884: FND_MESSAGE.Set_Token('MR_ID', p_src_mr_header_id);
885: FND_MSG_PUB.ADD;
886: END IF;
887: CLOSE chk_mr_header_id_csr;
888: OPEN chk_mr_header_id_csr(p_dst_mr_header_id);
889: FETCH chk_mr_header_id_csr INTO l_dummy;

Line 897: FND_MSG_PUB.ADD;

893: FND_LOG.string(l_log_statement, l_full_name, 'invalid destination MR header id');
894: END IF;
895: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
896: FND_MESSAGE.Set_Token('MR_ID', p_dst_mr_header_id);
897: FND_MSG_PUB.ADD;
898: END IF;
899: CLOSE chk_mr_header_id_csr;
900:
901: -- If any errors occured, then raise them

Line 902: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN

898: END IF;
899: CLOSE chk_mr_header_id_csr;
900:
901: -- If any errors occured, then raise them
902: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905:
906: -- Copy the SB rules from source MR to destination MR

Line 969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
967: ROLLBACK TO Copy_Rules_For_MR_Pvt;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE);
972: IF (l_log_exception >= l_log_current_level) THEN
973: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 979: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO Copy_Rules_For_MR_Pvt;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
980: p_data => x_msg_data,
981: p_encoded => FND_API.G_FALSE);
982: IF (l_log_unexpected >= l_log_current_level) THEN
983: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

985:
986: WHEN OTHERS THEN
987: ROLLBACK TO Copy_Rules_For_MR_Pvt;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
990: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
991: p_procedure_name => l_api_name,
992: p_error_text => SUBSTR(SQLERRM,1,500));
993: END IF;

Line 990: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

986: WHEN OTHERS THEN
987: ROLLBACK TO Copy_Rules_For_MR_Pvt;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
990: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
991: p_procedure_name => l_api_name,
992: p_error_text => SUBSTR(SQLERRM,1,500));
993: END IF;
994: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 994: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

990: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
991: p_procedure_name => l_api_name,
992: p_error_text => SUBSTR(SQLERRM,1,500));
993: END IF;
994: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
995: p_data => x_msg_data,
996: p_encoded => fnd_api.G_FALSE);
997: IF (l_log_unexpected >= l_log_current_level) THEN
998: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 1103: FND_MSG_PUB.ADD;

1099: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1100: END IF;
1101: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1102: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1103: FND_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106: CLOSE chk_mr_header_id_csr;
1107:

Line 1196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO Update_Rules_For_MR_Pvt;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1197: p_data => x_msg_data,
1198: p_encoded => FND_API.G_FALSE);
1199: IF (l_log_exception >= l_log_current_level) THEN
1200: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 1206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: ROLLBACK TO Update_Rules_For_MR_Pvt;
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1207: p_data => x_msg_data,
1208: p_encoded => FND_API.G_FALSE);
1209: IF (l_log_unexpected >= l_log_current_level) THEN
1210: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

1212:
1213: WHEN OTHERS THEN
1214: ROLLBACK TO Update_Rules_For_MR_Pvt;
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1218: p_procedure_name => l_api_name,
1219: p_error_text => SUBSTR(SQLERRM,1,500));
1220: END IF;

Line 1217: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1213: WHEN OTHERS THEN
1214: ROLLBACK TO Update_Rules_For_MR_Pvt;
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1218: p_procedure_name => l_api_name,
1219: p_error_text => SUBSTR(SQLERRM,1,500));
1220: END IF;
1221: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 1221: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1217: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1218: p_procedure_name => l_api_name,
1219: p_error_text => SUBSTR(SQLERRM,1,500));
1220: END IF;
1221: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1222: p_data => x_msg_data,
1223: p_encoded => fnd_api.G_FALSE);
1224: IF (l_log_unexpected >= l_log_current_level) THEN
1225: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 1312: FND_MSG_PUB.ADD;

1308: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1309: END IF;
1310: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1311: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315: CLOSE chk_mr_header_id_csr;
1316:

Line 1348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: ROLLBACK TO Delete_Rules_For_MR_Pvt;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1349: p_data => x_msg_data,
1350: p_encoded => FND_API.G_FALSE);
1351: IF (l_log_exception >= l_log_current_level) THEN
1352: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 1358: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: ROLLBACK TO Delete_Rules_For_MR_Pvt;
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1359: p_data => x_msg_data,
1360: p_encoded => FND_API.G_FALSE);
1361: IF (l_log_unexpected >= l_log_current_level) THEN
1362: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

1364:
1365: WHEN OTHERS THEN
1366: ROLLBACK TO Delete_Rules_For_MR_Pvt;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1369: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1370: p_procedure_name => l_api_name,
1371: p_error_text => SUBSTR(SQLERRM,1,500));
1372: END IF;

Line 1369: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1365: WHEN OTHERS THEN
1366: ROLLBACK TO Delete_Rules_For_MR_Pvt;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1369: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1370: p_procedure_name => l_api_name,
1371: p_error_text => SUBSTR(SQLERRM,1,500));
1372: END IF;
1373: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 1373: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1369: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1370: p_procedure_name => l_api_name,
1371: p_error_text => SUBSTR(SQLERRM,1,500));
1372: END IF;
1373: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1374: p_data => x_msg_data,
1375: p_encoded => fnd_api.G_FALSE);
1376: IF (l_log_unexpected >= l_log_current_level) THEN
1377: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 1515: FND_MSG_PUB.ADD;

1511: FND_LOG.string(l_log_statement, l_full_name, 'invalid item group id');
1512: END IF;
1513: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_ITEMGRP_INVALID'); -- Item Group ITEM_GRP is invalid.
1514: FND_MESSAGE.Set_Token('ITEM_GRP', p_item_group_id);
1515: FND_MSG_PUB.ADD;
1516: END IF;
1517: CLOSE chk_item_group_id_csr;
1518: OPEN chk_item_group_id_csr(p_src_item_group_id);
1519: FETCH chk_item_group_id_csr INTO l_dummy;

Line 1527: FND_MSG_PUB.ADD;

1523: FND_LOG.string(l_log_statement, l_full_name, 'invalid source item group id');
1524: END IF;
1525: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_ITEMGRP_INVALID'); -- Item Group ITEM_GRP is invalid.
1526: FND_MESSAGE.Set_Token('ITEM_GRP', p_src_item_group_id);
1527: FND_MSG_PUB.ADD;
1528: END IF;
1529: CLOSE chk_item_group_id_csr;
1530:
1531: -- Check for the fork or merge flag

Line 1764: FND_MSG_PUB.Initialize;

1760: END IF;
1761:
1762: -- Initialize message list if p_init_msg_list is set to TRUE
1763: IF FND_API.To_Boolean( p_init_msg_list) THEN
1764: FND_MSG_PUB.Initialize;
1765: END IF;
1766:
1767: -- Initialize Procedure return status to success
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1787: FND_MSG_PUB.ADD;

1783: END IF;
1784: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
1785: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
1786: FND_MESSAGE.Set_Token('UC_HEADER_ID', p_uc_header_id);
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790: CLOSE chk_unit_header_id_csr;
1791:

Line 1835: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1831: EXCEPTION
1832: WHEN FND_API.G_EXC_ERROR THEN
1833: ROLLBACK TO Get_Violated_Instances_Pvt;
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1836: p_data => x_msg_data,
1837: p_encoded => FND_API.G_FALSE);
1838: IF (l_log_exception >= l_log_current_level) THEN
1839: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 1845: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1841:
1842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1843: ROLLBACK TO Get_Violated_Instances_Pvt;
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1846: p_data => x_msg_data,
1847: p_encoded => FND_API.G_FALSE);
1848: IF (l_log_unexpected >= l_log_current_level) THEN
1849: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

1851:
1852: WHEN OTHERS THEN
1853: ROLLBACK TO Get_Violated_Instances_Pvt;
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1856: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1857: p_procedure_name => l_api_name,
1858: p_error_text => SUBSTR(SQLERRM,1,500));
1859: END IF;

Line 1856: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1852: WHEN OTHERS THEN
1853: ROLLBACK TO Get_Violated_Instances_Pvt;
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1856: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1857: p_procedure_name => l_api_name,
1858: p_error_text => SUBSTR(SQLERRM,1,500));
1859: END IF;
1860: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 1860: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

1856: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1857: p_procedure_name => l_api_name,
1858: p_error_text => SUBSTR(SQLERRM,1,500));
1859: END IF;
1860: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1861: p_data => x_msg_data,
1862: p_encoded => fnd_api.G_FALSE);
1863: IF (l_log_unexpected >= l_log_current_level) THEN
1864: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

Line 1934: FND_MSG_PUB.Initialize;

1930: END IF;
1931:
1932: -- Initialize message list if p_init_msg_list is set to TRUE
1933: IF FND_API.To_Boolean( p_init_msg_list) THEN
1934: FND_MSG_PUB.Initialize;
1935: END IF;
1936:
1937: -- Initialize Procedure return status to success
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1956: FND_MSG_PUB.ADD;

1952: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1953: END IF;
1954: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1955: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1956: FND_MSG_PUB.ADD;
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959: CLOSE chk_mr_header_id_csr;
1960:

Line 2022: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2018: EXCEPTION
2019: WHEN FND_API.G_EXC_ERROR THEN
2020: ROLLBACK TO Get_Affected_MC_Pvt;
2021: x_return_status := FND_API.G_RET_STS_ERROR;
2022: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2023: p_data => x_msg_data,
2024: p_encoded => FND_API.G_FALSE);
2025: IF (l_log_exception >= l_log_current_level) THEN
2026: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

Line 2032: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

2028:
2029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2030: ROLLBACK TO Get_Affected_MC_Pvt;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2033: p_data => x_msg_data,
2034: p_encoded => FND_API.G_FALSE);
2035: IF (l_log_unexpected >= l_log_current_level) THEN
2036: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

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

2038:
2039: WHEN OTHERS THEN
2040: ROLLBACK TO Get_Affected_MC_Pvt;
2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2043: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2044: p_procedure_name => l_api_name,
2045: p_error_text => SUBSTR(SQLERRM,1,500));
2046: END IF;

Line 2043: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

2039: WHEN OTHERS THEN
2040: ROLLBACK TO Get_Affected_MC_Pvt;
2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2043: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2044: p_procedure_name => l_api_name,
2045: p_error_text => SUBSTR(SQLERRM,1,500));
2046: END IF;
2047: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 2047: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

2043: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2044: p_procedure_name => l_api_name,
2045: p_error_text => SUBSTR(SQLERRM,1,500));
2046: END IF;
2047: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2048: p_data => x_msg_data,
2049: p_encoded => fnd_api.G_FALSE);
2050: IF (l_log_unexpected >= l_log_current_level) THEN
2051: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);