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_PP_MATERIALS_PVT dependencies on FND_MESSAGE

Line 622: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

618: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
619: WHERE SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID
620: AND OBJECT_VERSION_NUMBER=X_OBJECT_VERSION_NUMBER;
621: IF SQL%rowcount=0 THEN
622: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
623: Fnd_Msg_Pub.ADD;
624: END IF;
625: END UPDATE_ROW;
626: -- Delete procedure to remove record from schedule materials

Line 861: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

857: x_error_msg_code => l_msg_data);
858:
859: IF NVL(l_return_status,'x') <> 'S'
860: THEN
861: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
862: Fnd_Msg_Pub.ADD;
863: END IF;
864: --
865: END IF;

Line 882: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');

878: p_visit_id => NULL,
879: p_item_instance_id => NULL
880: );
881: IF l_return_status = FND_API.G_TRUE THEN
882: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
883: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;

Line 883: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

879: p_item_instance_id => NULL
880: );
881: IF l_return_status = FND_API.G_TRUE THEN
882: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_MTL_UNTLCKD');
883: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887:

Line 905: Fnd_Message.SET_NAME('AHL','AHL_PP_VISIT_TASK_NOT_EXIST');

901: x_error_msg_code => l_msg_data);
902:
903: IF NVL(l_return_status,'x') <> 'S'
904: THEN
905: Fnd_Message.SET_NAME('AHL','AHL_PP_VISIT_TASK_NOT_EXIST');
906: Fnd_Msg_Pub.ADD;
907:
908: END IF;
909: END IF;

Line 928: Fnd_Message.SET_NAME('AHL','AHL_PP_ORG_ID_NOT_EXISTS');

924: x_project_id => l_project_id
925: );
926: -- Validate for organization
927: IF l_organization_id IS NULL THEN
928: Fnd_Message.SET_NAME('AHL','AHL_PP_ORG_ID_NOT_EXISTS');
929: Fnd_Msg_Pub.ADD;
930: END IF;
931:
932: -- rroy

Line 953: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

949: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id);
950: FETCH Check_wo_status_cur INTO l_dummy;
951: IF Check_wo_status_cur%NOTFOUND THEN
952: --
953: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
954: Fnd_Msg_Pub.ADD;
955: END IF;
956: --
957: CLOSE Check_wo_status_cur;

Line 991: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ORG_NOT_EXIST');

987: x_error_msg_code => l_msg_data);
988:
989: IF NVL(l_return_status,'x') <> 'S'
990: THEN
991: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ORG_NOT_EXIST');
992: Fnd_Msg_Pub.ADD;
993: END IF;
994: ELSE
995: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ID_REQUIRED');

Line 995: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ID_REQUIRED');

991: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ORG_NOT_EXIST');
992: Fnd_Msg_Pub.ADD;
993: END IF;
994: ELSE
995: Fnd_Message.SET_NAME('AHL','AHL_PP_INV_ID_REQUIRED');
996: Fnd_Msg_Pub.ADD;
997:
998: END IF;
999:

Line 1009: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');

1005:
1006: -- Validate for Requested Quantity
1007: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
1008: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN
1009: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
1010: Fnd_Msg_Pub.ADD;
1011: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1012: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
1013: -- Fix for FP bug# 6642084. -- Allow 0 quantity.

Line 1015: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');

1011: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
1012: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
1013: -- Fix for FP bug# 6642084. -- Allow 0 quantity.
1014: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
1015: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
1016: Fnd_Msg_Pub.ADD;
1017: END IF;
1018: END IF;
1019: --

Line 1030: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');

1026:
1027: -- Validate for Requested Date
1028: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
1029: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE ) THEN
1030: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
1031: Fnd_Msg_Pub.ADD;
1032: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1033: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
1034: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN

Line 1035: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_SYSD');

1031: Fnd_Msg_Pub.ADD;
1032: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
1033: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
1034: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
1035: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_SYSD');
1036: Fnd_Msg_Pub.ADD;
1037: END IF;
1038: END IF;
1039: END IF;

Line 1056: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_REQD');

1052: --
1053: OPEN Get_Operation_Seq_cur(p_x_req_material_tbl(i).workorder_operation_id);
1054: FETCH Get_Operation_Seq_cur INTO p_x_req_material_tbl(i).operation_sequence;
1055: IF Get_Operation_Seq_cur%NOTFOUND THEN
1056: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_REQD');
1057: Fnd_Msg_Pub.ADD;
1058: END IF;
1059: CLOSE Get_Operation_Seq_cur;
1060: END IF;

Line 1089: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_OP_ID_NOT_EXIST');

1085: x_error_msg_code => l_msg_data);
1086:
1087: IF NVL(l_return_status,'x') <> 'S'
1088: THEN
1089: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_OP_ID_NOT_EXIST');
1090: Fnd_Msg_Pub.ADD;
1091: --
1092: END IF;
1093: END IF;

Line 1131: Fnd_Message.SET_NAME('AHL','AHL_PP_RE_DATE_SCH_DATE');

1127: trunc(p_x_req_material_tbl(i).requested_date)) ;
1128: FETCH Get_sch_dates_cur INTO l_dummy;
1129: --
1130: IF Get_sch_dates_cur%NOTFOUND THEN
1131: Fnd_Message.SET_NAME('AHL','AHL_PP_RE_DATE_SCH_DATE');
1132: Fnd_Msg_Pub.ADD;
1133: END IF;
1134: --
1135: CLOSE Get_sch_dates_cur;

Line 1159: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');

1155: p_x_req_material_tbl(i).operation_sequence);
1156: FETCH Check_unique_cur INTO l_dummy;
1157: --
1158: IF Check_unique_cur%FOUND THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');
1160: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);
1161: Fnd_Msg_Pub.ADD;
1162:
1163: END IF;

Line 1160: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);

1156: FETCH Check_unique_cur INTO l_dummy;
1157: --
1158: IF Check_unique_cur%FOUND THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_MAT_RECORD_EXIST');
1160: FND_MESSAGE.SET_TOKEN('ITEM',p_x_req_material_tbl(i).concatenated_segments,false);
1161: Fnd_Msg_Pub.ADD;
1162:
1163: END IF;
1164: --

Line 2217: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

2213: x_error_msg_code => l_msg_data);
2214:
2215: IF NVL(l_return_status,'x') <> 'S'
2216: THEN
2217: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
2218: Fnd_Msg_Pub.ADD;
2219: END IF;
2220: --
2221: ELSE

Line 2222: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_REQUIRED');

2218: Fnd_Msg_Pub.ADD;
2219: END IF;
2220: --
2221: ELSE
2222: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_REQUIRED');
2223: Fnd_Msg_Pub.ADD;
2224: END IF;
2225: --
2226: p_x_req_material_tbl(i).workorder_id := l_workorder_id;

Line 2239: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');

2235: IF l_return_status = FND_API.G_TRUE THEN
2236: OPEN get_job_number(p_x_req_material_tbl(i).workorder_id);
2237: FETCH get_job_number INTO l_workorder_name;
2238: CLOSE get_job_number;
2239: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');
2240: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;

Line 2240: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

2236: OPEN get_job_number(p_x_req_material_tbl(i).workorder_id);
2237: FETCH get_job_number INTO l_workorder_name;
2238: CLOSE get_job_number;
2239: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_MTL_UNTLCKD');
2240: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
2241: FND_MSG_PUB.ADD;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2244: -- rroy

Line 2275: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');

2271:
2272: -- Validate for Requested Quantity
2273: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
2274: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN
2275: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_REQUIRED');
2276: Fnd_Msg_Pub.ADD;
2277: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
2278: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
2279: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN

Line 2280: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');

2276: Fnd_Msg_Pub.ADD;
2277: ELSIF (p_x_req_material_tbl(i).requested_quantity IS NOT NULL AND
2278: p_x_req_material_tbl(i).requested_quantity <> FND_API.G_MISS_NUM) THEN
2279: IF p_x_req_material_tbl(i).requested_quantity < 0 THEN
2280: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_QUANTITY_INVALID');
2281: Fnd_Msg_Pub.ADD;
2282: END IF;
2283: -- added in R12: Serial Reservation project.
2284: -- If requested quantity changed -

Line 2298: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');

2294: CLOSE get_count_resrv_cur;
2295:
2296: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
2297: THEN
2298: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
2299: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
2300: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
2301: Fnd_Msg_Pub.ADD;
2302: END IF;-- p_x_req_material_tbl(i).requested_quantity <

Line 2299: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);

2295:
2296: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
2297: THEN
2298: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
2299: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
2300: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
2301: Fnd_Msg_Pub.ADD;
2302: END IF;-- p_x_req_material_tbl(i).requested_quantity <
2303: END IF; --p_x_req_material_tbl(i).requested_quantity <>

Line 2300: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);

2296: IF (p_x_req_material_tbl(i).requested_quantity < l_reserved_quantity)
2297: THEN
2298: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_RESRV_QTY');
2299: Fnd_Message.SET_TOKEN('REQ_QTY',p_x_req_material_tbl(i).requested_quantity);
2300: Fnd_Message.SET_TOKEN('RRV_QTY',l_reserved_quantity);
2301: Fnd_Msg_Pub.ADD;
2302: END IF;-- p_x_req_material_tbl(i).requested_quantity <
2303: END IF; --p_x_req_material_tbl(i).requested_quantity <>
2304: END IF;

Line 2312: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');

2308: IF p_module_type <> 'API' THEN
2309: -- Validate for Requested Date
2310: IF (p_x_req_material_tbl(i).requested_date IS NULL OR
2311: p_x_req_material_tbl(i).requested_date = FND_API.G_MISS_DATE) THEN
2312: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_REQUIRED');
2313: Fnd_Msg_Pub.ADD;
2314: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
2315: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
2316: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN

Line 2317: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');

2313: Fnd_Msg_Pub.ADD;
2314: ELSIF (p_x_req_material_tbl(i).requested_date IS NOT NULL AND
2315: p_x_req_material_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
2316: IF p_x_req_material_tbl(i).requested_date < trunc(SYSDATE) THEN
2317: Fnd_Message.SET_NAME('AHL','AHL_PP_REQ_DATE_GT_EQ_SYSD');
2318: Fnd_Msg_Pub.ADD;
2319: END IF;
2320: END IF;
2321: IF G_DEBUG='Y' THEN

Line 2328: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');

2324:
2325: -- Validate for Schedule Material ID
2326: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL AND
2327: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
2328: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
2329: Fnd_Msg_Pub.ADD;
2330: END IF;
2331: IF G_DEBUG='Y' THEN
2332: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);

Line 2340: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

2336: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id);
2337: FETCH Check_wo_status_cur INTO l_dummy;
2338: IF Check_wo_status_cur%NOTFOUND THEN
2339: --
2340: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
2341: Fnd_Msg_Pub.ADD;
2342: END IF;
2343: --
2344: CLOSE Check_wo_status_cur;

Line 3071: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');

3067: -- Bug # 6680137 - start
3068: OPEN Get_job_details(p_x_req_material_tbl(i).workorder_id);
3069: FETCH Get_job_details INTO l_workorder_name;
3070: IF Get_job_details%NOTFOUND THEN
3071: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_ORD_NOT_EXISTS');
3072: Fnd_Msg_Pub.ADD;
3073: CLOSE Get_job_details;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;

Line 3087: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');

3083: CLOSE c_get_wo_status;
3084:
3085: IF l_wo_status IN ('7', '5', '12')
3086: THEN
3087: Fnd_Message.SET_NAME('AHL','AHL_PP_WO_STATUS_INVALID');
3088: Fnd_Msg_Pub.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091: -- Bug # 6680137 - end

Line 3103: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');

3099: p_ue_id => NULL,
3100: p_visit_id => NULL,
3101: p_item_instance_id => NULL);
3102: IF l_return_status = FND_API.G_TRUE THEN
3103: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3104: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3105: FND_MSG_PUB.ADD;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;

Line 3104: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);

3100: p_visit_id => NULL,
3101: p_item_instance_id => NULL);
3102: IF l_return_status = FND_API.G_TRUE THEN
3103: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_MTL_UNTLCKD');
3104: FND_MESSAGE.Set_Token('WO_NAME', l_workorder_name);
3105: FND_MSG_PUB.ADD;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: -- rroy

Line 3114: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');

3110:
3111: -- Check for Schedule Material ID
3112: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL OR
3113: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN
3114: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
3115: Fnd_Msg_Pub.ADD;
3116: END IF;
3117: --
3118: IF G_DEBUG='Y' THEN

Line 3133: Fnd_Message.SET_NAME('AHL','AHL_PP_RECORD_CHANGED');

3129: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id
3130: FOR UPDATE OF STATUS NOWAIT;
3131: --
3132: IF p_x_req_material_tbl(i).object_version_number <> l_object_version_number THEN
3133: Fnd_Message.SET_NAME('AHL','AHL_PP_RECORD_CHANGED');
3134: Fnd_Msg_Pub.ADD;
3135: RAISE Fnd_Api.G_EXC_ERROR;
3136: END IF;
3137: --

Line 4705: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');

4701: LOOP
4702: IF l_Req_Material_Tbl(i).operation_flag = 'C' THEN
4703: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
4704:
4705: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');

Line 4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);

4702: IF l_Req_Material_Tbl(i).operation_flag = 'C' THEN
4703: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
4704:
4705: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

Line 4707: l_text := fnd_message.get;

4703: IF l_Req_Material_Tbl(i).concatenated_segments IS NOT NULL THEN
4704:
4705: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4711: l_body := fnd_message.get;

Line 4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');

4705: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_ADDED_NTF');
4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4711: l_body := fnd_message.get;
4712: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4713: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number

Line 4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

4706: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4711: l_body := fnd_message.get;
4712: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4713: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number
4714: || '; Required date:'||l_Req_Material_Tbl(i).requested_date;

Line 4711: l_body := fnd_message.get;

4707: l_text := fnd_message.get;
4708: --Include quantity and date
4709: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_QTY_NTF');
4710: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4711: l_body := fnd_message.get;
4712: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4713: ||'; For Workorder:'||l_Req_Material_Tbl(i).job_number
4714: || '; Required date:'||l_Req_Material_Tbl(i).requested_date;
4715:

Line 4720: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');

4716: END IF;
4717:
4718: ELSE
4719: --Update
4720: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');

Line 4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);

4717:
4718: ELSE
4719: --Update
4720: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

Line 4722: l_text := fnd_message.get;

4718: ELSE
4719: --Update
4720: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4726: l_body := fnd_message.get;

Line 4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');

4720: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_UPDATE');
4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4726: l_body := fnd_message.get;
4727: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4728: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number

Line 4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);

4721: FND_MESSAGE.set_token('ITEM',l_Req_Material_Tbl(i).concatenated_segments,false);
4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4726: l_body := fnd_message.get;
4727: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4728: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number
4729: || ';Required date:'||l_Req_Material_Tbl(i).requested_date;

Line 4726: l_body := fnd_message.get;

4722: l_text := fnd_message.get;
4723: --Include quantity and date
4724: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_QTY_NTF_CHG');
4725: FND_MESSAGE.set_token('QTY',l_Req_Material_Tbl(i).requested_quantity,false);
4726: l_body := fnd_message.get;
4727: l_Req_Material_Tbl(i).notify_text := l_text ||''||l_body
4728: || ';For Workorder:'||l_Req_Material_Tbl(i).job_number
4729: || ';Required date:'||l_Req_Material_Tbl(i).requested_date;
4730: END IF;

Line 4759: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');

4755:
4756: OPEN CursorNotify(l_object);
4757: FETCH CursorNotify INTO l_rec;
4758: CLOSE CursorNotify;
4759: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');
4760: l_subject := fnd_message.get;
4761:
4762: l_role_name:=l_rec.approver_name;
4763:

Line 4760: l_subject := fnd_message.get;

4756: OPEN CursorNotify(l_object);
4757: FETCH CursorNotify INTO l_rec;
4758: CLOSE CursorNotify;
4759: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MAT_REQ_NTF_CONTENT');
4760: l_subject := fnd_message.get;
4761:
4762: l_role_name:=l_rec.approver_name;
4763:
4764: l_return_status := FND_API.G_RET_STS_SUCCESS;