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 625: FND_MSG_PUB.ADD;

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

Line 772: FND_MSG_PUB.ADD;

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

Line 811: FND_MSG_PUB.initialize;

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

Line 817: FND_MSG_PUB.ADD;

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

Line 820: FND_MSG_PUB.Count_And_Get

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

Line 885: FND_MSG_PUB.initialize;

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

Line 891: FND_MSG_PUB.ADD;

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

Line 892: FND_MSG_PUB.Count_And_Get

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

Line 910: FND_MSG_PUB.ADD;

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

Line 912: FND_MSG_PUB.Count_And_Get

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

Line 936: FND_MSG_PUB.ADD;

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

Line 940: FND_MSG_PUB.ADD;

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

Line 944: FND_MSG_PUB.ADD;

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

Line 948: FND_MSG_PUB.ADD;

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

Line 951: FND_MSG_PUB.Count_And_Get

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

Line 966: FND_MSG_PUB.ADD;

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

Line 970: FND_MSG_PUB.ADD;

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

Line 974: FND_MSG_PUB.ADD;

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

Line 978: FND_MSG_PUB.Count_And_Get

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

Line 990: FND_MSG_PUB.ADD;

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

Line 997: FND_MSG_PUB.Count_And_Get

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

Line 1006: FND_MSG_PUB.Count_And_Get

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

Line 1018: FND_MSG_PUB.Count_And_Get

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

Line 1030: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1031: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1033: FND_MSG_PUB.Add_Exc_Msg

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

Line 1038: FND_MSG_PUB.Count_And_Get

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

Line 1086: FND_MSG_PUB.initialize;

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

Line 1300: FND_MSG_PUB.Count_And_Get

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

Line 1309: FND_MSG_PUB.Count_And_Get

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

Line 1321: FND_MSG_PUB.Count_And_Get

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

Line 1333: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1336: FND_MSG_PUB.Add_Exc_Msg

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

Line 1341: FND_MSG_PUB.Count_And_Get

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

Line 1385: FND_MSG_PUB.initialize;

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

Line 1447: FND_MSG_PUB.Count_And_Get

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

Line 1455: FND_MSG_PUB.Count_And_Get

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

Line 1467: FND_MSG_PUB.Count_And_Get

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

Line 1479: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1480: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1482: FND_MSG_PUB.Add_Exc_Msg

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

Line 1487: FND_MSG_PUB.Count_And_Get

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

Line 1546: FND_MSG_PUB.ADD;

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

Line 1598: FND_MSG_PUB.initialize;

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

Line 1673: FND_MSG_PUB.Count_And_Get

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

Line 1682: FND_MSG_PUB.Count_And_Get

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

Line 1694: FND_MSG_PUB.Count_And_Get

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

Line 1706: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1707: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1709: FND_MSG_PUB.Add_Exc_Msg

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

Line 1714: FND_MSG_PUB.Count_And_Get

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

Line 1838: FND_MSG_PUB.ADD;

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