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

Line 87: FND_MSG_PUB.initialize;

83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 396: FND_MSG_PUB.Count_And_Get

392: COMMIT WORK;
393: END IF;
394:
395: -- Standard call to get message count and if count is 1, get message info.
396: FND_MSG_PUB.Count_And_Get
397: ( p_count => x_msg_count,
398: p_data => x_msg_data
399: );
400: EXCEPTION

Line 404: FND_MSG_PUB.Count_And_Get

400: EXCEPTION
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO CSD_SPLIT_PKG;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 416: FND_MSG_PUB.Count_And_Get

412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO CSD_SPLIT_PKG;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 428: IF FND_MSG_PUB.Check_Msg_Level

424: END IF;
425: WHEN OTHERS THEN
426: ROLLBACK TO CSD_SPLIT_PKG;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg
432: ( G_PKG_NAME,

Line 429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

425: WHEN OTHERS THEN
426: ROLLBACK TO CSD_SPLIT_PKG;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg
432: ( G_PKG_NAME,
433: l_api_name

Line 431: FND_MSG_PUB.Add_Exc_Msg

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg
432: ( G_PKG_NAME,
433: l_api_name
434: );
435: END IF;

Line 436: FND_MSG_PUB.Count_And_Get

432: ( G_PKG_NAME,
433: l_api_name
434: );
435: END IF;
436: FND_MSG_PUB.Count_And_Get
437: ( p_count => x_msg_count,
438: p_data => x_msg_data
439: );
440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 627: FND_MSG_PUB.ADD;

623:
624: IF c_repair_line_dtls%notfound then
625: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
626: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630:
631: IF c_repair_line_dtls%isopen then

Line 774: FND_MSG_PUB.ADD;

770:
771: IF c_product_txn_line_dtls%notfound then
772: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
773: FND_MESSAGE.SET_TOKEN('p_product_txn_id',p_product_txn_id);
774: FND_MSG_PUB.ADD;
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777:
778: IF c_product_txn_line_dtls%isopen then

Line 813: FND_MSG_PUB.initialize;

809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: -- Initialize message list if p_init_msg_list is set to TRUE.
812: IF FND_API.to_Boolean( fnd_api.g_true ) THEN
813: FND_MSG_PUB.initialize;
814: END IF;
815:
816: IF (p_msg_code is not null) ThEN
817: x_return_status := FND_API.G_RET_STS_ERROR;

Line 819: FND_MSG_PUB.ADD;

815:
816: IF (p_msg_code is not null) ThEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MESSAGE.SET_NAME('CSD',p_msg_code);
819: FND_MSG_PUB.ADD;
820: END IF;
821:
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count,

Line 822: FND_MSG_PUB.Count_And_Get

818: FND_MESSAGE.SET_NAME('CSD',p_msg_code);
819: FND_MSG_PUB.ADD;
820: END IF;
821:
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826:

Line 887: FND_MSG_PUB.initialize;

883: l_repair_mode := null;
884:
885: -- Initialize message list if p_init_msg_list is set to TRUE.
886: IF FND_API.to_Boolean( fnd_api.g_true ) THEN
887: FND_MSG_PUB.initialize;
888: END IF;
889:
890: IF (p_repair_line_id is null) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;

Line 893: FND_MSG_PUB.ADD;

889:
890: IF (p_repair_line_id is null) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WITHOUT_RO_NUM');
893: FND_MSG_PUB.ADD;
894: FND_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data
897: );

Line 894: FND_MSG_PUB.Count_And_Get

890: IF (p_repair_line_id is null) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WITHOUT_RO_NUM');
893: FND_MSG_PUB.ADD;
894: FND_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898: return;

Line 912: FND_MSG_PUB.ADD;

908:
909: IF l_repair_type_ref not in ('SR', 'RR') then
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
912: FND_MSG_PUB.ADD;
913: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
914: FND_MSG_PUB.Count_And_Get
915: ( p_count => x_msg_count,
916: p_data => x_msg_data

Line 914: FND_MSG_PUB.Count_And_Get

910: x_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
912: FND_MSG_PUB.ADD;
913: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
914: FND_MSG_PUB.Count_And_Get
915: ( p_count => x_msg_count,
916: p_data => x_msg_data
917: );
918: return;

Line 938: FND_MSG_PUB.ADD;

934: l_total_quantity_in_wip := l_total_quantity_in_wip + P.quantity_in_wip;
935: if P.status <> 'O' then
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WRONG_STATUS');
938: FND_MSG_PUB.ADD;
939: elsif P.serial_number_control_code <> 1 then
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_SERIALIZED');
942: FND_MSG_PUB.ADD;

Line 942: FND_MSG_PUB.ADD;

938: FND_MSG_PUB.ADD;
939: elsif P.serial_number_control_code <> 1 then
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_SERIALIZED');
942: FND_MSG_PUB.ADD;
943: elsif P.repair_type_ref not in ('SR', 'RR') then
944: x_return_status := FND_API.G_RET_STS_ERROR;
945: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
946: FND_MSG_PUB.ADD;

Line 946: FND_MSG_PUB.ADD;

942: FND_MSG_PUB.ADD;
943: elsif P.repair_type_ref not in ('SR', 'RR') then
944: x_return_status := FND_API.G_RET_STS_ERROR;
945: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
946: FND_MSG_PUB.ADD;
947: elsif P.comms_nl_trackable_flag = 'Y' then
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_IB_TRBLE');
950: FND_MSG_PUB.ADD;

Line 950: FND_MSG_PUB.ADD;

946: FND_MSG_PUB.ADD;
947: elsif P.comms_nl_trackable_flag = 'Y' then
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_IB_TRBLE');
950: FND_MSG_PUB.ADD;
951: end if;
952: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
953: FND_MSG_PUB.Count_And_Get
954: ( p_count => x_msg_count,

Line 953: FND_MSG_PUB.Count_And_Get

949: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_IB_TRBLE');
950: FND_MSG_PUB.ADD;
951: end if;
952: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
953: FND_MSG_PUB.Count_And_Get
954: ( p_count => x_msg_count,
955: p_data => x_msg_data
956: );
957: return;

Line 968: FND_MSG_PUB.ADD;

964:
965: if (l_number_product_txn_lines < 1) then
966: x_return_status := FND_API.G_RET_STS_ERROR;
967: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_NO_LOGISTIC_LINE');
968: FND_MSG_PUB.ADD;
969: elsif (l_repair_quantity > l_total_quantity_rcvd) then
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_ALL_QTYS_NOT_REC');
972: FND_MSG_PUB.ADD;

Line 972: FND_MSG_PUB.ADD;

968: FND_MSG_PUB.ADD;
969: elsif (l_repair_quantity > l_total_quantity_rcvd) then
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_ALL_QTYS_NOT_REC');
972: FND_MSG_PUB.ADD;
973: elsif ((l_repair_quantity > l_total_quantity_in_wip) and (l_repair_mode = 'WIP') and (l_wip_job_count > 0)) then
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_JOB_INCOMPLETED');
976: FND_MSG_PUB.ADD;

Line 976: FND_MSG_PUB.ADD;

972: FND_MSG_PUB.ADD;
973: elsif ((l_repair_quantity > l_total_quantity_in_wip) and (l_repair_mode = 'WIP') and (l_wip_job_count > 0)) then
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_JOB_INCOMPLETED');
976: FND_MSG_PUB.ADD;
977: end if;
978:
979: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
980: FND_MSG_PUB.Count_And_Get

Line 980: FND_MSG_PUB.Count_And_Get

976: FND_MSG_PUB.ADD;
977: end if;
978:
979: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
980: FND_MSG_PUB.Count_And_Get
981: ( p_count => x_msg_count,
982: p_data => x_msg_data
983: );
984: return;

Line 992: FND_MSG_PUB.ADD;

988: loop
989: if S.interface_to_om_flag = 'Y' then
990: x_return_status := FND_API.G_RET_STS_ERROR;
991: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_LINE_INTERFACED');
992: FND_MSG_PUB.ADD;
993: end if;
994: end loop;
995: IF c_ship_product_txn_line_info%isopen then
996: CLOSE c_ship_product_txn_line_info;

Line 999: FND_MSG_PUB.Count_And_Get

995: IF c_ship_product_txn_line_info%isopen then
996: CLOSE c_ship_product_txn_line_info;
997: END IF;
998:
999: FND_MSG_PUB.Count_And_Get
1000: ( p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:

Line 1008: FND_MSG_PUB.Count_And_Get

1004: EXCEPTION
1005: WHEN FND_API.G_EXC_ERROR THEN
1006: ROLLBACK TO CSD_SPLIT_PKG;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1020: FND_MSG_PUB.Count_And_Get

1016: END IF;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO CSD_SPLIT_PKG;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get
1021: ( p_count => x_msg_count,
1022: p_data => x_msg_data
1023: );
1024: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1032: IF FND_MSG_PUB.Check_Msg_Level

1028: END IF;
1029: WHEN OTHERS THEN
1030: ROLLBACK TO CSD_SPLIT_PKG;
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level
1033: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg
1036: ( G_PKG_NAME,

Line 1033: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1029: WHEN OTHERS THEN
1030: ROLLBACK TO CSD_SPLIT_PKG;
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level
1033: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg
1036: ( G_PKG_NAME,
1037: l_api_name

Line 1035: FND_MSG_PUB.Add_Exc_Msg

1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level
1033: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg
1036: ( G_PKG_NAME,
1037: l_api_name
1038: );
1039: END IF;

Line 1040: FND_MSG_PUB.Count_And_Get

1036: ( G_PKG_NAME,
1037: l_api_name
1038: );
1039: END IF;
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1088: FND_MSG_PUB.initialize;

1084:
1085:
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;
1089: END IF;
1090:
1091: -- Initialize API return status to success
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1302: FND_MSG_PUB.Count_And_Get

1298: COMMIT WORK;
1299: END IF;
1300:
1301: -- Standard call to get message count and if count is 1, get message info.
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count,
1304: p_data => x_msg_data
1305: );
1306:

Line 1311: FND_MSG_PUB.Count_And_Get

1307: EXCEPTION
1308: WHEN FND_API.G_EXC_ERROR THEN
1309: ROLLBACK TO CSD_SPLIT_PKG;
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1323: FND_MSG_PUB.Count_And_Get

1319: END IF;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO CSD_SPLIT_PKG;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1323: FND_MSG_PUB.Count_And_Get
1324: ( p_count => x_msg_count,
1325: p_data => x_msg_data
1326: );
1327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1335: IF FND_MSG_PUB.Check_Msg_Level

1331: END IF;
1332: WHEN OTHERS THEN
1333: ROLLBACK TO CSD_SPLIT_PKG;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335: IF FND_MSG_PUB.Check_Msg_Level
1336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1337: THEN
1338: FND_MSG_PUB.Add_Exc_Msg
1339: ( G_PKG_NAME,

Line 1336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1332: WHEN OTHERS THEN
1333: ROLLBACK TO CSD_SPLIT_PKG;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335: IF FND_MSG_PUB.Check_Msg_Level
1336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1337: THEN
1338: FND_MSG_PUB.Add_Exc_Msg
1339: ( G_PKG_NAME,
1340: l_api_name

Line 1338: FND_MSG_PUB.Add_Exc_Msg

1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335: IF FND_MSG_PUB.Check_Msg_Level
1336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1337: THEN
1338: FND_MSG_PUB.Add_Exc_Msg
1339: ( G_PKG_NAME,
1340: l_api_name
1341: );
1342: END IF;

Line 1343: FND_MSG_PUB.Count_And_Get

1339: ( G_PKG_NAME,
1340: l_api_name
1341: );
1342: END IF;
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1387: FND_MSG_PUB.initialize;

1383:
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1387: FND_MSG_PUB.initialize;
1388: END IF;
1389:
1390: -- Initialize API return status to success
1391: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1449: FND_MSG_PUB.Count_And_Get

1445: COMMIT WORK;
1446: END IF;
1447:
1448: -- Standard call to get message count and if count is 1, get message info.
1449: FND_MSG_PUB.Count_And_Get
1450: ( p_count => x_msg_count,
1451: p_data => x_msg_data
1452: );
1453: EXCEPTION

Line 1457: FND_MSG_PUB.Count_And_Get

1453: EXCEPTION
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: ROLLBACK TO CSD_SPLIT_PKG;
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MSG_PUB.Count_And_Get
1458: ( p_count => x_msg_count,
1459: p_data => x_msg_data
1460: );
1461: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1469: FND_MSG_PUB.Count_And_Get

1465: END IF;
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1467: ROLLBACK TO CSD_SPLIT_PKG;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: FND_MSG_PUB.Count_And_Get
1470: ( p_count => x_msg_count,
1471: p_data => x_msg_data
1472: );
1473: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1481: IF FND_MSG_PUB.Check_Msg_Level

1477: END IF;
1478: WHEN OTHERS THEN
1479: ROLLBACK TO CSD_SPLIT_PKG;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481: IF FND_MSG_PUB.Check_Msg_Level
1482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: FND_MSG_PUB.Add_Exc_Msg
1485: ( G_PKG_NAME,

Line 1482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1478: WHEN OTHERS THEN
1479: ROLLBACK TO CSD_SPLIT_PKG;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481: IF FND_MSG_PUB.Check_Msg_Level
1482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: FND_MSG_PUB.Add_Exc_Msg
1485: ( G_PKG_NAME,
1486: l_api_name

Line 1484: FND_MSG_PUB.Add_Exc_Msg

1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481: IF FND_MSG_PUB.Check_Msg_Level
1482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: FND_MSG_PUB.Add_Exc_Msg
1485: ( G_PKG_NAME,
1486: l_api_name
1487: );
1488: END IF;

Line 1489: FND_MSG_PUB.Count_And_Get

1485: ( G_PKG_NAME,
1486: l_api_name
1487: );
1488: END IF;
1489: FND_MSG_PUB.Count_And_Get
1490: ( p_count => x_msg_count,
1491: p_data => x_msg_data
1492: );
1493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1548: FND_MSG_PUB.ADD;

1544:
1545: IF c_repair_history_record%notfound then
1546: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1547: FND_MESSAGE.SET_TOKEN('p_original_repair_history_id',p_original_repair_history_id);
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:
1552: IF c_repair_history_record%isopen then

Line 1600: FND_MSG_PUB.initialize;

1596:
1597:
1598: -- Initialize message list if p_init_msg_list is set to TRUE.
1599: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1600: FND_MSG_PUB.initialize;
1601: END IF;
1602:
1603: -- Initialize API return status to success
1604: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1675: FND_MSG_PUB.Count_And_Get

1671: COMMIT WORK;
1672: END IF;
1673:
1674: -- Standard call to get message count and if count is 1, get message info.
1675: FND_MSG_PUB.Count_And_Get
1676: ( p_count => x_msg_count,
1677: p_data => x_msg_data
1678: );
1679:

Line 1684: FND_MSG_PUB.Count_And_Get

1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: ROLLBACK TO CSD_SPLIT_PKG;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );
1688: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1696: FND_MSG_PUB.Count_And_Get

1692: END IF;
1693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1694: ROLLBACK TO CSD_SPLIT_PKG;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1696: FND_MSG_PUB.Count_And_Get
1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data
1699: );
1700: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1708: IF FND_MSG_PUB.Check_Msg_Level

1704: END IF;
1705: WHEN OTHERS THEN
1706: ROLLBACK TO CSD_SPLIT_PKG;
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1708: IF FND_MSG_PUB.Check_Msg_Level
1709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1710: THEN
1711: FND_MSG_PUB.Add_Exc_Msg
1712: ( G_PKG_NAME,

Line 1709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1705: WHEN OTHERS THEN
1706: ROLLBACK TO CSD_SPLIT_PKG;
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1708: IF FND_MSG_PUB.Check_Msg_Level
1709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1710: THEN
1711: FND_MSG_PUB.Add_Exc_Msg
1712: ( G_PKG_NAME,
1713: l_api_name

Line 1711: FND_MSG_PUB.Add_Exc_Msg

1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1708: IF FND_MSG_PUB.Check_Msg_Level
1709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1710: THEN
1711: FND_MSG_PUB.Add_Exc_Msg
1712: ( G_PKG_NAME,
1713: l_api_name
1714: );
1715: END IF;

Line 1716: FND_MSG_PUB.Count_And_Get

1712: ( G_PKG_NAME,
1713: l_api_name
1714: );
1715: END IF;
1716: FND_MSG_PUB.Count_And_Get
1717: ( p_count => x_msg_count,
1718: p_data => x_msg_data
1719: );
1720: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1840: FND_MSG_PUB.ADD;

1836:
1837: IF repair_line_dtls%notfound then
1838: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1839: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
1840: FND_MSG_PUB.ADD;
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:
1844: IF repair_line_dtls%isopen then