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

Line 185: Fnd_Msg_Pub.initialize;

181: -- may add additional messages to the stack.
182: -- Initialize message list if p_init_msg_list is set to TRUE.
183: IF Fnd_Api.to_Boolean(p_init_msg_list)
184: THEN
185: Fnd_Msg_Pub.initialize;
186: END IF;
187: -- Initialize API return status to SUCCESS
188: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
189:

Line 266: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

262: -- Validate Environment
263:
264: IF G_USER_ID IS NULL
265: THEN
266: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
267: THEN
268: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
269: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
270: Fnd_Msg_Pub.ADD;

Line 270: Fnd_Msg_Pub.ADD;

266: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
267: THEN
268: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
269: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
270: Fnd_Msg_Pub.ADD;
271: END IF;
272: RAISE Fnd_Api.G_EXC_ERROR;
273: END IF;
274:

Line 337: Fnd_Msg_Pub.ADD;

333: IF l_flow_status_id IS NULL THEN
334: -- Repair Order creation failed.
335: -- Unable to get the draft status details.
336: Fnd_Message.SET_NAME('CSD','CSD_RO_NO_DRAFT_STATUS_DTLS');
337: Fnd_Msg_Pub.ADD;
338: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: ELSE

Line 642: Fnd_Msg_Pub.ADD;

638: IF x_return_status <> 'S' THEN
639: -- Unable to update repair status. Adding repair activity
640: -- process has failed.
641: Fnd_Message.Set_Name('CSD', 'CSD_CREATE_RO_ACTY_FAIL');
642: Fnd_Msg_Pub.ADD;
643: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645:
646: IF l_REPLN_Rec.parent_repair_line_id is not NULL and l_REPLN_Rec.parent_repair_line_id <> FND_API.G_MISS_NUM THEN

Line 688: Fnd_Msg_Pub.ADD;

684: If x_return_status <> 'S' THEN
685: -- Unable to update repair status. Adding repair activity
686: -- process has failed.
687: Fnd_Message.Set_Name('CSD', 'CSD_CREATE_CHILD_RO_ACTY_FAIL');
688: Fnd_Msg_Pub.ADD;
689: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
690: END IF;
691: END IF;
692: -- END bug#13698799 auto create ro, parent ro

Line 703: Fnd_Msg_Pub.Count_And_Get

699: THEN
700: COMMIT WORK;
701: END IF;
702: -- Standard call to get message count and if count is 1, get message info.
703: Fnd_Msg_Pub.Count_And_Get
704: (p_count => x_msg_count,
705: p_data => x_msg_data
706: );
707:

Line 713: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

709: WHEN Fnd_Api.G_EXC_ERROR THEN
710: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
711: ( P_API_NAME => L_API_NAME
712: ,P_PKG_NAME => G_PKG_NAME
713: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
714: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
715: ,X_MSG_COUNT => X_MSG_COUNT
716: ,X_MSG_DATA => X_MSG_DATA
717: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 724: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

720: ROLLBACK TO CREATE_REPAIR_ORDER_PVT;
721: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
722: (P_API_NAME => L_API_NAME
723: ,P_PKG_NAME => G_PKG_NAME
724: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
725: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
726: ,X_MSG_COUNT => X_MSG_COUNT
727: ,X_MSG_DATA => X_MSG_DATA
728: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 891: Fnd_Msg_Pub.initialize;

887:
888: -- Initialize message list if p_init_msg_list is set to TRUE.
889: IF Fnd_Api.to_Boolean(p_init_msg_list)
890: THEN
891: Fnd_Msg_Pub.initialize;
892: END IF;
893: -- Initialize API return status to SUCCESS
894: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
895:

Line 902: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

898: -- Validate Environment
899:
900: IF G_USER_ID IS NULL
901: THEN
902: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
903: THEN
904: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
905: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
906: Fnd_Msg_Pub.ADD;

Line 906: Fnd_Msg_Pub.ADD;

902: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
903: THEN
904: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
905: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
906: Fnd_Msg_Pub.ADD;
907: END IF;
908: RAISE Fnd_Api.G_EXC_ERROR;
909: END IF;
910:

Line 1012: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1008: l_OLD_REPLN_rec.parent_repair_line_id -- bug#13698799 auto create ro, parent ro
1009: ;
1010:
1011: IF (C_Get_repairs%NOTFOUND) THEN
1012: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1013: Fnd_Message.Set_Name('CSD', 'CSD_API_MISSING_UPDATE_TARGET');
1014: Fnd_Message.Set_Token ('INFO', 'Repairs', FALSE);
1015: Fnd_Msg_Pub.ADD;
1016: END IF;

Line 1015: Fnd_Msg_Pub.ADD;

1011: IF (C_Get_repairs%NOTFOUND) THEN
1012: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1013: Fnd_Message.Set_Name('CSD', 'CSD_API_MISSING_UPDATE_TARGET');
1014: Fnd_Message.Set_Token ('INFO', 'Repairs', FALSE);
1015: Fnd_Msg_Pub.ADD;
1016: END IF;
1017: CLOSE C_Get_repairs;
1018: RAISE Fnd_Api.G_EXC_ERROR;
1019: END IF;

Line 1025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1021:
1022: -- bug#12884352
1023: -- should use csd_repairs_pub.update_repair_type to update repair type, not this function
1024: IF P_REPLN_rec.repair_type_id is not NULL and P_REPLN_rec.repair_type_id <> Fnd_Api.G_MISS_NUM and l_OLD_REPLN_rec.repair_type_id <> P_REPLN_Rec.repair_type_id THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_Name('CSD', 'CSD_UPDATE_REPAIR_TYPE');
1027: Fnd_Msg_Pub.ADD;
1028: END IF;
1029: RAISE Fnd_Api.G_EXC_ERROR;

Line 1027: Fnd_Msg_Pub.ADD;

1023: -- should use csd_repairs_pub.update_repair_type to update repair type, not this function
1024: IF P_REPLN_rec.repair_type_id is not NULL and P_REPLN_rec.repair_type_id <> Fnd_Api.G_MISS_NUM and l_OLD_REPLN_rec.repair_type_id <> P_REPLN_Rec.repair_type_id THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_Name('CSD', 'CSD_UPDATE_REPAIR_TYPE');
1027: Fnd_Msg_Pub.ADD;
1028: END IF;
1029: RAISE Fnd_Api.G_EXC_ERROR;
1030: END IF;
1031:

Line 1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1030: END IF;
1031:
1032: /*
1033: if l_OLD_REPLN_Rec.status = 'C' then
1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1035: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_CLOSED');
1036: FND_MESSAGE.Set_Token ('REP_NUM', l_OLD_REPLN_Rec.repair_number);
1037: FND_MSG_PUB.Add;
1038: END IF;

Line 1037: FND_MSG_PUB.Add;

1033: if l_OLD_REPLN_Rec.status = 'C' then
1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1035: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_CLOSED');
1036: FND_MESSAGE.Set_Token ('REP_NUM', l_OLD_REPLN_Rec.repair_number);
1037: FND_MSG_PUB.Add;
1038: END IF;
1039: raise FND_API.G_EXC_ERROR;
1040: end if;
1041: */

Line 1207: Fnd_Msg_Pub.Count_And_Get

1203: IF Fnd_Api.to_Boolean(p_commit) THEN
1204: COMMIT WORK;
1205: END IF;
1206: -- Standard call to get message count and if count is 1, get message info.
1207: Fnd_Msg_Pub.Count_And_Get
1208: (p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );
1211:

Line 1217: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1213: WHEN Fnd_Api.G_EXC_ERROR THEN
1214: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1215: (P_API_NAME => L_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1218: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1219: ,X_MSG_COUNT => X_MSG_COUNT
1220: ,X_MSG_DATA => X_MSG_DATA
1221: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1223: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1225: (P_API_NAME => L_API_NAME
1226: ,P_PKG_NAME => G_PKG_NAME
1227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1229: ,X_MSG_COUNT => X_MSG_COUNT
1230: ,X_MSG_DATA => X_MSG_DATA
1231: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1275: Fnd_Msg_Pub.initialize;

1271: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: -- Initialize message list if p_init_msg_list is set to TRUE.
1274: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
1275: Fnd_Msg_Pub.initialize;
1276: END IF;
1277: -- Initialize API return status to SUCCESS
1278: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1279: --

Line 1293: Fnd_Msg_Pub.Count_And_Get

1289: IF Fnd_Api.to_Boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292: -- Standard call to get message count and if count is 1, get message info.
1293: Fnd_Msg_Pub.Count_And_Get
1294: (p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );
1297:

Line 1303: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1299: WHEN Fnd_Api.G_EXC_ERROR THEN
1300: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1301: (P_API_NAME => L_API_NAME
1302: ,P_PKG_NAME => G_PKG_NAME
1303: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1304: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1305: ,X_MSG_COUNT => X_MSG_COUNT
1306: ,X_MSG_DATA => X_MSG_DATA
1307: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1313: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1309: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1310: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
1311: (P_API_NAME => L_API_NAME
1312: ,P_PKG_NAME => G_PKG_NAME
1313: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1314: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
1315: ,X_MSG_COUNT => X_MSG_COUNT
1316: ,X_MSG_DATA => X_MSG_DATA
1317: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1372: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1368: CLOSE c1;
1369:
1370: IF l_valid = 'N' THEN
1371: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1372: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1373: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_ID');
1374: Fnd_Msg_Pub.ADD;
1375: END IF;
1376: END IF;

Line 1374: Fnd_Msg_Pub.ADD;

1370: IF l_valid = 'N' THEN
1371: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1372: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1373: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_ID');
1374: Fnd_Msg_Pub.ADD;
1375: END IF;
1376: END IF;
1377:
1378: END Validate_REPAIR_LINE_ID;

Line 1414: Fnd_Msg_Pub.ADD;

1410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1411: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1412: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1413: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_NUMBER');
1414: Fnd_Msg_Pub.ADD;
1415: RETURN;
1416: ELSIF p_repair_number = p_old_repair_number
1417: OR p_repair_number = Fnd_Api.G_MISS_CHAR THEN
1418: RETURN;

Line 1431: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1427: CLOSE c1;
1428:
1429: IF l_valid = 'N' THEN
1430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1431: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1432: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_NUMBER');
1433: Fnd_Msg_Pub.ADD;
1434: END IF;
1435: END IF;

Line 1433: Fnd_Msg_Pub.ADD;

1429: IF l_valid = 'N' THEN
1430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1431: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1432: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_NUMBER');
1433: Fnd_Msg_Pub.ADD;
1434: END IF;
1435: END IF;
1436:
1437: END Validate_REPAIR_NUMBER;

Line 1467: Fnd_Msg_Pub.ADD;

1463: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1464: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1465: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1466: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INCIDENT_ID');
1467: Fnd_Msg_Pub.ADD;
1468: RETURN;
1469: ELSIF p_incident_id = p_old_incident_id
1470: OR p_incident_id = Fnd_Api.G_MISS_NUM THEN
1471: RETURN;

Line 1484: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1480: CLOSE c1;
1481:
1482: IF l_valid = 'N' THEN
1483: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1484: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1485: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INCIDENT_ID');
1486: Fnd_Msg_Pub.ADD;
1487: END IF;
1488: END IF;

Line 1486: Fnd_Msg_Pub.ADD;

1482: IF l_valid = 'N' THEN
1483: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1484: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1485: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INCIDENT_ID');
1486: Fnd_Msg_Pub.ADD;
1487: END IF;
1488: END IF;
1489:
1490: END Validate_INCIDENT_ID;

Line 1523: Fnd_Msg_Pub.ADD;

1519: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1520: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1521: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1522: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INVENTORY_ITEM_ID');
1523: Fnd_Msg_Pub.ADD;
1524: RETURN;
1525: ELSIF p_inventory_item_id = p_old_inventory_item_id
1526: OR p_inventory_item_id = Fnd_Api.G_MISS_NUM THEN
1527: RETURN;

Line 1540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1536: CLOSE c1;
1537:
1538: IF l_valid = 'N' THEN
1539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INVENTORY_ITEM');
1542: Fnd_Msg_Pub.ADD;
1543: END IF;
1544: END IF;

Line 1542: Fnd_Msg_Pub.ADD;

1538: IF l_valid = 'N' THEN
1539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INVENTORY_ITEM');
1542: Fnd_Msg_Pub.ADD;
1543: END IF;
1544: END IF;
1545:
1546: END Validate_INVENTORY_ITEM_ID;

Line 1613: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1609: CLOSE c1;
1610:
1611: IF l_valid = 'N' THEN
1612: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1613: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1614: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1615: Fnd_Msg_Pub.ADD;
1616: END IF;
1617: END IF;

Line 1615: Fnd_Msg_Pub.ADD;

1611: IF l_valid = 'N' THEN
1612: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1613: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1614: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1615: Fnd_Msg_Pub.ADD;
1616: END IF;
1617: END IF;
1618:
1619: END Validate_CUSTOMER_PRODUCT_ID;

Line 1682: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1678: CLOSE c1;
1679:
1680: IF l_valid = 'N' THEN
1681: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1682: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1683: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1684: Fnd_Msg_Pub.ADD;
1685: END IF;
1686: END IF;

Line 1684: Fnd_Msg_Pub.ADD;

1680: IF l_valid = 'N' THEN
1681: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1682: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1683: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1684: Fnd_Msg_Pub.ADD;
1685: END IF;
1686: END IF;
1687:
1688: END Validate_Internal_CUST_PROD_ID;

Line 1720: Fnd_Msg_Pub.ADD;

1716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1717: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1718: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1719: Fnd_Message.SET_TOKEN('NULL_PARAM', 'UNIT_OF_MEASURE');
1720: Fnd_Msg_Pub.ADD;
1721: RETURN;
1722: ELSIF p_unit_of_measure = p_unit_of_measure
1723: OR p_unit_of_measure = Fnd_Api.G_MISS_CHAR THEN
1724: RETURN;

Line 1737: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1733: CLOSE c1;
1734:
1735: IF l_valid = 'N' THEN
1736: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1737: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1738: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_UOM');
1739: Fnd_Msg_Pub.ADD;
1740: END IF;
1741: END IF;

Line 1739: Fnd_Msg_Pub.ADD;

1735: IF l_valid = 'N' THEN
1736: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1737: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1738: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_UOM');
1739: Fnd_Msg_Pub.ADD;
1740: END IF;
1741: END IF;
1742:
1743: END Validate_UNIT_OF_MEASURE;

Line 1775: Fnd_Msg_Pub.ADD;

1771: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1772: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1773: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1774: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_TYPE_ID');
1775: Fnd_Msg_Pub.ADD;
1776: RETURN;
1777: ELSIF p_repair_type_id = p_old_repair_type_id
1778: OR p_repair_type_id = Fnd_Api.G_MISS_NUM THEN
1779: RETURN;

Line 1792: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1788: CLOSE c1;
1789:
1790: IF l_valid = 'N' THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1793: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPAIR_TYPE');
1794: Fnd_Msg_Pub.ADD;
1795: END IF;
1796: END IF;

Line 1794: Fnd_Msg_Pub.ADD;

1790: IF l_valid = 'N' THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1793: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPAIR_TYPE');
1794: Fnd_Msg_Pub.ADD;
1795: END IF;
1796: END IF;
1797:
1798: END Validate_REPAIR_TYPE_ID;

Line 1875: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1871: CLOSE c1;
1872:
1873: IF l_valid = 'N' THEN
1874: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1875: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1876: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RESOURCE');
1877: Fnd_Msg_Pub.ADD;
1878: END IF;
1879: END IF;

Line 1877: Fnd_Msg_Pub.ADD;

1873: IF l_valid = 'N' THEN
1874: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1875: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1876: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RESOURCE');
1877: Fnd_Msg_Pub.ADD;
1878: END IF;
1879: END IF;
1880:
1881: END Validate_RESOURCE_ID;

Line 1933: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1929: CLOSE c1;
1930:
1931: IF l_valid = 'N' THEN
1932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1933: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1934: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RS_GROUP');
1935: Fnd_Msg_Pub.ADD;
1936: END IF;
1937: END IF;

Line 1935: Fnd_Msg_Pub.ADD;

1931: IF l_valid = 'N' THEN
1932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1933: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1934: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RS_GROUP');
1935: Fnd_Msg_Pub.ADD;
1936: END IF;
1937: END IF;
1938:
1939: END Validate_RESOURCE_GROUP;

Line 2021: Fnd_Msg_Pub.ADD;

2017: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2018: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2019: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2020: Fnd_Message.SET_TOKEN('NULL_PARAM', 'STATUS');
2021: Fnd_Msg_Pub.ADD;
2022: RETURN;
2023: ELSIF p_status = p_old_status
2024: OR p_status = Fnd_Api.G_MISS_CHAR THEN
2025: RETURN;

Line 2038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2034: CLOSE c1;
2035:
2036: IF l_valid = 'N' THEN
2037: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2039: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_STATUS');
2040: Fnd_Msg_Pub.ADD;
2041: END IF;
2042: END IF;

Line 2040: Fnd_Msg_Pub.ADD;

2036: IF l_valid = 'N' THEN
2037: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2039: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_STATUS');
2040: Fnd_Msg_Pub.ADD;
2041: END IF;
2042: END IF;
2043:
2044: END Validate_STATUS;

Line 2077: Fnd_Msg_Pub.ADD;

2073: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2074: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2075: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2076: Fnd_Message.SET_TOKEN('NULL_PARAM', 'APPROVAL_REQUIRED_FLAG');
2077: Fnd_Msg_Pub.ADD;
2078: RETURN;
2079: ELSIF p_approval_required_flag = p_old_approval_required_flag
2080: OR p_approval_required_flag = Fnd_Api.G_MISS_CHAR THEN
2081: RETURN;

Line 2094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2090: CLOSE c1;
2091:
2092: IF l_valid = 'N' THEN
2093: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2095: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_REQD_FLG');
2096: Fnd_Msg_Pub.ADD;
2097: END IF;
2098: END IF;

Line 2096: Fnd_Msg_Pub.ADD;

2092: IF l_valid = 'N' THEN
2093: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2095: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_REQD_FLG');
2096: Fnd_Msg_Pub.ADD;
2097: END IF;
2098: END IF;
2099:
2100: END Validate_APPROVAL_REQD_FLAG;

Line 2157: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2153: CLOSE c1;
2154:
2155: IF l_valid = 'N' THEN
2156: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2157: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2158: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_STATUS');
2159: Fnd_Msg_Pub.ADD;
2160: END IF;
2161: END IF;

Line 2159: Fnd_Msg_Pub.ADD;

2155: IF l_valid = 'N' THEN
2156: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2157: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2158: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_STATUS');
2159: Fnd_Msg_Pub.ADD;
2160: END IF;
2161: END IF;
2162:
2163: END Validate_APPROVAL_STATUS;

Line 2217: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2213: -- END IF;
2214:
2215: IF l_valid = 'N' THEN
2216: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2217: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2218: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_PROMISE_DATE');
2219: Fnd_Msg_Pub.ADD;
2220: END IF;
2221: END IF;

Line 2219: Fnd_Msg_Pub.ADD;

2215: IF l_valid = 'N' THEN
2216: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2217: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2218: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_PROMISE_DATE');
2219: Fnd_Msg_Pub.ADD;
2220: END IF;
2221: END IF;
2222:
2223: END Validate_PROMISE_DATE;

Line 2247: Fnd_Msg_Pub.ADD;

2243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2244: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2245: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2246: Fnd_Message.SET_TOKEN('NULL_PARAM', 'QUANTITY');
2247: Fnd_Msg_Pub.ADD;
2248: RETURN;
2249: ELSIF p_quantity = p_old_quantity
2250: OR p_quantity = Fnd_Api.G_MISS_NUM THEN
2251: RETURN;

Line 2261: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2257: END IF;
2258:
2259: IF l_valid = 'N' THEN
2260: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2261: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2262: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_QUANTITY');
2263: Fnd_Msg_Pub.ADD;
2264: END IF;
2265: END IF;

Line 2263: Fnd_Msg_Pub.ADD;

2259: IF l_valid = 'N' THEN
2260: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2261: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2262: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_QUANTITY');
2263: Fnd_Msg_Pub.ADD;
2264: END IF;
2265: END IF;
2266:
2267: END Validate_QUANTITY;

Line 2313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2309: end if;
2310:
2311: if l_valid = 'N' then
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2314: FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_QTY_IN_WIP');
2315: FND_MSG_PUB.ADD;
2316: END IF;
2317: end if;

Line 2315: FND_MSG_PUB.ADD;

2311: if l_valid = 'N' then
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2314: FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_QTY_IN_WIP');
2315: FND_MSG_PUB.ADD;
2316: END IF;
2317: end if;
2318: Commented by saupadhy after JDSU enhancements
2319: **************************************************/

Line 2378: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2374: END IF;
2375:
2376: IF l_valid = 'N' THEN
2377: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2378: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2379:
2380: -- travi this mesg need to be changed
2381: -- travi FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_OBJ_VER_NUM');
2382: Fnd_Msg_Pub.ADD;

Line 2382: Fnd_Msg_Pub.ADD;

2378: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2379:
2380: -- travi this mesg need to be changed
2381: -- travi FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_OBJ_VER_NUM');
2382: Fnd_Msg_Pub.ADD;
2383:
2384: END IF;
2385: END IF;
2386:

Line 2442: Fnd_Msg_Pub.ADD;

2438: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2440: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2441: Fnd_Message.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2442: Fnd_Msg_Pub.ADD;
2443: RETURN;
2444: ELSIF p_ro_group_id = p_old_ro_group_id
2445: OR p_ro_group_id = Fnd_Api.G_MISS_NUM THEN
2446: IF (g_debug > 0 ) THEN

Line 2465: FND_MSG_PUB.Add;

2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2463: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2464: FND_MESSAGE.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2465: FND_MSG_PUB.Add;
2466: return;
2467: elsif p_ro_group_id = p_old_ro_group_id
2468: or p_ro_group_id = FND_API.G_MISS_NUM then
2469: return;

Line 2493: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2489: CLOSE c1;
2490:
2491: IF l_valid = 'N' THEN
2492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2493: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2494: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RO_GROUP_ID');
2495: Fnd_Msg_Pub.ADD;
2496: END IF;
2497: END IF;

Line 2495: Fnd_Msg_Pub.ADD;

2491: IF l_valid = 'N' THEN
2492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2493: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2494: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RO_GROUP_ID');
2495: Fnd_Msg_Pub.ADD;
2496: END IF;
2497: END IF;
2498: END IF;
2499:

Line 2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2536: CLOSE c1;
2537:
2538: IF l_valid = 'N' THEN
2539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_SOURCE');
2542: Fnd_Message.SET_TOKEN('ORDER_LINE_ID', p_ORIGINAL_SOURCE_LINE_ID);
2543: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', p_ORIGINAL_SOURCE_HEADER_ID);
2544: Fnd_Msg_Pub.ADD;

Line 2544: Fnd_Msg_Pub.ADD;

2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_SOURCE');
2542: Fnd_Message.SET_TOKEN('ORDER_LINE_ID', p_ORIGINAL_SOURCE_LINE_ID);
2543: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', p_ORIGINAL_SOURCE_HEADER_ID);
2544: Fnd_Msg_Pub.ADD;
2545: END IF;
2546: END IF;
2547:
2548: END Validate_SOURCE;

Line 2629: Fnd_Msg_Pub.initialize;

2625: END IF;
2626: -- Initialize message list if p_init_msg_list is set to TRUE.
2627: IF Fnd_Api.to_Boolean(p_init_msg_list)
2628: THEN
2629: Fnd_Msg_Pub.initialize;
2630: END IF;
2631: -- Initialize API return status to SUCCESS
2632: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2633: --

Line 3227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

3223: WHEN Fnd_Api.G_EXC_ERROR THEN
3224: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3225: ( P_API_NAME => L_API_NAME
3226: ,P_PKG_NAME => G_PKG_NAME
3227: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
3228: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3229: ,X_MSG_COUNT => X_MSG_COUNT
3230: ,X_MSG_DATA => X_MSG_DATA
3231: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3237: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

3233: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3234: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
3235: (P_API_NAME => L_API_NAME
3236: ,P_PKG_NAME => G_PKG_NAME
3237: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
3238: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
3239: ,X_MSG_COUNT => X_MSG_COUNT
3240: ,X_MSG_DATA => X_MSG_DATA
3241: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3407: Fnd_Msg_Pub.initialize;

3403: END IF;
3404:
3405: -- Initialize message list if p_init_msg_list is set to TRUE.
3406: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
3407: Fnd_Msg_Pub.initialize;
3408: END IF;
3409:
3410: -- Initialize API return status to success
3411: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 3730: Fnd_Msg_Pub.Count_And_Get

3726: COMMIT;
3727: END IF;
3728:
3729: -- Standard call to get message count and if count is 1, get message info
3730: Fnd_Msg_Pub.Count_And_Get
3731: (p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3744: Fnd_Msg_Pub.Count_And_Get

3740: EXCEPTION
3741: WHEN Fnd_Api.G_EXC_ERROR THEN
3742: ROLLBACK TO Copy_Attachments;
3743: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3744: Fnd_Msg_Pub.Count_And_Get
3745: (p_count => x_msg_count,
3746: p_data => x_msg_data
3747: );
3748: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3757: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,

3753:
3754: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3755: ROLLBACK TO Copy_Attachments;
3756: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3757: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3758: p_data => x_msg_data );
3759:
3760: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3761: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

Line 3769: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

3765:
3766: WHEN OTHERS THEN
3767: ROLLBACK TO Copy_Attachments;
3768: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3769: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3770: THEN
3771: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
3772: l_api_name );
3773: END IF;

Line 3771: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,

3767: ROLLBACK TO Copy_Attachments;
3768: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
3769: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3770: THEN
3771: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
3772: l_api_name );
3773: END IF;
3774: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3775: p_data => x_msg_data );

Line 3774: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,

3770: THEN
3771: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
3772: l_api_name );
3773: END IF;
3774: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
3775: p_data => x_msg_data );
3776:
3777: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
3778: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

Line 3841: Fnd_Msg_Pub.initialize;

3837: END IF;
3838:
3839: -- Initialize message list if p_init_msg_list is set to TRUE.
3840: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
3841: Fnd_Msg_Pub.initialize;
3842: END IF;
3843:
3844: -- Initialize API return status to success
3845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 3999: Fnd_Msg_Pub.Count_And_Get

3995: COMMIT;
3996: END IF;
3997:
3998: -- Standard call to get message count and if count is 1, get message info
3999: Fnd_Msg_Pub.Count_And_Get
4000: (p_count => x_msg_count,
4001: p_data => x_msg_data);
4002:
4003: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 4013: Fnd_Msg_Pub.Count_And_Get

4009: EXCEPTION
4010: WHEN Fnd_Api.G_EXC_ERROR THEN
4011: ROLLBACK TO Delete_Attachments;
4012: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
4013: Fnd_Msg_Pub.Count_And_Get
4014: (p_count => x_msg_count,
4015: p_data => x_msg_data
4016: );
4017: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4026: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,

4022:
4023: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4024: ROLLBACK TO Delete_Attachments;
4025: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
4026: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4027: p_data => x_msg_data );
4028:
4029: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4030: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

Line 4038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

4034:
4035: WHEN OTHERS THEN
4036: ROLLBACK TO Delete_Attachments;
4037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
4038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4039: THEN
4040: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
4041: l_api_name );
4042: END IF;

Line 4040: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,

4036: ROLLBACK TO Delete_Attachments;
4037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
4038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4039: THEN
4040: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
4041: l_api_name );
4042: END IF;
4043: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4044: p_data => x_msg_data );

Line 4043: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,

4039: THEN
4040: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME ,
4041: l_api_name );
4042: END IF;
4043: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count,
4044: p_data => x_msg_data );
4045:
4046: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
4047: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

Line 4131: Fnd_Msg_Pub.initialize;

4127: 'csd.plsql.csd_repairs_pvt.update_ro_status.begin',
4128: 'Entering update_ro_status private api');
4129: END IF;
4130: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
4131: Fnd_Msg_Pub.initialize;
4132: END IF;
4133: IF NOT Fnd_Api.compatible_api_call(l_api_version_number, p_api_version, l_api_name, g_pkg_name) THEN
4134: RAISE Fnd_Api.g_exc_unexpected_error;
4135: END IF;

Line 4173: Fnd_Msg_Pub.ADD;

4169: FETCH ro_Details_cur INTO l_repair_status_rec.from_status_id, l_repair_type_id;
4170: IF(ro_details_cur%NOTFOUND) THEN
4171: CLOSE ro_details_cur;
4172: Fnd_Message.SET_NAME('CSD','CSD_INVALID_REPAIR_ORDER');
4173: Fnd_Msg_Pub.ADD;
4174: RAISE Fnd_Api.G_EXC_ERROR;
4175: END IF;
4176: CLOSE ro_details_cur;
4177:

Line 4183: Fnd_Msg_Pub.ADD;

4179: FETCH flow_stat_cur INTO l_repair_status_rec.repair_state;
4180: IF(flow_stat_cur%NOTFOUND) THEN
4181: CLOSE flow_stat_cur;
4182: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
4183: Fnd_Msg_Pub.ADD;
4184: RAISE Fnd_Api.G_EXC_ERROR;
4185: END IF;
4186: CLOSE flow_stat_cur;
4187:

Line 4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4251: COMMIT WORK;
4252: END IF;
4253:
4254: -- Standard call to get message count and IF count is get message info.
4255: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4256:
4257: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level) THEN
4258: Fnd_Log.STRING (Fnd_Log.level_procedure,
4259: 'csd.plsql.csd_repairs_pvt.update_ro_status',

Line 4268: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4264: WHEN Fnd_Api.g_exc_error
4265: THEN
4266: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4267: ROLLBACK TO update_ro_status_pvt;
4268: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4269: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level) THEN
4270: Fnd_Log.STRING (Fnd_Log.level_error,
4271: 'csd.plsql.csd_repairs_pvt.update_ro_status',
4272: 'EXC_ERROR[' || x_msg_data || ']');

Line 4278: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4274: WHEN Fnd_Api.g_exc_unexpected_error
4275: THEN
4276: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4277: ROLLBACK TO update_ro_status_pvt;
4278: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4279:
4280: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4281: Fnd_Log.STRING (Fnd_Log.level_exception,
4282: 'csd.plsql.csd_repairs_pvt.update_ro_status',

Line 4290: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN

4286: THEN
4287: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4288: ROLLBACK TO update_ro_status_pvt;
4289:
4290: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
4291: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
4292: END IF;
4293:
4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4291: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

4287: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4288: ROLLBACK TO update_ro_status_pvt;
4289:
4290: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
4291: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
4292: END IF;
4293:
4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4295:

Line 4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4290: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
4291: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
4292: END IF;
4293:
4294: Fnd_Msg_Pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4295:
4296: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level) THEN
4297: Fnd_Log.STRING (Fnd_Log.level_exception,
4298: 'csd.plsql.csd_repairs_pvt.update_ro_status',

Line 4411: Fnd_Msg_Pub.initialize;

4407: END IF;
4408:
4409: -- Initialize message list if p_init_msg_list is set to TRUE.
4410: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
4411: Fnd_Msg_Pub.initialize;
4412: END IF;
4413:
4414: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4415: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 4466: Fnd_Msg_Pub.ADD;

4462: -- 5362259, check to_flow_status_id
4463: IF P_TO_FLOW_STATUS_ID IS NULL THEN
4464: -- "Unable to update repair status. A new status is required for the transition."
4465: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_TO_STATUS_REQD');
4466: Fnd_Msg_Pub.ADD;
4467: RAISE Fnd_Api.G_EXC_ERROR;
4468: END IF;
4469:
4470:

Line 4501: Fnd_Msg_Pub.ADD;

4497: IF l_to_status_code IS NULL THEN
4498: -- "Unable to update repair status. The status transition
4499: -- is not valid for the current repair type."
4500: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_INVALID');
4501: Fnd_Msg_Pub.ADD;
4502: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4503: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
4504: -- "Unable to update repair status. A reason is required for the transition."
4505: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_REASON_REQD');

Line 4506: Fnd_Msg_Pub.ADD;

4502: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4503: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
4504: -- "Unable to update repair status. A reason is required for the transition."
4505: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_REASON_REQD');
4506: Fnd_Msg_Pub.ADD;
4507: -- 5362259, chaging exception from G_EXC_UNEXPECTED_ERROR to G_EXC_ERROR
4508: RAISE Fnd_Api.G_EXC_ERROR;
4509: END IF;
4510:

Line 4530: Fnd_Msg_Pub.ADD;

4526: ) THEN
4527: -- Unable to update repair status. The user does not
4528: -- have access to update the repair status.
4529: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_NO_ACCESS');
4530: Fnd_Msg_Pub.ADD;
4531: -- rfieldma, 5494587,
4532: -- changing exception from G_EXC_UNEXPECTED_ERROR
4533: -- to G_EXC_ERROR so that the extra developer's error
4534: -- won't show.

Line 4562: Fnd_Msg_Pub.ADD;

4558: IF l_reason_meaning IS NULL THEN
4559: -- "Unable to update repair status.
4560: -- Invalid reason selected for the transition."
4561: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_INVD_REASON');
4562: Fnd_Msg_Pub.ADD;
4563: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4564: END IF;
4565: END IF;
4566:

Line 4604: Fnd_Msg_Pub.ADD;

4600: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4601: -- "Unable to update repair status.
4602: -- Failed to create the workflow process."
4603: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_WF_FAIL');
4604: Fnd_Msg_Pub.ADD;
4605: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4606: END IF;
4607:
4608: END IF;

Line 4644: --Fnd_Msg_Pub.ADD;

4640: -- Unable to update repair status. Another user may have
4641: -- updated the repair order. Please requery the
4642: -- original data and try again.
4643: --Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_OLD_VERSION');
4644: --Fnd_Msg_Pub.ADD;
4645: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4646: --END;
4647:
4648: if(sql%rowcount > 0) then

Line 4657: Fnd_Msg_Pub.ADD;

4653: CLOSE c_get_object_version_number;
4654: else
4655: --debug('object_Version mismatch');
4656: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_OLD_VERSION');
4657: Fnd_Msg_Pub.ADD;
4658: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4659: end if;
4660:
4661: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4720: Fnd_Msg_Pub.ADD;

4716: IF x_return_status <> 'S' THEN
4717: -- Unable to update repair status. Adding repair activity
4718: -- process has failed.
4719: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_ACTY_FAIL');
4720: Fnd_Msg_Pub.ADD;
4721: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4722: END IF;
4723:
4724: END IF;

Line 4751: Fnd_Msg_Pub.ADD;

4747: IF x_return_status <> 'S' THEN
4748: -- Unable to update repair status. Adding repair activity
4749: -- process has failed.
4750: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_SR_FAIL');
4751: Fnd_Msg_Pub.ADD;
4752: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4753: END IF;
4754: END IF;
4755:

Line 4778: Fnd_Msg_Pub.ADD;

4774: IF x_return_status <> 'S' THEN
4775: -- Unable to update repair status. Failed
4776: -- to Initialize the business event.
4777: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_BE_FAIL');
4778: Fnd_Msg_Pub.ADD;
4779: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4780: END IF;
4781:
4782: --debug('update_flow_status: Step 11');

Line 4820: Fnd_Msg_Pub.Count_And_Get

4816: END IF;
4817: --debug('update_flow_status: Step 14');
4818:
4819: -- Standard call to get message count and IF count is get message info.
4820: Fnd_Msg_Pub.Count_And_Get
4821: (p_count => x_msg_count,
4822: p_data => x_msg_data );
4823:
4824: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4834: Fnd_Msg_Pub.Count_And_Get

4830: WHEN Fnd_Api.G_EXC_ERROR THEN
4831: ROLLBACK TO Update_Flow_Status;
4832: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4833:
4834: Fnd_Msg_Pub.Count_And_Get
4835: (p_count => x_msg_count,
4836: p_data => x_msg_data );
4837:
4838: -- save message in debug log

Line 4849: IF Fnd_Msg_Pub.Check_Msg_Level

4845: ROLLBACK TO Update_Flow_Status;
4846: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4847:
4848: -- save message in fnd stack
4849: IF Fnd_Msg_Pub.Check_Msg_Level
4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4851: THEN
4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

4846: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4847:
4848: -- save message in fnd stack
4849: IF Fnd_Msg_Pub.Check_Msg_Level
4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4851: THEN
4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

4850: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4851: THEN
4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4855: END IF;
4856: Fnd_Msg_Pub.Add_Exc_Msg
4857: (G_PKG_NAME ,
4858: lc_api_name );

Line 4856: Fnd_Msg_Pub.Add_Exc_Msg

4852: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4853: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4854: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4855: END IF;
4856: Fnd_Msg_Pub.Add_Exc_Msg
4857: (G_PKG_NAME ,
4858: lc_api_name );
4859: END IF;
4860:

Line 4861: Fnd_Msg_Pub.Count_And_Get

4857: (G_PKG_NAME ,
4858: lc_api_name );
4859: END IF;
4860:
4861: Fnd_Msg_Pub.Count_And_Get
4862: ( p_count => x_msg_count,
4863: p_data => x_msg_data );
4864:
4865: -- save message in debug log

Line 4876: IF Fnd_Msg_Pub.Check_Msg_Level

4872: ROLLBACK TO Update_Flow_Status;
4873: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4874:
4875: -- save message in fnd stack
4876: IF Fnd_Msg_Pub.Check_Msg_Level
4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

4873: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4874:
4875: -- save message in fnd stack
4876: IF Fnd_Msg_Pub.Check_Msg_Level
4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

4877: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4878: THEN
4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4882: END IF;
4883: Fnd_Msg_Pub.Add_Exc_Msg
4884: (G_PKG_NAME ,
4885: lc_api_name );

Line 4883: Fnd_Msg_Pub.Add_Exc_Msg

4879: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
4880: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
4881: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4882: END IF;
4883: Fnd_Msg_Pub.Add_Exc_Msg
4884: (G_PKG_NAME ,
4885: lc_api_name );
4886: END IF;
4887:

Line 4888: Fnd_Msg_Pub.Count_And_Get

4884: (G_PKG_NAME ,
4885: lc_api_name );
4886: END IF;
4887:
4888: Fnd_Msg_Pub.Count_And_Get
4889: (p_count => x_msg_count,
4890: p_data => x_msg_data );
4891:
4892: -- save message in debug log

Line 5055: Fnd_Msg_Pub.initialize;

5051: END IF;
5052:
5053: -- Initialize message list if p_init_msg_list is set to TRUE.
5054: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5055: Fnd_Msg_Pub.initialize;
5056: END IF;
5057:
5058: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5059: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 5121: Fnd_Msg_Pub.ADD;

5117: -- 5362259, validate p_to_repair_type_id and show error msg
5118: IF (p_to_repair_type_id IS NULL) THEN
5119: -- "Unable to update repair type. A new repair type is required for the transition."
5120: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TO_RT_REQD');
5121: Fnd_Msg_Pub.ADD;
5122: RAISE Fnd_Api.G_EXC_ERROR;
5123: END IF;
5124:
5125:

Line 5134: Fnd_Msg_Pub.ADD;

5130: IF l_reason_required_flag IS NULL THEN
5131: -- "Unable to update repair type. The repair type transition
5132: -- is not valid for the current status."
5133: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_INVALID');
5134: Fnd_Msg_Pub.ADD;
5135: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5136: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
5137: -- "Unable to update repair type. A reason is required for the transition."
5138: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_REASON_REQD');

Line 5139: Fnd_Msg_Pub.ADD;

5135: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5136: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
5137: -- "Unable to update repair type. A reason is required for the transition."
5138: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_REASON_REQD');
5139: Fnd_Msg_Pub.ADD;
5140: --5362259, changing exeception from G_EXC_UPEXPECTED_ERROR to G_EXC_ERROR
5141: RAISE Fnd_Api.G_EXC_ERROR;
5142: END IF;
5143:

Line 5157: Fnd_Msg_Pub.ADD;

5153: ) THEN
5154: -- Unable to update repair type. The user does not
5155: -- have access to update the repair type.
5156: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_NO_ACCESS');
5157: Fnd_Msg_Pub.ADD;
5158: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5159: END IF;
5160:
5161: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5182: Fnd_Msg_Pub.ADD;

5178: IF l_dummy IS NULL THEN
5179: -- "Unable to update repair type.
5180: -- Invalid reason selected for the transition."
5181: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_INVD_REASON');
5182: Fnd_Msg_Pub.ADD;
5183: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5184: END IF;
5185: END IF;
5186:

Line 5213: Fnd_Msg_Pub.ADD;

5209: -- Unable to update repair type. Another user may have
5210: -- updated the repair order. Please requery the
5211: -- original data and try again.
5212: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_OLD_VERSION');
5213: Fnd_Msg_Pub.ADD;
5214: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5215: END;
5216:
5217: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5330: Fnd_Msg_Pub.ADD;

5326: IF x_return_status <> 'S' THEN
5327: -- Unable to update repair type. Adding repair activity
5328: -- process has failed.
5329: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_ACTIVITY_FAILED');
5330: Fnd_Msg_Pub.ADD;
5331: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5332: END IF;
5333:
5334: END IF;

Line 5344: Fnd_Msg_Pub.Count_And_Get

5340: COMMIT WORK;
5341: END IF;
5342:
5343: -- Standard call to get message count and IF count is get message info.
5344: Fnd_Msg_Pub.Count_And_Get
5345: (p_count => x_msg_count,
5346: p_data => x_msg_data );
5347:
5348: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5358: Fnd_Msg_Pub.Count_And_Get

5354: WHEN Fnd_Api.G_EXC_ERROR THEN
5355: ROLLBACK TO Update_Repair_Type;
5356: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5357:
5358: Fnd_Msg_Pub.Count_And_Get
5359: (p_count => x_msg_count,
5360: p_data => x_msg_data );
5361:
5362: -- save message in debug log

Line 5373: IF Fnd_Msg_Pub.Check_Msg_Level

5369: ROLLBACK TO Update_Repair_Type;
5370: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5371:
5372: -- save message in fnd stack
5373: IF Fnd_Msg_Pub.Check_Msg_Level
5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5375: THEN
5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5370: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5371:
5372: -- save message in fnd stack
5373: IF Fnd_Msg_Pub.Check_Msg_Level
5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5375: THEN
5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5374: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5375: THEN
5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5379: END IF;
5380: Fnd_Msg_Pub.Add_Exc_Msg
5381: (G_PKG_NAME ,
5382: lc_api_name );

Line 5380: Fnd_Msg_Pub.Add_Exc_Msg

5376: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5377: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5378: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5379: END IF;
5380: Fnd_Msg_Pub.Add_Exc_Msg
5381: (G_PKG_NAME ,
5382: lc_api_name );
5383: END IF;
5384:

Line 5385: Fnd_Msg_Pub.Count_And_Get

5381: (G_PKG_NAME ,
5382: lc_api_name );
5383: END IF;
5384:
5385: Fnd_Msg_Pub.Count_And_Get
5386: ( p_count => x_msg_count,
5387: p_data => x_msg_data );
5388:
5389: -- save message in debug log

Line 5400: IF Fnd_Msg_Pub.Check_Msg_Level

5396: ROLLBACK TO Update_Repair_Type;
5397: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5398:
5399: -- save message in fnd stack
5400: IF Fnd_Msg_Pub.Check_Msg_Level
5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5402: THEN
5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5397: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5398:
5399: -- save message in fnd stack
5400: IF Fnd_Msg_Pub.Check_Msg_Level
5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5402: THEN
5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5401: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5402: THEN
5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5406: END IF;
5407: Fnd_Msg_Pub.Add_Exc_Msg
5408: (G_PKG_NAME ,
5409: lc_api_name );

Line 5407: Fnd_Msg_Pub.Add_Exc_Msg

5403: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5404: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5405: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5406: END IF;
5407: Fnd_Msg_Pub.Add_Exc_Msg
5408: (G_PKG_NAME ,
5409: lc_api_name );
5410: END IF;
5411:

Line 5412: Fnd_Msg_Pub.Count_And_Get

5408: (G_PKG_NAME ,
5409: lc_api_name );
5410: END IF;
5411:
5412: Fnd_Msg_Pub.Count_And_Get
5413: (p_count => x_msg_count,
5414: p_data => x_msg_data );
5415:
5416: -- save message in debug log

Line 5551: Fnd_Msg_Pub.initialize;

5547: END IF;
5548:
5549: -- Initialize message list if p_init_msg_list is set to TRUE.
5550: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5551: Fnd_Msg_Pub.initialize;
5552: END IF;
5553:
5554: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5555: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 5714: Fnd_Msg_Pub.Count_And_Get

5710: COMMIT WORK;
5711: END IF;
5712:
5713: -- Standard call to get message count and IF count is get message info.
5714: Fnd_Msg_Pub.Count_And_Get
5715: (p_count => x_msg_count,
5716: p_data => x_msg_data );
5717:
5718: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5728: Fnd_Msg_Pub.Count_And_Get

5724: WHEN Fnd_Api.G_EXC_ERROR THEN
5725: ROLLBACK TO Launch_Flwsts_Wf;
5726: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5727:
5728: Fnd_Msg_Pub.Count_And_Get
5729: (p_count => x_msg_count,
5730: p_data => x_msg_data );
5731:
5732: -- save message in debug log

Line 5743: IF Fnd_Msg_Pub.Check_Msg_Level

5739: ROLLBACK TO Launch_Flwsts_Wf;
5740: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5741:
5742: -- save message in fnd stack
5743: IF Fnd_Msg_Pub.Check_Msg_Level
5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5745: THEN
5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5740: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5741:
5742: -- save message in fnd stack
5743: IF Fnd_Msg_Pub.Check_Msg_Level
5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5745: THEN
5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5744: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5745: THEN
5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5749: END IF;
5750: Fnd_Msg_Pub.Add_Exc_Msg
5751: (G_PKG_NAME ,
5752: lc_api_name );

Line 5750: Fnd_Msg_Pub.Add_Exc_Msg

5746: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5747: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5748: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5749: END IF;
5750: Fnd_Msg_Pub.Add_Exc_Msg
5751: (G_PKG_NAME ,
5752: lc_api_name );
5753: END IF;
5754:

Line 5755: Fnd_Msg_Pub.Count_And_Get

5751: (G_PKG_NAME ,
5752: lc_api_name );
5753: END IF;
5754:
5755: Fnd_Msg_Pub.Count_And_Get
5756: ( p_count => x_msg_count,
5757: p_data => x_msg_data );
5758:
5759: -- save message in debug log

Line 5770: IF Fnd_Msg_Pub.Check_Msg_Level

5766: ROLLBACK TO Launch_Flwsts_Wf;
5767: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5768:
5769: -- save message in fnd stack
5770: IF Fnd_Msg_Pub.Check_Msg_Level
5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5767: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5768:
5769: -- save message in fnd stack
5770: IF Fnd_Msg_Pub.Check_Msg_Level
5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5771: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5772: THEN
5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5776: END IF;
5777: Fnd_Msg_Pub.Add_Exc_Msg
5778: (G_PKG_NAME ,
5779: lc_api_name );

Line 5777: Fnd_Msg_Pub.Add_Exc_Msg

5773: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5774: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5775: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5776: END IF;
5777: Fnd_Msg_Pub.Add_Exc_Msg
5778: (G_PKG_NAME ,
5779: lc_api_name );
5780: END IF;
5781:

Line 5782: Fnd_Msg_Pub.Count_And_Get

5778: (G_PKG_NAME ,
5779: lc_api_name );
5780: END IF;
5781:
5782: Fnd_Msg_Pub.Count_And_Get
5783: (p_count => x_msg_count,
5784: p_data => x_msg_data );
5785:
5786: -- save message in debug log

Line 5866: Fnd_Msg_Pub.initialize;

5862: --debug('operatingunit['||SYS_CONTEXT('FND','ORG_ID')||']');
5863:
5864: -- Initialize message list if p_init_msg_list is set to TRUE.
5865: IF Fnd_Api.to_Boolean( p_init_msg_list ) THEN
5866: Fnd_Msg_Pub.initialize;
5867: END IF;
5868:
5869: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5870: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 5883: Fnd_Msg_Pub.ADD;

5879: x_return_status => l_return_status);
5880:
5881: IF(l_return_Status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
5882: Fnd_Message.Set_Name('CSD', 'CSD_SECURITY_CHECK_FAILED');
5883: Fnd_Msg_Pub.ADD;
5884: RAISE Fnd_Api.G_EXC_ERROR;
5885: END IF;
5886:
5887: l_repair_status_rec.repair_line_id := p_repair_line_id;

Line 5914: Fnd_Msg_Pub.Count_And_Get

5910: COMMIT WORK;
5911: END IF;
5912:
5913: -- Standard call to get message count and IF count is get message info.
5914: Fnd_Msg_Pub.Count_And_Get
5915: (p_count => x_msg_count,
5916: p_data => x_msg_data );
5917:
5918: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5928: Fnd_Msg_Pub.Count_And_Get

5924: WHEN Fnd_Api.G_EXC_ERROR THEN
5925: ROLLBACK TO UPDATE_RO_STATUS_WEBSRVC_PVT;
5926: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5927:
5928: Fnd_Msg_Pub.Count_And_Get
5929: (p_count => x_msg_count,
5930: p_data => x_msg_data );
5931:
5932: -- save message in debug log

Line 5943: IF Fnd_Msg_Pub.Check_Msg_Level

5939: ROLLBACK TO UPDATE_RO_STATUS_WEBSRVC_PVT;
5940: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5941:
5942: -- save message in fnd stack
5943: IF Fnd_Msg_Pub.Check_Msg_Level
5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5945: THEN
5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5940: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5941:
5942: -- save message in fnd stack
5943: IF Fnd_Msg_Pub.Check_Msg_Level
5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5945: THEN
5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5944: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5945: THEN
5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5949: END IF;
5950: Fnd_Msg_Pub.Add_Exc_Msg
5951: (G_PKG_NAME ,
5952: lc_api_name );

Line 5950: Fnd_Msg_Pub.Add_Exc_Msg

5946: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5947: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5948: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5949: END IF;
5950: Fnd_Msg_Pub.Add_Exc_Msg
5951: (G_PKG_NAME ,
5952: lc_api_name );
5953: END IF;
5954:

Line 5955: Fnd_Msg_Pub.Count_And_Get

5951: (G_PKG_NAME ,
5952: lc_api_name );
5953: END IF;
5954:
5955: Fnd_Msg_Pub.Count_And_Get
5956: ( p_count => x_msg_count,
5957: p_data => x_msg_data );
5958:
5959: -- save message in debug log

Line 5970: IF Fnd_Msg_Pub.Check_Msg_Level

5966: ROLLBACK TO UPDATE_RO_STATUS_WEBSRVC_PVT;
5967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5968:
5969: -- save message in fnd stack
5970: IF Fnd_Msg_Pub.Check_Msg_Level
5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,

Line 5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

5967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5968:
5969: -- save message in fnd stack
5970: IF Fnd_Msg_Pub.Check_Msg_Level
5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

5971: (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5976: END IF;
5977: Fnd_Msg_Pub.Add_Exc_Msg
5978: (G_PKG_NAME ,
5979: lc_api_name );

Line 5977: Fnd_Msg_Pub.Add_Exc_Msg

5973: IF (Fnd_Log.LEVEL_STATEMENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
5974: Fnd_Log.STRING(Fnd_Log.LEVEL_STATEMENT, lc_mod_name,
5975: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5976: END IF;
5977: Fnd_Msg_Pub.Add_Exc_Msg
5978: (G_PKG_NAME ,
5979: lc_api_name );
5980: END IF;
5981:

Line 5982: Fnd_Msg_Pub.Count_And_Get

5978: (G_PKG_NAME ,
5979: lc_api_name );
5980: END IF;
5981:
5982: Fnd_Msg_Pub.Count_And_Get
5983: (p_count => x_msg_count,
5984: p_data => x_msg_data );
5985:
5986: -- save message in debug log

Line 6053: If FND_MSG_PUB.Check_Msg_Level

6049: EXCEPTION
6050: When OTHERS then
6051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6052: Rollback To ro_status_bevent_savepoint;
6053: If FND_MSG_PUB.Check_Msg_Level
6054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
6055: FND_MSG_PUB.Add_Exc_Msg
6056: (G_PKG_NAME,
6057: l_api_name );

Line 6054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

6050: When OTHERS then
6051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6052: Rollback To ro_status_bevent_savepoint;
6053: If FND_MSG_PUB.Check_Msg_Level
6054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
6055: FND_MSG_PUB.Add_Exc_Msg
6056: (G_PKG_NAME,
6057: l_api_name );
6058: End If;

Line 6055: FND_MSG_PUB.Add_Exc_Msg

6051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6052: Rollback To ro_status_bevent_savepoint;
6053: If FND_MSG_PUB.Check_Msg_Level
6054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
6055: FND_MSG_PUB.Add_Exc_Msg
6056: (G_PKG_NAME,
6057: l_api_name );
6058: End If;
6059: FND_MSG_PUB.Count_And_Get

Line 6059: FND_MSG_PUB.Count_And_Get

6055: FND_MSG_PUB.Add_Exc_Msg
6056: (G_PKG_NAME,
6057: l_api_name );
6058: End If;
6059: FND_MSG_PUB.Count_And_Get
6060: (p_count => x_msg_count,
6061: p_data => x_msg_data );
6062: END;
6063:

Line 6273: l_msg := fnd_msg_pub.get(p_msg_index => 1,

6269:
6270: IF p_msg_count = 1 THEN
6271:
6272: IF l_msg is null then
6273: l_msg := fnd_msg_pub.get(p_msg_index => 1,
6274: p_encoded => FND_API.G_FALSE );
6275: ELSE
6276: l_next_msg := fnd_msg_pub.get(p_msg_index => 1,
6277: p_encoded => FND_API.G_FALSE );

Line 6276: l_next_msg := fnd_msg_pub.get(p_msg_index => 1,

6272: IF l_msg is null then
6273: l_msg := fnd_msg_pub.get(p_msg_index => 1,
6274: p_encoded => FND_API.G_FALSE );
6275: ELSE
6276: l_next_msg := fnd_msg_pub.get(p_msg_index => 1,
6277: p_encoded => FND_API.G_FALSE );
6278:
6279: l_msg := substr(l_msg ||'-'||rtrim(l_next_msg),1,2000);
6280: END IF;

Line 6287: l_msg := fnd_msg_pub.get(p_msg_index => i,

6283:
6284: FOR i in 1..p_msg_count LOOP
6285:
6286: IF l_msg is null THEN
6287: l_msg := fnd_msg_pub.get(p_msg_index => i,
6288: p_encoded => FND_API.G_FALSE );
6289: ELSE
6290: l_next_msg := fnd_msg_pub.get(p_msg_index => i,
6291: p_encoded => FND_API.G_FALSE );

Line 6290: l_next_msg := fnd_msg_pub.get(p_msg_index => i,

6286: IF l_msg is null THEN
6287: l_msg := fnd_msg_pub.get(p_msg_index => i,
6288: p_encoded => FND_API.G_FALSE );
6289: ELSE
6290: l_next_msg := fnd_msg_pub.get(p_msg_index => i,
6291: p_encoded => FND_API.G_FALSE );
6292:
6293: l_msg := substr(l_msg ||'-'||rtrim(l_next_msg),1,2000);
6294: