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

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

328: WHEN OTHERS THEN
329: ROLLBACK TO sp_populate_prof_mat_req;
330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
335: p_procedure_name => 'POPULATE_PROF_MAT_REQ',
336: p_error_text => SUBSTR(SQLERRM,1,240));

Line 334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
335: p_procedure_name => 'POPULATE_PROF_MAT_REQ',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
335: p_procedure_name => 'POPULATE_PROF_MAT_REQ',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => X_msg_data);
341:
342:

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

652: WHEN OTHERS THEN
653: ROLLBACK TO sp_populate_prof_res_req;
654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655:
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
659: p_procedure_name => 'POPULATE_PROF_RES_REQ',
660: p_error_text => SUBSTR(SQLERRM,1,240));

Line 658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

654: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655:
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
659: p_procedure_name => 'POPULATE_PROF_RES_REQ',
660: p_error_text => SUBSTR(SQLERRM,1,240));
661: END IF;
662: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
659: p_procedure_name => 'POPULATE_PROF_RES_REQ',
660: p_error_text => SUBSTR(SQLERRM,1,240));
661: END IF;
662: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => X_msg_data);
665:
666: END populate_prof_res_req;

Line 865: FND_MSG_PUB.add;

861: -- Check Whether Profile is created or not
862: IF(p_x_nr_prof_est_tbl(i).nr_profile_header_id IS NULL)
863: THEN
864: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_MR_TIT_MIS');
865: FND_MSG_PUB.add;
866: END IF;
867:
868: /* Resource Type is not validated because it is not stored in Table : AHL_NR_PROFILE_DETAILS
869: It is showing in the UI,for filtering purpose*/

Line 884: FND_MSG_PUB.add;

880: IF(get_resource_id%NOTFOUND)
881: THEN
882: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_RES_NAME' );
883: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
884: FND_MSG_PUB.add;
885: END IF;
886: CLOSE get_resource_id;
887: ELSIF (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).cmro_resource_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL)
888: THEN

Line 895: FND_MSG_PUB.add;

891: IF(check_resource_id%NOTFOUND)
892: THEN
893: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_RES_ID' );
894: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
895: FND_MSG_PUB.add;
896: END IF;
897: CLOSE check_resource_id;
898: ELSIF ( (p_x_nr_prof_est_tbl(i).cmro_resource_id IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_id = FND_API.G_MISS_NUM)
899: AND (p_x_nr_prof_est_tbl(i).cmro_resource_name IS NULL OR p_x_nr_prof_est_tbl(i).cmro_resource_name = FND_API.G_MISS_CHAR)

Line 904: FND_MSG_PUB.add;

900: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
901: THEN
902: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_RES_MAND' );
903: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
904: FND_MSG_PUB.add;
905: END IF;
906:
907: -- Item Validtion (Material Estimations)
908: -- Get Inventory item id for a given item Name

Line 918: FND_MSG_PUB.add;

914: IF(get_inventory_item_id%NOTFOUND)
915: THEN
916: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_INV_ITEM_NAME' );
917: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
918: FND_MSG_PUB.add;
919: END IF;
920: CLOSE get_inventory_item_id;
921: ELSIF ( p_x_nr_prof_est_tbl(i).inventory_item_id IS NOT NULL AND p_x_nr_prof_est_tbl(i).inventory_item_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).inventory_item IS NULL)
922: THEN

Line 929: FND_MSG_PUB.add;

925: IF(check_inventory_item_id%NOTFOUND)
926: THEN
927: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_INV_ITEM_ID' );
928: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
929: FND_MSG_PUB.add;
930: END IF;
931: CLOSE check_inventory_item_id;
932: ELSIF ( (p_x_nr_prof_est_tbl(i).inventory_item_id IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item_id = FND_API.G_MISS_NUM)
933: AND (p_x_nr_prof_est_tbl(i).inventory_item IS NULL OR p_x_nr_prof_est_tbl(i).inventory_item = FND_API.G_MISS_CHAR)

Line 938: FND_MSG_PUB.add;

934: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
935: THEN
936: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_ITEM_MAND' );
937: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
938: FND_MSG_PUB.add;
939: END IF;
940:
941: -- UOM Validation
942: -- Get the UOM code for given UOM if UOM code is NULL

Line 953: FND_MSG_PUB.add;

949: THEN
950: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UOM' );
951: FND_MESSAGE.set_token('FIELD', p_x_nr_prof_est_tbl(i).uom);
952: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
953: FND_MSG_PUB.add;
954: END IF;
955: CLOSE get_uom_code;
956: ELSIF ( p_x_nr_prof_est_tbl(i).uom_code IS NOT NULL AND p_x_nr_prof_est_tbl(i).uom_code <> FND_API.G_MISS_CHAR AND p_x_nr_prof_est_tbl(i).uom IS NULL)
957: THEN

Line 965: FND_MSG_PUB.add;

961: THEN
962: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_UOM' );
963: FND_MESSAGE.set_token('FIELD', p_x_nr_prof_est_tbl(i).uom_code);
964: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
965: FND_MSG_PUB.add;
966: END IF;
967: CLOSE check_uom_code;
968: ELSIF ( (p_x_nr_prof_est_tbl(i).uom_code IS NULL OR p_x_nr_prof_est_tbl(i).uom_code = FND_API.G_MISS_CHAR)
969: AND (p_x_nr_prof_est_tbl(i).uom IS NULL OR p_x_nr_prof_est_tbl(i).uom = FND_API.G_MISS_CHAR)

Line 974: FND_MSG_PUB.add;

970: AND p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
971: THEN
972: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_UOM_NULL' );
973: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
974: FND_MSG_PUB.add;
975: END IF;
976:
977: -- Stage Type Validation
978: -- Get the Stage Type Code or Meaning and validate

Line 1012: FND_MSG_PUB.add;

1008: ELSE
1009: FND_MESSAGE.set_token( 'FIELD', p_x_nr_prof_est_tbl(i).stage_type );
1010: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1011: END IF;
1012: FND_MSG_PUB.add;
1013: END IF;
1014: END IF;
1015:
1016: -- Fleet Id Validation

Line 1027: FND_MSG_PUB.add;

1023: IF(get_fleet_id%NOTFOUND)
1024: THEN
1025: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_FLEET_NAME' );
1026: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
1027: FND_MSG_PUB.add;
1028: END IF;
1029: CLOSE get_fleet_id;
1030: ELSIF ( (p_x_nr_prof_est_tbl(i).fleet_header_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).fleet_header_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).fleet_name IS NULL)
1031: THEN

Line 1038: FND_MSG_PUB.add;

1034: IF(check_fleet_id%NOTFOUND)
1035: THEN
1036: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_FLEET_ID' );
1037: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1038: FND_MSG_PUB.add;
1039: END IF;
1040: CLOSE check_fleet_id;
1041: END IF;
1042:

Line 1054: FND_MSG_PUB.add;

1050: IF(get_operating_org_id%NOTFOUND)
1051: THEN
1052: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_ORG_NAME' );
1053: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i) ));
1054: FND_MSG_PUB.add;
1055: END IF;
1056: CLOSE get_operating_org_id;
1057: ELSIF ( (p_x_nr_prof_est_tbl(i).operating_org_id IS NOT NULL) AND p_x_nr_prof_est_tbl(i).operating_org_id <> FND_API.G_MISS_NUM AND p_x_nr_prof_est_tbl(i).operating_org_name IS NULL)
1058: THEN

Line 1065: FND_MSG_PUB.add;

1061: IF(check_operating_org_id%NOTFOUND)
1062: THEN
1063: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_INVL_ORG_ID' );
1064: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1065: FND_MSG_PUB.add;
1066: END IF;
1067: CLOSE check_operating_org_id;
1068: END IF;
1069:

Line 1106: FND_MSG_PUB.add;

1102: FND_MESSAGE.set_token( 'FIELD', p_x_nr_prof_est_tbl(i).operations_type);
1103: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1104: END IF;
1105:
1106: FND_MSG_PUB.add;
1107: END IF;
1108: END IF;
1109:
1110: /* IF Fleet is given , Operating org and Operations Type are not allowed*/

Line 1115: FND_MSG_PUB.add;

1111: IF(p_x_nr_prof_est_tbl(i).fleet_header_id IS NOT NULL AND (p_x_nr_prof_est_tbl(i).operations_type_code IS NOT NULL OR p_x_nr_prof_est_tbl(i).operating_org_id IS NOT NULL))
1112: THEN
1113: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_FLT_NO_ORG_OPR_TYP' );
1114: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1115: FND_MSG_PUB.add;
1116: END IF;
1117:
1118: END IF; -- Exluded date Close
1119:

Line 1132: FND_MSG_PUB.add;

1128: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
1129: THEN
1130: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_HRS_MAND' );
1131: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1132: FND_MSG_PUB.add;
1133: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1134: THEN
1135: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_QTY_MAND' );
1136: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 1137: FND_MSG_PUB.add;

1133: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1134: THEN
1135: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_QTY_MAND' );
1136: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1137: FND_MSG_PUB.add;
1138: END IF;
1139: ELSIF(p_x_nr_prof_est_tbl(i).required_qty < 0)
1140: THEN
1141: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)

Line 1145: FND_MSG_PUB.add;

1141: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
1142: THEN
1143: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_HRS_LESS_ZERO' );
1144: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1145: FND_MSG_PUB.add;
1146: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1147: THEN
1148: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_QTY_LESS_ZERO' );
1149: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 1150: FND_MSG_PUB.add;

1146: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1147: THEN
1148: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REQ_QTY_LESS_ZERO' );
1149: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1150: FND_MSG_PUB.add;
1151: END IF;
1152: ELSIF(p_x_nr_prof_est_tbl(i).analysis_qty < 0)
1153: THEN
1154: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)

Line 1158: FND_MSG_PUB.add;

1154: IF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_RESOURCE)
1155: THEN
1156: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_ANL_HRS_LESS_ZERO' );
1157: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1158: FND_MSG_PUB.add;
1159: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1160: THEN
1161: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_ANL_QTY_LESS_ZERO' );
1162: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );

Line 1163: FND_MSG_PUB.add;

1159: ELSIF(p_x_nr_prof_est_tbl(i).profile_detail_type = G_ITEM)
1160: THEN
1161: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_ANL_QTY_LESS_ZERO' );
1162: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1163: FND_MSG_PUB.add;
1164: END IF;
1165: END IF;
1166: END IF;
1167:

Line 1177: FND_MSG_PUB.add;

1173: IF(get_object_version_number%NOTFOUND)
1174: THEN
1175: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RECORD_CHANGED' );
1176: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1177: FND_MSG_PUB.add;
1178: END IF;
1179: CLOSE get_object_version_number;
1180: END IF;
1181:

Line 1186: l_msg_count := FND_MSG_PUB.count_msg;

1182: END LOOP; -- Table Loop
1183:
1184: END IF; --Table Count
1185:
1186: l_msg_count := FND_MSG_PUB.count_msg;
1187: IF l_msg_count > 0 THEN
1188: x_msg_count := l_msg_count;
1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;

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

1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO Validate_prof_details_sp;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data);
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN

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

1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: ROLLBACK TO Validate_prof_details_sp;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => X_msg_data);
1211: WHEN OTHERS THEN
1212: ROLLBACK TO Validate_prof_details_sp;

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

1211: WHEN OTHERS THEN
1212: ROLLBACK TO Validate_prof_details_sp;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1218: p_procedure_name => 'VALIDATE_PROF_DETAILS',
1219: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214:
1215: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1218: p_procedure_name => 'VALIDATE_PROF_DETAILS',
1219: p_error_text => SUBSTR(SQLERRM,1,240));
1220: END IF;
1221: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

1217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1218: p_procedure_name => 'VALIDATE_PROF_DETAILS',
1219: p_error_text => SUBSTR(SQLERRM,1,240));
1220: END IF;
1221: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1222: p_count => x_msg_count,
1223: p_data => X_msg_data);
1224:
1225: END Validate_prof_details;

Line 1321: FND_MSG_PUB.initialize;

1317: END IF;
1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE.
1320: IF FND_API.to_boolean( p_init_msg_list ) THEN
1321: FND_MSG_PUB.initialize;
1322: END IF;
1323:
1324: /* Call the Validate _profile details procedure for all validations*/
1325: Validate_prof_details

Line 1373: FND_MSG_PUB.add;

1369: IF(check_duplicate_record%FOUND)
1370: THEN
1371: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_DUP_REC' );
1372: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1373: FND_MSG_PUB.add;
1374: END IF;
1375:
1376: CLOSE check_duplicate_record;
1377:

Line 1440: FND_MSG_PUB.add;

1436: );
1437: ELSE
1438: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_DUP_REC' );
1439: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1440: FND_MSG_PUB.add;
1441: END IF;
1442:
1443: CLOSE check_duplicate_record;
1444:

Line 1566: FND_MSG_PUB.add;

1562: IF(check_exclude_record%FOUND)
1563: THEN
1564: FND_MESSAGE.set_name( 'AHL', 'AHL_RA_NP_REC_EXLD' );
1565: FND_MESSAGE.set_token('RECORD', get_record_identifier( p_x_nr_prof_est_tbl(i)) );
1566: FND_MSG_PUB.add;
1567: ELSE
1568:
1569: INSERT INTO AHL_NR_PROFILE_DETAILS
1570: (

Line 1700: l_msg_count := FND_MSG_PUB.count_msg;

1696: END IF;
1697: END IF;
1698:
1699: -- Get all the error messages if any and raise the appropriate Exception
1700: l_msg_count := FND_MSG_PUB.count_msg;
1701: IF l_msg_count > 0 THEN
1702: x_msg_count := l_msg_count;
1703: RAISE FND_API.G_EXC_ERROR;
1704: END IF;

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

1715: EXCEPTION
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ROLLBACK TO add_details_to_prof_sp;
1718: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1719: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN

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

1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: ROLLBACK TO add_details_to_prof_sp;
1725: X_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1727: p_count => x_msg_count,
1728: p_data => X_msg_data);
1729: WHEN OTHERS THEN
1730: ROLLBACK TO add_details_to_prof_sp;

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

1729: WHEN OTHERS THEN
1730: ROLLBACK TO add_details_to_prof_sp;
1731: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732:
1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1736: p_procedure_name => 'ADD_DETAILS_TO_PROF',
1737: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

1731: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732:
1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1736: p_procedure_name => 'ADD_DETAILS_TO_PROF',
1737: p_error_text => SUBSTR(SQLERRM,1,240));
1738: END IF;
1739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

1735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
1736: p_procedure_name => 'ADD_DETAILS_TO_PROF',
1737: p_error_text => SUBSTR(SQLERRM,1,240));
1738: END IF;
1739: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => X_msg_data);
1742:
1743: END add_details_to_prof;

Line 1848: FND_MSG_PUB.initialize;

1844: END IF;
1845:
1846: -- Initialize message list if p_init_msg_list is set to TRUE.
1847: IF FND_API.to_boolean( p_init_msg_list ) THEN
1848: FND_MSG_PUB.initialize;
1849: END IF;
1850:
1851: IF G_DEBUG = 'Y' THEN
1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' ::Begin API' );

Line 1865: FND_MSG_PUB.ADD;

1861: -- Profile Header ID Mandatory
1862: IF( p_x_nr_profile_header_rec.DML_OPERATION = 'U' AND p_x_nr_profile_header_rec.nr_profile_header_id IS NULL )
1863: THEN
1864: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_HDR_ID_MAND');
1865: FND_MSG_PUB.ADD;
1866: END IF;
1867:
1868: --Object version Number Validation
1869: IF( p_x_nr_profile_header_rec.DML_OPERATION = 'C' )

Line 1879: FND_MSG_PUB.add;

1875: FETCH get_object_version_number into l_object_version_number;
1876: IF(get_object_version_number%NOTFOUND)
1877: THEN
1878: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1879: FND_MSG_PUB.add;
1880: END IF;
1881: CLOSE get_object_version_number;
1882: END IF;
1883:

Line 1890: FND_MSG_PUB.ADD;

1886: THEN
1887: IF (p_x_nr_profile_header_rec.ident_seq_third IS NULL AND p_x_nr_profile_header_rec.ident_seq_fourth IS NOT NULL )
1888: THEN
1889: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_IDENT_SEQ_THR_REQ');
1890: FND_MSG_PUB.ADD;
1891: END IF;
1892:
1893: IF (p_x_nr_profile_header_rec.ident_seq_third IS NOT NULL AND p_x_nr_profile_header_rec.ident_seq_fourth IS NOT NULL AND p_x_nr_profile_header_rec.ident_seq_third = p_x_nr_profile_header_rec.ident_seq_fourth)
1894: THEN

Line 1896: FND_MSG_PUB.ADD;

1892:
1893: IF (p_x_nr_profile_header_rec.ident_seq_third IS NOT NULL AND p_x_nr_profile_header_rec.ident_seq_fourth IS NOT NULL AND p_x_nr_profile_header_rec.ident_seq_third = p_x_nr_profile_header_rec.ident_seq_fourth)
1894: THEN
1895: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_IDENT_SEQ_SAME');
1896: FND_MSG_PUB.ADD;
1897: END IF;
1898:
1899: --Status Code Validation
1900: IF(p_x_nr_profile_header_rec.status_code IS NULL)

Line 1903: FND_MSG_PUB.ADD;

1899: --Status Code Validation
1900: IF(p_x_nr_profile_header_rec.status_code IS NULL)
1901: THEN
1902: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_PROF_STAT_MAN');
1903: FND_MSG_PUB.ADD;
1904: END IF;
1905:
1906:
1907: END IF;

Line 1920: FND_MSG_PUB.ADD;

1916:
1917: IF(get_mr_title%NOTFOUND)
1918: THEN
1919: FND_MESSAGE.SET_NAME('AHL', 'AHL_FMP_INVALID_MR');
1920: FND_MSG_PUB.ADD;
1921: END IF;
1922:
1923: CLOSE get_mr_title;
1924:

Line 1931: FND_MSG_PUB.ADD;

1927:
1928: IF(check_duplicate%FOUND)
1929: THEN
1930: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_DUP_NR_PROFILE');
1931: FND_MSG_PUB.ADD;
1932: END IF;
1933:
1934: CLOSE check_duplicate;
1935:

Line 1938: FND_MSG_PUB.ADD;

1934: CLOSE check_duplicate;
1935:
1936: ELSE
1937: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_MR_TIT_MIS');
1938: FND_MSG_PUB.ADD;
1939: END IF;
1940:
1941: END IF;
1942:

Line 1961: FND_MSG_PUB.ADD;

1957: THEN
1958: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_NO_ACTIVE_MR');
1959: FND_MESSAGE.set_token( 'FIELD2', p_x_nr_profile_header_rec.status_code );
1960: FND_MESSAGE.set_token( 'FIELD1', l_prof_status_code );
1961: FND_MSG_PUB.ADD;
1962: END IF;
1963: CLOSE get_valid_mr_title;
1964: END IF;
1965: END IF;

Line 1972: l_msg_count := FND_MSG_PUB.count_msg;

1968: END IF;
1969:
1970:
1971: -- Get all the error messages if any and raise the appropriate Exception
1972: l_msg_count := FND_MSG_PUB.count_msg;
1973: IF l_msg_count > 0 THEN
1974: x_msg_count := l_msg_count;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;

Line 2099: FND_MSG_PUB.ADD;

2095: FETCH get_nr_profile_title INTO l_mr_title;
2096: IF(get_nr_profile_title%NOTFOUND)
2097: THEN
2098: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_HDR_IS_INVLD');
2099: FND_MSG_PUB.ADD;
2100: RAISE FND_API.G_EXC_ERROR;
2101: END IF;
2102: CLOSE get_nr_profile_title;
2103: ELSIF(p_x_nr_profile_header_rec.MR_TITLE IS NULL )

Line 2106: FND_MSG_PUB.ADD;

2102: CLOSE get_nr_profile_title;
2103: ELSIF(p_x_nr_profile_header_rec.MR_TITLE IS NULL )
2104: THEN
2105: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_MR_TITL_MAND');
2106: FND_MSG_PUB.ADD;
2107: RAISE FND_API.G_EXC_ERROR;
2108: ELSE
2109: l_mr_title := p_x_nr_profile_header_rec.MR_TITLE;
2110: -- Get the Profile header ID for Given MR TITLE

Line 2116: FND_MSG_PUB.ADD;

2112: FETCH get_nr_profile_id INTO l_nr_profile_header_id;
2113: IF(get_nr_profile_id%NOTFOUND)
2114: THEN
2115: FND_MESSAGE.SET_NAME('AHL', 'AHL_RA_NP_MR_TITL_INVLD');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119: CLOSE get_nr_profile_id;
2120: END IF;

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

2162: EXCEPTION
2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2164: ROLLBACK TO process_nr_profile_sp;
2165: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2167: p_count => x_msg_count,
2168: p_data => x_msg_data);
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN

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

2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO process_nr_profile_sp;
2172: X_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2174: p_count => x_msg_count,
2175: p_data => X_msg_data);
2176: WHEN OTHERS THEN
2177: ROLLBACK TO process_nr_profile_sp;

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

2176: WHEN OTHERS THEN
2177: ROLLBACK TO process_nr_profile_sp;
2178: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179:
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181: THEN
2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
2183: p_procedure_name => 'PROCESS_NR_PROFILE',
2184: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',

2178: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179:
2180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181: THEN
2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
2183: p_procedure_name => 'PROCESS_NR_PROFILE',
2184: p_error_text => SUBSTR(SQLERRM,1,240));
2185: END IF;
2186: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

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

2182: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_RA_NR_PROFILE_PVT',
2183: p_procedure_name => 'PROCESS_NR_PROFILE',
2184: p_error_text => SUBSTR(SQLERRM,1,240));
2185: END IF;
2186: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
2187: p_count => x_msg_count,
2188: p_data => X_msg_data);
2189:
2190: