[Home] [Help]
159: END IF;
160:
161: -- Initialize message list if p_init_msg_list is set to TRUE.
162: IF FND_API.to_Boolean( p_init_msg_list ) THEN
163: FND_MSG_PUB.initialize;
164: END IF;
165:
166: -- Initialize API return status to success
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
225: l_msg_index := 1;
226: l_msg_count := x_msg_count;
227: WHILE l_msg_count > 0 LOOP
228: x_msg_data := FND_MSG_PUB.GET
229: ( l_msg_index,
230: FND_API.G_FALSE );
231: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre API ');
232: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
270: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
271: l_msg_index := 1;
272: l_msg_count := x_msg_count;
273: WHILE l_msg_count > 0 LOOP
274: x_msg_data := FND_MSG_PUB.GET
275: ( l_msg_index,
276: FND_API.G_FALSE );
277: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre API ');
278: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
330: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
331: l_msg_index := 1;
332: l_msg_count := x_msg_count;
333: WHILE l_msg_count > 0 LOOP
334: x_msg_data := FND_MSG_PUB.GET
335: ( l_msg_index,
336: FND_API.G_FALSE );
337: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
338: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
369: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
370: l_msg_index := 1;
371: l_msg_count := x_msg_count;
372: WHILE l_msg_count > 0 LOOP
373: x_msg_data := FND_MSG_PUB.GET
374: ( l_msg_index,
375: FND_API.G_FALSE );
376: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
377: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
488: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
489: l_msg_index := 1;
490: l_msg_count := x_msg_count;
491: WHILE l_msg_count > 0 LOOP
492: x_msg_data := FND_MSG_PUB.GET
493: ( l_msg_index,
494: FND_API.G_FALSE );
495: csi_gen_utility_pvt.put_line( ' Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
496: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
528: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
529: l_msg_index := 1;
530: l_msg_count := x_msg_count;
531: WHILE l_msg_count > 0 LOOP
532: x_msg_data := FND_MSG_PUB.GET
533: ( l_msg_index,
534: FND_API.G_FALSE );
535: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PUB..');
536: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
569: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
570: l_msg_index := 1;
571: l_msg_count := x_msg_count;
572: WHILE l_msg_count > 0 LOOP
573: x_msg_data := FND_MSG_PUB.GET
574: ( l_msg_index,
575: FND_API.G_FALSE );
576:
577: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
610: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
611: l_msg_index := 1;
612: l_msg_count := x_msg_count;
613: WHILE l_msg_count > 0 LOOP
614: x_msg_data := FND_MSG_PUB.GET
615: ( l_msg_index,
616: FND_API.G_FALSE );
617:
618: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
650: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
651: l_msg_index := 1;
652: l_msg_count := x_msg_count;
653: WHILE l_msg_count > 0 LOOP
654: x_msg_data := FND_MSG_PUB.GET
655: ( l_msg_index,
656: FND_API.G_FALSE );
657: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
658: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
673: (p_instance_rec.version_label = FND_API.G_MISS_CHAR)) THEN
674: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
675: IF l_version_label IS NULL THEN
676: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: p_instance_rec.version_label := l_version_label;
681: END IF;
706: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
707: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
708: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
709: FND_MESSAGE.SET_TOKEN('API_ERROR', 'CREATE_VERSION_LABEL');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713:
714: -- End of addition by rtalluri for Bug 2256588 on 03/26/02
776: THEN
777: l_msg_index := 1;
778: l_msg_count := x_msg_count;
779: WHILE l_msg_count > 0 LOOP
780: x_msg_data := FND_MSG_PUB.GET
781: ( l_msg_index,
782: FND_API.G_FALSE
783: );
784: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
804: ,p_validation_mode => 'CREATE'
805: )
806: THEN
807: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
808: FND_MSG_PUB.Add;
809: RAISE fnd_api.g_exc_error;
810: END IF;
811:
812: BEGIN
825: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_NOT_IN_CZ');
826: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
827: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
828: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
829: FND_MSG_PUB.Add;
830: RAISE FND_API.G_EXC_ERROR;
831: END;
832:
833: IF l_component_ins_type='I'
841: ,x_return_status => x_return_status);
842:
843: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
844: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
845: FND_MSG_PUB.Add;
846: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849: END IF;
855: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
856: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
857: THEN
858: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
859: FND_MSG_PUB.Add;
860: RAISE fnd_api.g_exc_error;
861: END IF;
862: END IF;
863: -- End att enhancements
909: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
910: l_msg_index := 1;
911: l_msg_count := x_msg_count;
912: WHILE l_msg_count > 0 LOOP
913: x_msg_data := FND_MSG_PUB.GET
914: ( l_msg_index,
915: FND_API.G_FALSE );
916: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
917: csi_gen_utility_pvt.put_line( 'while updating config status');
961: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
962: l_msg_index := 1;
963: l_msg_count := x_msg_count;
964: WHILE l_msg_count > 0 LOOP
965: x_msg_data := FND_MSG_PUB.GET
966: ( l_msg_index,
967: FND_API.G_FALSE );
968: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
969: csi_gen_utility_pvt.put_line( 'while updating config status');
1011: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1012: l_msg_index := 1;
1013: l_msg_count := x_msg_count;
1014: WHILE l_msg_count > 0 LOOP
1015: x_msg_data := FND_MSG_PUB.GET
1016: ( l_msg_index,
1017: FND_API.G_FALSE );
1018: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
1019: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1070: l_msg_index := 1;
1071: l_msg_count := x_msg_count;
1072:
1073: WHILE l_msg_count > 0 LOOP
1074: x_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1075: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
1076: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1077: l_msg_index := l_msg_index + 1;
1078: l_msg_count := l_msg_count - 1;
1097: l_msg_index := 1;
1098: l_msg_count := x_msg_count;
1099:
1100: WHILE l_msg_count > 0 LOOP
1101: x_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
1102: csi_gen_utility_pvt.put_line(' Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
1103: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1104: l_msg_index := l_msg_index + 1;
1105: l_msg_count := l_msg_count - 1;
1123: ****/
1124: -- End disable trace
1125:
1126: -- Standard call to get message count and if count is get message info.
1127: FND_MSG_PUB.Count_And_Get
1128: (p_encoded => FND_API.G_FALSE, --Added for bug 7657438
1129: p_count => x_msg_count ,
1130: p_data => x_msg_data
1131: );
1158: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1159: l_msg_index := 1;
1160: l_msg_count := x_msg_count;
1161: WHILE l_msg_count > 0 LOOP
1162: x_msg_data := FND_MSG_PUB.GET
1163: ( l_msg_index,
1164: FND_API.G_FALSE );
1165: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
1166: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: x_return_status := FND_API.G_RET_STS_ERROR ;
1187: ROLLBACK TO create_item_instance;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_encoded => FND_API.G_FALSE, --Added for bug 7657438
1190: p_count => x_msg_count,
1191: p_data => x_msg_data
1192: );
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1196: ROLLBACK TO create_item_instance;
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_encoded => FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );
1202:
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205: ROLLBACK TO create_item_instance;
1206: IF FND_MSG_PUB.Check_Msg_Level
1207: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1208: THEN
1209: FND_MSG_PUB.Add_Exc_Msg
1210: (G_PKG_NAME,
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205: ROLLBACK TO create_item_instance;
1206: IF FND_MSG_PUB.Check_Msg_Level
1207: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1208: THEN
1209: FND_MSG_PUB.Add_Exc_Msg
1210: (G_PKG_NAME,
1211: l_api_name
1205: ROLLBACK TO create_item_instance;
1206: IF FND_MSG_PUB.Check_Msg_Level
1207: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1208: THEN
1209: FND_MSG_PUB.Add_Exc_Msg
1210: (G_PKG_NAME,
1211: l_api_name
1212: );
1213: END IF;
1210: (G_PKG_NAME,
1211: l_api_name
1212: );
1213: END IF;
1214: FND_MSG_PUB.Count_And_Get
1215: ( p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1455: END IF;
1456:
1457: -- Initialize message list if p_init_msg_list is set to TRUE.
1458: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1459: FND_MSG_PUB.initialize;
1460: END IF;
1461:
1462: -- Initialize API return status to success
1463: x_return_status := FND_API.G_RET_STS_SUCCESS;
1499: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1500: --
1501: IF l_internal_party_id IS NULL THEN
1502: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF;
1506:
1507: -- Begin Add Code for Siebel Genesis Project
1573: NULL;
1574: ELSE
1575: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
1576: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580: END IF;
1581: END IF;
1607: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1608: l_msg_index := 1;
1609: l_msg_count := x_msg_count;
1610: WHILE l_msg_count > 0 LOOP
1611: x_msg_data := FND_MSG_PUB.GET
1612: ( l_msg_index,
1613: FND_API.G_FALSE );
1614: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Pre API ');
1615: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1654: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1655: l_msg_index := 1;
1656: l_msg_count := x_msg_count;
1657: WHILE l_msg_count > 0 LOOP
1658: x_msg_data := FND_MSG_PUB.GET
1659: ( l_msg_index,
1660: FND_API.G_FALSE );
1661: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Pre API ');
1662: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1988: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1989: l_msg_index := 1;
1990: l_msg_count := x_msg_count;
1991: WHILE l_msg_count > 0 LOOP
1992: x_msg_data := FND_MSG_PUB.GET
1993: ( l_msg_index,
1994: FND_API.G_FALSE );
1995: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
1996: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2028: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2029: l_msg_index := 1;
2030: l_msg_count := x_msg_count;
2031: WHILE l_msg_count > 0 LOOP
2032: x_msg_data := FND_MSG_PUB.GET
2033: ( l_msg_index,
2034: FND_API.G_FALSE
2035: );
2036: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2072: l_tmp_return_status := 'W';
2073: l_msg_index := 1;
2074: l_msg_count := x_msg_count;
2075: WHILE l_msg_count > 0 LOOP
2076: x_msg_data := FND_MSG_PUB.GET
2077: ( l_msg_index,
2078: FND_API.G_FALSE
2079: );
2080: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2080: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2081: l_msg_index := l_msg_index + 1;
2082: l_msg_count := l_msg_count - 1;
2083: END LOOP;
2084: FND_MSG_PUB.Count_And_Get
2085: ( p_encoded => FND_API.G_FALSE,
2086: p_count => x_msg_count,
2087: p_data => x_msg_data
2088: );
2089: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2090: l_msg_index := 1;
2091: l_msg_count := x_msg_count;
2092: WHILE l_msg_count > 0 LOOP
2093: x_msg_data := FND_MSG_PUB.GET
2094: ( l_msg_index,
2095: FND_API.G_FALSE
2096: );
2097: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2133: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2134: l_msg_index := 1;
2135: l_msg_count := x_msg_count;
2136: WHILE l_msg_count > 0 LOOP
2137: x_msg_data := FND_MSG_PUB.GET
2138: ( l_msg_index,
2139: FND_API.G_FALSE );
2140: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Post API ');
2141: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2343: l_msg_index := 1;
2344: l_msg_count := x_msg_count;
2345: WHILE l_msg_count > 0
2346: LOOP
2347: x_msg_data := FND_MSG_PUB.GET
2348: ( l_msg_index,
2349: FND_API.G_FALSE );
2350: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2351: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2415: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2416: l_msg_index := 1;
2417: l_msg_count := x_msg_count;
2418: WHILE l_msg_count > 0 LOOP
2419: x_msg_data := FND_MSG_PUB.GET
2420: ( l_msg_index,
2421: FND_API.G_FALSE );
2422: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2423: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2448: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2449: l_msg_index := 1;
2450: l_msg_count := x_msg_count;
2451: WHILE l_msg_count > 0 LOOP
2452: x_msg_data := FND_MSG_PUB.GET
2453: ( l_msg_index,
2454: FND_API.G_FALSE );
2455: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2456: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2534: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2535: l_msg_index := 1;
2536: l_msg_count := x_msg_count;
2537: WHILE l_msg_count > 0 LOOP
2538: x_msg_data := FND_MSG_PUB.GET
2539: ( l_msg_index,
2540: FND_API.G_FALSE );
2541: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PUB..');
2542: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2588: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2589: l_msg_index := 1;
2590: l_msg_count := x_msg_count;
2591: WHILE l_msg_count > 0 LOOP
2592: x_msg_data := FND_MSG_PUB.GET
2593: ( l_msg_index,
2594: FND_API.G_FALSE );
2595: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
2596: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2650: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2651: l_msg_index := 1;
2652: l_msg_count := x_msg_count;
2653: WHILE l_msg_count > 0 LOOP
2654: x_msg_data := FND_MSG_PUB.GET
2655: ( l_msg_index,
2656: FND_API.G_FALSE );
2657: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2658: l_msg_index := l_msg_index + 1;
2710: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2711: l_msg_index := 1;
2712: l_msg_count := x_msg_count;
2713: WHILE l_msg_count > 0 LOOP
2714: x_msg_data := FND_MSG_PUB.GET
2715: ( l_msg_index,
2716: FND_API.G_FALSE );
2717: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2718: l_msg_index := l_msg_index + 1;
2763: ,p_validation_mode => 'UPDATE'
2764: )
2765: THEN
2766: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
2767: FND_MSG_PUB.Add;
2768: RAISE fnd_api.g_exc_error;
2769: END IF;
2770:
2771: BEGIN
2785: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
2786: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
2787: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
2788:
2789: FND_MSG_PUB.Add;
2790: RAISE FND_API.G_EXC_ERROR;
2791: END;
2792:
2793: IF l_component_ins_type='I'
2802: ,x_return_status => x_return_status);
2803:
2804: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2805: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
2806: FND_MSG_PUB.Add;
2807: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
2808: RAISE FND_API.G_EXC_ERROR;
2809: END IF;
2810: END IF;
2817: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
2818: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
2819: THEN
2820: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
2821: FND_MSG_PUB.Add;
2822: RAISE fnd_api.g_exc_error;
2823: END IF;
2824: END IF;
2825: END IF;
2872: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2873: l_msg_index := 1;
2874: l_msg_count := x_msg_count;
2875: WHILE l_msg_count > 0 LOOP
2876: x_msg_data := FND_MSG_PUB.GET
2877: ( l_msg_index,
2878: FND_API.G_FALSE );
2879: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
2880: csi_gen_utility_pvt.put_line( 'while updating config status');
2923: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2924: l_msg_index := 1;
2925: l_msg_count := x_msg_count;
2926: WHILE l_msg_count > 0 LOOP
2927: x_msg_data := FND_MSG_PUB.GET
2928: ( l_msg_index,
2929: FND_API.G_FALSE );
2930: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
2931: csi_gen_utility_pvt.put_line( 'while updating config status');
2993: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2994: l_msg_index := 1;
2995: l_msg_count := x_msg_count;
2996: WHILE l_msg_count > 0 LOOP
2997: x_msg_data := FND_MSG_PUB.GET
2998: ( l_msg_index,
2999: FND_API.G_FALSE );
3000: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
3001: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3043: AND version_label = p_instance_rec.version_label
3044: AND ROWNUM=1;
3045:
3046: fnd_message.set_name('CSI','CSI_VERSION_LABEL_EXIST');
3047: fnd_msg_pub.add;
3048: RAISE fnd_api.g_exc_error;
3049: EXCEPTION
3050: WHEN NO_DATA_FOUND THEN
3051: NULL;
3071:
3072: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3073: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
3074: FND_MESSAGE.SET_TOKEN('API_ERROR', 'CREATE_VERSION_LABEL');
3075: FND_MSG_PUB.Add;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: END IF;
3079: END IF;
3211: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3212: l_msg_index := 1;
3213: l_msg_count := x_msg_count;
3214: WHILE l_msg_count > 0 LOOP
3215: x_msg_data := FND_MSG_PUB.GET
3216: ( l_msg_index,
3217: FND_API.G_FALSE
3218: );
3219: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3260: IF x_return_status = 'W' THEN -- Warning from OKS
3261: l_msg_index := 1;
3262: l_msg_count := x_msg_count;
3263: WHILE l_msg_count > 0 LOOP
3264: x_msg_data := FND_MSG_PUB.GET
3265: ( l_msg_index,
3266: FND_API.G_FALSE
3267: );
3268: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3268: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3269: l_msg_index := l_msg_index + 1;
3270: l_msg_count := l_msg_count - 1;
3271: END LOOP;
3272: FND_MSG_PUB.Count_And_Get
3273: ( p_encoded => FND_API.G_FALSE,
3274: p_count => x_msg_count,
3275: p_data => x_msg_data
3276: );
3277: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3278: l_msg_index := 1;
3279: l_msg_count := x_msg_count;
3280: WHILE l_msg_count > 0 LOOP
3281: x_msg_data := FND_MSG_PUB.GET
3282: ( l_msg_index,
3283: FND_API.G_FALSE );
3284: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
3285: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3301: END IF;
3302: -- End disable trace
3303: ****/
3304: -- Standard call to get message count and if count is get message info.
3305: FND_MSG_PUB.Count_And_Get
3306: (p_encoded => FND_API.G_FALSE,
3307: p_count => x_msg_count ,
3308: p_data => x_msg_data
3309: );
3335: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3336: l_msg_index := 1;
3337: l_msg_count := x_msg_count;
3338: WHILE l_msg_count > 0 LOOP
3339: x_msg_data := FND_MSG_PUB.GET
3340: ( l_msg_index,
3341: FND_API.G_FALSE );
3342: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Post API ');
3343: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3404: l_msg_index := 1;
3405: l_msg_count := x_msg_count;
3406:
3407: WHILE l_msg_count > 0 LOOP
3408: x_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3409: csi_gen_utility_pvt.put_line(' Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
3410: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3411: l_msg_index := l_msg_index + 1;
3412: l_msg_count := l_msg_count - 1;
3431: l_msg_index := 1;
3432: l_msg_count := x_msg_count;
3433:
3434: WHILE l_msg_count > 0 LOOP
3435: x_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
3436: csi_gen_utility_pvt.put_line(' Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
3437: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3438: l_msg_index := l_msg_index + 1;
3439: l_msg_count := l_msg_count - 1;
3448: EXCEPTION
3449: WHEN FND_API.G_EXC_ERROR THEN
3450: ROLLBACK TO update_item_instance;
3451: x_return_status := FND_API.G_RET_STS_ERROR ;
3452: FND_MSG_PUB.Count_And_Get
3453: (p_encoded => FND_API.G_FALSE,
3454: p_count => x_msg_count,
3455: p_data => x_msg_data
3456: );
3456: );
3457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3458: ROLLBACK TO update_item_instance;
3459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3460: FND_MSG_PUB.Count_And_Get
3461: ( p_encoded => FND_API.G_FALSE,
3462: p_count => x_msg_count,
3463: p_data => x_msg_data
3464: );
3464: );
3465: WHEN OTHERS THEN
3466: ROLLBACK TO update_item_instance;
3467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3468: IF FND_MSG_PUB.Check_Msg_Level
3469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470: THEN
3471: FND_MSG_PUB.Add_Exc_Msg
3472: ( G_PKG_NAME,
3465: WHEN OTHERS THEN
3466: ROLLBACK TO update_item_instance;
3467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3468: IF FND_MSG_PUB.Check_Msg_Level
3469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470: THEN
3471: FND_MSG_PUB.Add_Exc_Msg
3472: ( G_PKG_NAME,
3473: l_api_name
3467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3468: IF FND_MSG_PUB.Check_Msg_Level
3469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470: THEN
3471: FND_MSG_PUB.Add_Exc_Msg
3472: ( G_PKG_NAME,
3473: l_api_name
3474: );
3475: END IF;
3472: ( G_PKG_NAME,
3473: l_api_name
3474: );
3475: END IF;
3476: FND_MSG_PUB.Count_And_Get
3477: ( p_encoded => FND_API.G_FALSE,
3478: p_count => x_msg_count,
3479: p_data => x_msg_data
3480: );
3590: END IF;
3591:
3592: -- Initialize message list if p_init_msg_list is set to TRUE.
3593: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3594: FND_MSG_PUB.initialize;
3595: END IF;
3596:
3597: -- Initialize API return status to success
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3644: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3645: l_msg_index := 1;
3646: l_msg_count := x_msg_count;
3647: WHILE l_msg_count > 0 LOOP
3648: x_msg_data := FND_MSG_PUB.GET
3649: ( l_msg_index,
3650: FND_API.G_FALSE );
3651: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Pre API ');
3652: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3683: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3684: l_msg_index := 1;
3685: l_msg_count := x_msg_count;
3686: WHILE l_msg_count > 0 LOOP
3687: x_msg_data := FND_MSG_PUB.GET
3688: ( l_msg_index,
3689: FND_API.G_FALSE );
3690: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Pre API ');
3691: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3720: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3721: l_msg_index := 1;
3722: l_msg_count := x_msg_count;
3723: WHILE l_msg_count > 0 LOOP
3724: x_msg_data := FND_MSG_PUB.GET(
3725: l_msg_index,
3726: FND_API.G_FALSE
3727: );
3728: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
3753: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3754: l_msg_index := 1;
3755: l_msg_count := x_msg_count;
3756: WHILE l_msg_count > 0 LOOP
3757: x_msg_data := FND_MSG_PUB.GET
3758: ( l_msg_index,
3759: FND_API.G_FALSE );
3760: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Post API ');
3761: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3800: ,p_validation_mode => 'UPDATE'
3801: )
3802: THEN
3803: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
3804: FND_MSG_PUB.Add;
3805: RAISE fnd_api.g_exc_error;
3806: END IF;
3807:
3808: BEGIN
3822: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
3823: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
3824: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
3825:
3826: FND_MSG_PUB.Add;
3827: RAISE FND_API.G_EXC_ERROR;
3828: END;
3829:
3830: IF l_component_ins_type='I'
3839: ,x_return_status => x_return_status);
3840:
3841: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3842: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
3843: FND_MSG_PUB.Add;
3844: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
3845: RAISE FND_API.G_EXC_ERROR;
3846: END IF;
3847: END IF;
3854: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
3855: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
3856: THEN
3857: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
3858: FND_MSG_PUB.Add;
3859: RAISE fnd_api.g_exc_error;
3860: END IF;
3861: END IF;
3862: END IF;
3909: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3910: l_msg_index := 1;
3911: l_msg_count := x_msg_count;
3912: WHILE l_msg_count > 0 LOOP
3913: x_msg_data := FND_MSG_PUB.GET
3914: ( l_msg_index,
3915: FND_API.G_FALSE );
3916: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
3917: csi_gen_utility_pvt.put_line( 'while updating config status');
3960: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3961: l_msg_index := 1;
3962: l_msg_count := x_msg_count;
3963: WHILE l_msg_count > 0 LOOP
3964: x_msg_data := FND_MSG_PUB.GET
3965: ( l_msg_index,
3966: FND_API.G_FALSE );
3967: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
3968: csi_gen_utility_pvt.put_line( 'while updating config status');
4010: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4011: l_msg_index := 1;
4012: l_msg_count := x_msg_count;
4013: WHILE l_msg_count > 0 LOOP
4014: x_msg_data := FND_MSG_PUB.GET
4015: ( l_msg_index,
4016: FND_API.G_FALSE );
4017: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
4018: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4034: END IF;
4035: -- End disable trace
4036: ****/
4037: -- Standard call to get message count and if count is get message info.
4038: FND_MSG_PUB.Count_And_Get
4039: (p_encoded => FND_API.G_FALSE,
4040: p_count => x_msg_count ,
4041: p_data => x_msg_data );
4042: -- Call Post Vertical User Hook
4060: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4061: l_msg_index := 1;
4062: l_msg_count := x_msg_count;
4063: WHILE l_msg_count > 0 LOOP
4064: x_msg_data := FND_MSG_PUB.GET
4065: ( l_msg_index,
4066: FND_API.G_FALSE );
4067: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Post API ');
4068: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4082: EXCEPTION
4083: WHEN FND_API.G_EXC_ERROR THEN
4084: ROLLBACK TO expire_item_instance;
4085: x_return_status := FND_API.G_RET_STS_ERROR ;
4086: FND_MSG_PUB.Count_And_Get
4087: ( p_encoded => FND_API.G_FALSE,
4088: p_count => x_msg_count,
4089: p_data => x_msg_data
4090: );
4091:
4092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4093: ROLLBACK TO expire_item_instance;
4094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4095: FND_MSG_PUB.Count_And_Get
4096: ( p_encoded => FND_API.G_FALSE,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data );
4099:
4099:
4100: WHEN OTHERS THEN
4101: ROLLBACK TO expire_item_instance;
4102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4103: IF FND_MSG_PUB.Check_Msg_Level
4104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4105: THEN
4106: FND_MSG_PUB.Add_Exc_Msg
4107: ( G_PKG_NAME, l_api_name );
4100: WHEN OTHERS THEN
4101: ROLLBACK TO expire_item_instance;
4102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4103: IF FND_MSG_PUB.Check_Msg_Level
4104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4105: THEN
4106: FND_MSG_PUB.Add_Exc_Msg
4107: ( G_PKG_NAME, l_api_name );
4108: END IF;
4102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4103: IF FND_MSG_PUB.Check_Msg_Level
4104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4105: THEN
4106: FND_MSG_PUB.Add_Exc_Msg
4107: ( G_PKG_NAME, l_api_name );
4108: END IF;
4109: FND_MSG_PUB.Count_And_Get
4110: ( p_encoded => FND_API.G_FALSE,
4105: THEN
4106: FND_MSG_PUB.Add_Exc_Msg
4107: ( G_PKG_NAME, l_api_name );
4108: END IF;
4109: FND_MSG_PUB.Count_And_Get
4110: ( p_encoded => FND_API.G_FALSE,
4111: p_count => x_msg_count,
4112: p_data => x_msg_data );
4113:
4181: END IF;
4182:
4183: -- Initialize message list if p_init_msg_list is set to TRUE.
4184: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4185: FND_MSG_PUB.initialize;
4186: END IF;
4187:
4188: -- Initialize API return status to success
4189: x_return_status := FND_API.G_RET_STS_SUCCESS;
4267: AND (p_instance_query_rec.OPERATIONAL_STATUS_CODE = FND_API.G_MISS_CHAR) -- Addition of columns for FA Integration
4268: THEN
4269:
4270: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
4271: FND_MSG_PUB.ADD;
4272: RAISE FND_API.G_EXC_ERROR;
4273:
4274: END IF;
4275:
4366: -- End disable trace
4367: ****/
4368:
4369: -- Standard call to get message count and if count is get message info.
4370: FND_MSG_PUB.Count_And_Get
4371: (p_encoded => FND_API.G_FALSE,
4372: p_count => x_msg_count ,
4373: p_data => x_msg_data
4374: );
4377:
4378: WHEN FND_API.G_EXC_ERROR THEN
4379: -- ROLLBACK TO get_item_instances;
4380: x_return_status := FND_API.G_RET_STS_ERROR ;
4381: FND_MSG_PUB.Count_And_Get
4382: ( p_encoded => FND_API.G_FALSE,
4383: p_count => x_msg_count,
4384: p_data => x_msg_data
4385: );
4386:
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: -- ROLLBACK TO get_item_instances;
4389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4390: FND_MSG_PUB.Count_And_Get
4391: ( p_encoded => FND_API.G_FALSE,
4392: p_count => x_msg_count,
4393: p_data => x_msg_data );
4394:
4394:
4395: WHEN OTHERS THEN
4396: -- ROLLBACK TO get_item_instances;
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4398: IF FND_MSG_PUB.Check_Msg_Level
4399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4400: THEN
4401: FND_MSG_PUB.Add_Exc_Msg
4402: ( G_PKG_NAME, l_api_name );
4395: WHEN OTHERS THEN
4396: -- ROLLBACK TO get_item_instances;
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4398: IF FND_MSG_PUB.Check_Msg_Level
4399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4400: THEN
4401: FND_MSG_PUB.Add_Exc_Msg
4402: ( G_PKG_NAME, l_api_name );
4403: END IF;
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4398: IF FND_MSG_PUB.Check_Msg_Level
4399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4400: THEN
4401: FND_MSG_PUB.Add_Exc_Msg
4402: ( G_PKG_NAME, l_api_name );
4403: END IF;
4404: FND_MSG_PUB.Count_And_Get
4405: ( p_encoded => FND_API.G_FALSE,
4400: THEN
4401: FND_MSG_PUB.Add_Exc_Msg
4402: ( G_PKG_NAME, l_api_name );
4403: END IF;
4404: FND_MSG_PUB.Count_And_Get
4405: ( p_encoded => FND_API.G_FALSE,
4406: p_count => x_msg_count,
4407: p_data => x_msg_data );
4408:
4513: END IF;
4514:
4515: -- Initialize message list if p_init_msg_list is set to TRUE.
4516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4517: FND_MSG_PUB.initialize;
4518: END IF;
4519:
4520:
4521: -- Initialize API return status to success
4600: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
4601: 'Please provide a valid datetime stamp.');
4602: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
4603: FND_MESSAGE.Set_Token('LAST_PURGE_DATE', l_last_purge_date);
4604: FND_MSG_PUB.ADD;
4605: END IF;
4606: IF (p_time_stamp <= sysdate) THEN
4607: -- construct from the history if the p_time_stamp
4608: -- is < than sysdate
4608: -- is < than sysdate
4609: csi_item_instance_pvt.Construct_inst_from_hist(p_instance_rec, l_time_stamp);
4610: ELSE
4611: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
4612: FND_MSG_PUB.ADD;
4613: RAISE FND_API.G_EXC_ERROR;
4614: END IF;
4615: END IF;
4616: --
4651: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4652: l_msg_index := 1;
4653: l_msg_count := x_msg_count;
4654: WHILE l_msg_count > 0 LOOP
4655: x_msg_data := FND_MSG_PUB.GET
4656: ( l_msg_index,
4657: FND_API.G_FALSE );
4658: csi_gen_utility_pvt.put_line( ' Error from csi_party_relationships_pub.get_inst_party_relationships.. ');
4659: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4689: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4690: l_msg_index := 1;
4691: l_msg_count := x_msg_count;
4692: WHILE l_msg_count > 0 LOOP
4693: x_msg_data := FND_MSG_PUB.GET
4694: ( l_msg_index,
4695: FND_API.G_FALSE );
4696: csi_gen_utility_pvt.put_line( ' Error from csi_party_relationships_pub.get_inst_party_accounts.. ');
4697: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4739: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4740: l_msg_index := 1;
4741: l_msg_count := x_msg_count;
4742: WHILE l_msg_count > 0 LOOP
4743: x_msg_data := FND_MSG_PUB.GET
4744: ( l_msg_index,
4745: FND_API.G_FALSE );
4746: csi_gen_utility_pvt.put_line( ' Error from csi_organization_unit_pub.get_organization_unit.. ');
4747: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4771: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4772: l_msg_index := 1;
4773: l_msg_count := x_msg_count;
4774: WHILE l_msg_count > 0 LOOP
4775: x_msg_data := FND_MSG_PUB.GET
4776: ( l_msg_index,
4777: FND_API.G_FALSE );
4778: csi_gen_utility_pvt.put_line( ' Error from csi_pricing_attribs_pub.get_pricing_attribs.. ');
4779: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4804: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4805: l_msg_index := 1;
4806: l_msg_count := x_msg_count;
4807: WHILE l_msg_count > 0 LOOP
4808: x_msg_data := FND_MSG_PUB.GET
4809: ( l_msg_index,
4810: FND_API.G_FALSE );
4811: csi_gen_utility_pvt.put_line( ' Error from get_extended_attrib_values.. ');
4812: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4837: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4838: l_msg_index := 1;
4839: l_msg_count := x_msg_count;
4840: WHILE l_msg_count > 0 LOOP
4841: x_msg_data := FND_MSG_PUB.GET
4842: ( l_msg_index,
4843: FND_API.G_FALSE );
4844: csi_gen_utility_pvt.put_line( ' Error from csi_asset_pvt.get_instance_assets.. ');
4845: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4867: -- End disable trace
4868: ****/
4869:
4870: -- Standard call to get message count and if count is get message info.
4871: FND_MSG_PUB.Count_And_Get
4872: (p_encoded => FND_API.G_FALSE,
4873: p_count => x_msg_count ,
4874: p_data => x_msg_data
4875: );
4879: WHEN FND_API.G_EXC_ERROR THEN
4880:
4881: -- ROLLBACK TO get_item_instance_details;
4882: x_return_status := FND_API.G_RET_STS_ERROR ;
4883: FND_MSG_PUB.Count_And_Get
4884: ( p_encoded => FND_API.G_FALSE,
4885: p_count => x_msg_count,
4886: p_data => x_msg_data
4887: );
4889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4890:
4891: -- ROLLBACK TO get_item_instance_details;
4892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4893: FND_MSG_PUB.Count_And_Get
4894: ( p_encoded => FND_API.G_FALSE,
4895: p_count => x_msg_count,
4896: p_data => x_msg_data
4897: );
4901: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4902: END IF;
4903: -- ROLLBACK TO get_item_instance_details;
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4906: FND_MSG_PUB.Add_Exc_Msg
4907: ( G_PKG_NAME ,
4908: l_api_name );
4909: END IF;
4902: END IF;
4903: -- ROLLBACK TO get_item_instance_details;
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4906: FND_MSG_PUB.Add_Exc_Msg
4907: ( G_PKG_NAME ,
4908: l_api_name );
4909: END IF;
4910: FND_MSG_PUB.Count_And_Get
4906: FND_MSG_PUB.Add_Exc_Msg
4907: ( G_PKG_NAME ,
4908: l_api_name );
4909: END IF;
4910: FND_MSG_PUB.Count_And_Get
4911: ( p_encoded => FND_API.G_FALSE,
4912: p_count => x_msg_count,
4913: p_data => x_msg_data );
4914:
4969: END IF;
4970:
4971: -- Initialize message list if p_init_msg_list is set to TRUE.
4972: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4973: FND_MSG_PUB.initialize;
4974: END IF;
4975:
4976: -- Initialize API return status to success
4977: x_return_status := FND_API.G_RET_STS_SUCCESS;
5006: AND (p_version_label_query_rec.version_label = FND_API.G_MISS_CHAR)
5007: AND (p_version_label_query_rec.date_time_stamp = FND_API.G_MISS_DATE) THEN
5008:
5009: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
5010: FND_MSG_PUB.ADD;
5011: RAISE FND_API.G_EXC_ERROR;
5012: END IF;
5013:
5014: -- Generate the where clause
5048: csi_item_instance_pvt.Construct_ver_from_hist(x_version_label_tbl, p_time_stamp);
5049: ELSE
5050: If (p_time_stamp <> fnd_api.g_miss_date and p_time_stamp > sysdate) THEN
5051: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
5052: FND_MSG_PUB.ADD;
5053: RAISE FND_API.G_EXC_ERROR;
5054: END IF;
5055: END IF;
5056:
5072: -- End disable trace
5073: ****/
5074:
5075: -- Standard call to get message count and if count is get message info.
5076: FND_MSG_PUB.Count_And_Get
5077: (p_encoded => FND_API.G_FALSE,
5078: p_count => x_msg_count ,
5079: p_data => x_msg_data);
5080:
5081: EXCEPTION
5082: WHEN FND_API.G_EXC_ERROR THEN
5083: -- ROLLBACK TO get_version_label_pub;
5084: x_return_status := FND_API.G_RET_STS_ERROR ;
5085: FND_MSG_PUB.Count_And_Get
5086: ( p_encoded => FND_API.G_FALSE,
5087: p_count => x_msg_count,
5088: p_data => x_msg_data);
5089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5088: p_data => x_msg_data);
5089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5090: -- ROLLBACK TO get_version_label_pub;
5091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5092: FND_MSG_PUB.Count_And_Get
5093: ( p_encoded => FND_API.G_FALSE,
5094: p_count => x_msg_count,
5095: p_data => x_msg_data );
5096: WHEN OTHERS THEN
5095: p_data => x_msg_data );
5096: WHEN OTHERS THEN
5097: -- ROLLBACK TO get_version_label_pub;
5098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5099: IF FND_MSG_PUB.Check_Msg_Level
5100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5101: THEN
5102: FND_MSG_PUB.Add_Exc_Msg
5103: ( G_PKG_NAME, l_api_name );
5096: WHEN OTHERS THEN
5097: -- ROLLBACK TO get_version_label_pub;
5098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5099: IF FND_MSG_PUB.Check_Msg_Level
5100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5101: THEN
5102: FND_MSG_PUB.Add_Exc_Msg
5103: ( G_PKG_NAME, l_api_name );
5104: END IF;
5098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5099: IF FND_MSG_PUB.Check_Msg_Level
5100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5101: THEN
5102: FND_MSG_PUB.Add_Exc_Msg
5103: ( G_PKG_NAME, l_api_name );
5104: END IF;
5105: FND_MSG_PUB.Count_And_Get
5106: ( p_encoded => FND_API.G_FALSE,
5101: THEN
5102: FND_MSG_PUB.Add_Exc_Msg
5103: ( G_PKG_NAME, l_api_name );
5104: END IF;
5105: FND_MSG_PUB.Count_And_Get
5106: ( p_encoded => FND_API.G_FALSE,
5107: p_count => x_msg_count,
5108: p_data => x_msg_data);
5109: END get_version_labels;
5153: END IF;
5154:
5155: -- Initialize message list if p_init_msg_list is set to TRUE.
5156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5157: FND_MSG_PUB.initialize;
5158: END IF;
5159:
5160: -- Initialize API return status to success
5161: x_return_status := FND_API.G_RET_STS_SUCCESS;
5209: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5210: l_msg_index := 1;
5211: l_msg_count := x_msg_count;
5212: WHILE l_msg_count > 0 LOOP
5213: x_msg_data := FND_MSG_PUB.GET(
5214: l_msg_index,
5215: FND_API.G_FALSE);
5216: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5217: l_msg_index := l_msg_index + 1;
5239: -- End disable trace
5240: ****/
5241:
5242: -- Standard call to get message count and if count is get message info.
5243: FND_MSG_PUB.Count_And_Get
5244: (p_encoded => FND_API.G_FALSE,
5245: p_count => x_msg_count ,
5246: p_data => x_msg_data );
5247:
5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: ROLLBACK TO create_version_label_pub;
5251: x_return_status := FND_API.G_RET_STS_ERROR ;
5252: FND_MSG_PUB.Count_And_Get
5253: ( p_encoded => FND_API.G_FALSE,
5254: p_count => x_msg_count,
5255: p_data => x_msg_data );
5256:
5256:
5257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5258: ROLLBACK TO create_version_label_pub;
5259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5260: FND_MSG_PUB.Count_And_Get
5261: ( p_encoded => FND_API.G_FALSE,
5262: p_count => x_msg_count,
5263: p_data => x_msg_data );
5264: WHEN OTHERS THEN
5263: p_data => x_msg_data );
5264: WHEN OTHERS THEN
5265: ROLLBACK TO create_version_label_pub;
5266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5267: IF FND_MSG_PUB.Check_Msg_Level
5268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5269: THEN
5270: FND_MSG_PUB.Add_Exc_Msg
5271: ( G_PKG_NAME, l_api_name );
5264: WHEN OTHERS THEN
5265: ROLLBACK TO create_version_label_pub;
5266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5267: IF FND_MSG_PUB.Check_Msg_Level
5268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5269: THEN
5270: FND_MSG_PUB.Add_Exc_Msg
5271: ( G_PKG_NAME, l_api_name );
5272: END IF;
5266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5267: IF FND_MSG_PUB.Check_Msg_Level
5268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5269: THEN
5270: FND_MSG_PUB.Add_Exc_Msg
5271: ( G_PKG_NAME, l_api_name );
5272: END IF;
5273: FND_MSG_PUB.Count_And_Get
5274: ( p_encoded => FND_API.G_FALSE,
5269: THEN
5270: FND_MSG_PUB.Add_Exc_Msg
5271: ( G_PKG_NAME, l_api_name );
5272: END IF;
5273: FND_MSG_PUB.Count_And_Get
5274: ( p_encoded => FND_API.G_FALSE,
5275: p_count => x_msg_count,
5276: p_data => x_msg_data);
5277: END create_version_label;
5324:
5325:
5326: -- Initialize message list if p_init_msg_list is set to TRUE.
5327: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5328: FND_MSG_PUB.initialize;
5329: END IF;
5330:
5331: -- Initialize API return status to success
5332: x_return_status := FND_API.G_RET_STS_SUCCESS;
5380: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5381: l_msg_index := 1;
5382: l_msg_count := x_msg_count;
5383: WHILE l_msg_count > 0 LOOP
5384: x_msg_data := FND_MSG_PUB.GET(
5385: l_msg_index,
5386: FND_API.G_FALSE );
5387: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5388: l_msg_index := l_msg_index + 1;
5408: -- End disable trace
5409: ****/
5410:
5411: -- Standard call to get message count and if count is get message info.
5412: FND_MSG_PUB.Count_And_Get
5413: (p_encoded => FND_API.G_FALSE,
5414: p_count => x_msg_count ,
5415: p_data => x_msg_data);
5416: EXCEPTION
5416: EXCEPTION
5417: WHEN FND_API.G_EXC_ERROR THEN
5418: ROLLBACK TO update_version_label_pub;
5419: x_return_status := FND_API.G_RET_STS_ERROR ;
5420: FND_MSG_PUB.Count_And_Get
5421: ( p_encoded => FND_API.G_FALSE,
5422: p_count => x_msg_count,
5423: p_data => x_msg_data);
5424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5423: p_data => x_msg_data);
5424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5425: ROLLBACK TO update_version_label_pub;
5426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5427: FND_MSG_PUB.Count_And_Get
5428: ( p_encoded => FND_API.G_FALSE,
5429: p_count => x_msg_count,
5430: p_data => x_msg_data);
5431: WHEN OTHERS THEN
5430: p_data => x_msg_data);
5431: WHEN OTHERS THEN
5432: ROLLBACK TO update_version_label_pub;
5433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5434: IF FND_MSG_PUB.Check_Msg_Level
5435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5436: THEN
5437: FND_MSG_PUB.Add_Exc_Msg
5438: ( G_PKG_NAME, l_api_name );
5431: WHEN OTHERS THEN
5432: ROLLBACK TO update_version_label_pub;
5433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5434: IF FND_MSG_PUB.Check_Msg_Level
5435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5436: THEN
5437: FND_MSG_PUB.Add_Exc_Msg
5438: ( G_PKG_NAME, l_api_name );
5439: END IF;
5433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5434: IF FND_MSG_PUB.Check_Msg_Level
5435: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5436: THEN
5437: FND_MSG_PUB.Add_Exc_Msg
5438: ( G_PKG_NAME, l_api_name );
5439: END IF;
5440: FND_MSG_PUB.Count_And_Get
5441: ( p_encoded => FND_API.G_FALSE,
5436: THEN
5437: FND_MSG_PUB.Add_Exc_Msg
5438: ( G_PKG_NAME, l_api_name );
5439: END IF;
5440: FND_MSG_PUB.Count_And_Get
5441: ( p_encoded => FND_API.G_FALSE,
5442: p_count => x_msg_count,
5443: p_data => x_msg_data);
5444:
5491: END IF;
5492:
5493: -- Initialize message list if p_init_msg_list is set to TRUE.
5494: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5495: FND_MSG_PUB.initialize;
5496: END IF;
5497:
5498: -- Initialize API return status to success
5499: x_return_status := FND_API.G_RET_STS_SUCCESS;
5542: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5543: l_msg_index := 1;
5544: l_msg_count := x_msg_count;
5545: WHILE l_msg_count > 0 LOOP
5546: x_msg_data := FND_MSG_PUB.GET(
5547: l_msg_index,
5548: FND_API.G_FALSE );
5549: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5550: l_msg_index := l_msg_index + 1;
5570: -- End disable trace
5571: ****/
5572:
5573: -- Standard call to get message count and if count is get message info.
5574: FND_MSG_PUB.Count_And_Get
5575: (p_encoded => FND_API.G_FALSE,
5576: p_count => x_msg_count ,
5577: p_data => x_msg_data );
5578: EXCEPTION
5578: EXCEPTION
5579: WHEN FND_API.G_EXC_ERROR THEN
5580: ROLLBACK TO expire_version_label_pub;
5581: x_return_status := FND_API.G_RET_STS_ERROR ;
5582: FND_MSG_PUB.Count_And_Get
5583: ( p_encoded => FND_API.G_FALSE,
5584: p_count => x_msg_count,
5585: p_data => x_msg_data);
5586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5585: p_data => x_msg_data);
5586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5587: ROLLBACK TO expire_version_label_pub;
5588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5589: FND_MSG_PUB.Count_And_Get
5590: ( p_encoded => FND_API.G_FALSE,
5591: p_count => x_msg_count,
5592: p_data => x_msg_data);
5593: WHEN OTHERS THEN
5592: p_data => x_msg_data);
5593: WHEN OTHERS THEN
5594: ROLLBACK TO expire_version_label_pub;
5595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5596: IF FND_MSG_PUB.Check_Msg_Level
5597: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5598: THEN
5599: FND_MSG_PUB.Add_Exc_Msg
5600: ( G_PKG_NAME, l_api_name );
5593: WHEN OTHERS THEN
5594: ROLLBACK TO expire_version_label_pub;
5595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5596: IF FND_MSG_PUB.Check_Msg_Level
5597: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5598: THEN
5599: FND_MSG_PUB.Add_Exc_Msg
5600: ( G_PKG_NAME, l_api_name );
5601: END IF;
5595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5596: IF FND_MSG_PUB.Check_Msg_Level
5597: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5598: THEN
5599: FND_MSG_PUB.Add_Exc_Msg
5600: ( G_PKG_NAME, l_api_name );
5601: END IF;
5602: FND_MSG_PUB.Count_And_Get
5603: ( p_encoded => FND_API.G_FALSE,
5598: THEN
5599: FND_MSG_PUB.Add_Exc_Msg
5600: ( G_PKG_NAME, l_api_name );
5601: END IF;
5602: FND_MSG_PUB.Count_And_Get
5603: ( p_encoded => FND_API.G_FALSE,
5604: p_count => x_msg_count,
5605: p_data => x_msg_data);
5606: END expire_version_label;
5808:
5809:
5810: -- Initialize message list if p_init_msg_list is set to TRUE.
5811: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5812: FND_MSG_PUB.initialize;
5813: END IF;
5814:
5815:
5816: -- Initialize API return status to success
5851: AND ( p_ext_attribs_query_rec.attribute_id = FND_API.G_MISS_NUM)
5852: THEN
5853:
5854: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
5855: FND_MSG_PUB.ADD;
5856: RAISE FND_API.G_EXC_ERROR;
5857: END IF;
5858:
5859:
5925: IF p_time_stamp <= sysdate THEN
5926: csi_item_instance_pvt.Construct_ext_From_Hist(x_ext_attrib_tbl, p_time_stamp);
5927: ELSE
5928: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_ERROR;
5931: END IF;
5932: END IF;
5933:
5987: -- End disable trace
5988: ****/
5989:
5990: -- Standard call to get message count and if count is get message info.
5991: FND_MSG_PUB.Count_And_Get
5992: (p_encoded => FND_API.G_FALSE,
5993: p_count => x_msg_count ,
5994: p_data => x_msg_data
5995: );
5998: EXCEPTION
5999: WHEN FND_API.G_EXC_ERROR THEN
6000: -- ROLLBACK TO get_extended_attrib_values;
6001: x_return_status := FND_API.G_RET_STS_ERROR ;
6002: FND_MSG_PUB.Count_And_Get
6003: ( p_encoded => FND_API.G_FALSE,
6004: p_count => x_msg_count,
6005: p_data => x_msg_data
6006: );
6007:
6008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6009: -- ROLLBACK TO get_extended_attrib_values;
6010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6011: FND_MSG_PUB.Count_And_Get
6012: ( p_encoded => FND_API.G_FALSE,
6013: p_count => x_msg_count,
6014: p_data => x_msg_data
6015: );
6021:
6022: -- ROLLBACK TO get_extended_attrib_values;
6023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6024:
6025: IF FND_MSG_PUB.Check_Msg_Level
6026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: THEN
6028: FND_MSG_PUB.Add_Exc_Msg
6029: ( g_pkg_name,
6022: -- ROLLBACK TO get_extended_attrib_values;
6023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6024:
6025: IF FND_MSG_PUB.Check_Msg_Level
6026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: THEN
6028: FND_MSG_PUB.Add_Exc_Msg
6029: ( g_pkg_name,
6030: l_api_name
6024:
6025: IF FND_MSG_PUB.Check_Msg_Level
6026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: THEN
6028: FND_MSG_PUB.Add_Exc_Msg
6029: ( g_pkg_name,
6030: l_api_name
6031: );
6032: END IF;
6030: l_api_name
6031: );
6032: END IF;
6033:
6034: FND_MSG_PUB.Count_And_Get
6035: ( p_encoded => FND_API.G_FALSE,
6036: p_count => x_msg_count,
6037: p_data => x_msg_data
6038: );
6088:
6089:
6090: -- Initialize message list if p_init_msg_list is set to TRUE.
6091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6092: FND_MSG_PUB.initialize;
6093: END IF;
6094:
6095:
6096: -- Initialize API return status to success
6153: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6154: l_msg_index := 1;
6155: l_msg_count := x_msg_count;
6156: WHILE l_msg_count > 0 LOOP
6157: x_msg_data := FND_MSG_PUB.GET
6158: (l_msg_index,
6159: FND_API.G_FALSE );
6160:
6161: csi_gen_utility_pvt.put_line( ' Failed Pub:create_extended_attrib_values..');
6186: ****/
6187:
6188:
6189: -- Standard call to get message count and if count is get message info.
6190: FND_MSG_PUB.Count_And_Get
6191: (p_encoded => FND_API.G_FALSE,
6192: p_count => x_msg_count ,
6193: p_data => x_msg_data
6194: );
6198:
6199: WHEN FND_API.G_EXC_ERROR THEN
6200: ROLLBACK TO create_extended_attrib_values;
6201: x_return_status := FND_API.G_RET_STS_ERROR ;
6202: FND_MSG_PUB.Count_And_Get
6203: ( p_encoded => FND_API.G_FALSE,
6204: p_count => x_msg_count,
6205: p_data => x_msg_data
6206: );
6207:
6208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6209: ROLLBACK TO create_extended_attrib_values;
6210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6211: FND_MSG_PUB.Count_And_Get
6212: ( p_encoded => FND_API.G_FALSE,
6213: p_count => x_msg_count,
6214: p_data => x_msg_data
6215: );
6218:
6219: ROLLBACK TO create_extended_attrib_values;
6220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level
6223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6224: THEN
6225: FND_MSG_PUB.Add_Exc_Msg
6226: ( g_pkg_name,
6219: ROLLBACK TO create_extended_attrib_values;
6220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level
6223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6224: THEN
6225: FND_MSG_PUB.Add_Exc_Msg
6226: ( g_pkg_name,
6227: l_api_name
6221:
6222: IF FND_MSG_PUB.Check_Msg_Level
6223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6224: THEN
6225: FND_MSG_PUB.Add_Exc_Msg
6226: ( g_pkg_name,
6227: l_api_name
6228: );
6229: END IF;
6227: l_api_name
6228: );
6229: END IF;
6230:
6231: FND_MSG_PUB.Count_And_Get
6232: ( p_encoded => FND_API.G_FALSE,
6233: p_count => x_msg_count,
6234: p_data => x_msg_data
6235: );
6285:
6286:
6287: -- Initialize message list if p_init_msg_list is set to TRUE.
6288: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6289: FND_MSG_PUB.initialize;
6290: END IF;
6291:
6292:
6293: -- Initialize API return status to success
6347: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6348: l_msg_index := 1;
6349: l_msg_count := x_msg_count;
6350: WHILE l_msg_count > 0 LOOP
6351: x_msg_data := FND_MSG_PUB.GET
6352: (l_msg_index,
6353: FND_API.G_FALSE );
6354:
6355: csi_gen_utility_pvt.put_line( ' Failed Pub:update_extended_attrib_values..');
6379: -- End disable trace
6380: ****/
6381:
6382: -- Standard call to get message count and if count is get message info.
6383: FND_MSG_PUB.Count_And_Get
6384: (p_encoded => FND_API.G_FALSE,
6385: p_count => x_msg_count ,
6386: p_data => x_msg_data
6387: );
6391:
6392: WHEN FND_API.G_EXC_ERROR THEN
6393: ROLLBACK TO update_extended_attrib_values;
6394: x_return_status := FND_API.G_RET_STS_ERROR ;
6395: FND_MSG_PUB.Count_And_Get
6396: ( p_encoded => FND_API.G_FALSE,
6397: p_count => x_msg_count,
6398: p_data => x_msg_data
6399: );
6400:
6401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6402: ROLLBACK TO update_extended_attrib_values;
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6404: FND_MSG_PUB.Count_And_Get
6405: ( p_encoded => FND_API.G_FALSE,
6406: p_count => x_msg_count,
6407: p_data => x_msg_data
6408: );
6410: WHEN OTHERS THEN
6411: ROLLBACK TO update_extended_attrib_values;
6412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6413:
6414: IF FND_MSG_PUB.Check_Msg_Level
6415: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6416: THEN
6417: FND_MSG_PUB.Add_Exc_Msg
6418: ( g_pkg_name ,
6411: ROLLBACK TO update_extended_attrib_values;
6412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6413:
6414: IF FND_MSG_PUB.Check_Msg_Level
6415: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6416: THEN
6417: FND_MSG_PUB.Add_Exc_Msg
6418: ( g_pkg_name ,
6419: l_api_name
6413:
6414: IF FND_MSG_PUB.Check_Msg_Level
6415: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6416: THEN
6417: FND_MSG_PUB.Add_Exc_Msg
6418: ( g_pkg_name ,
6419: l_api_name
6420: );
6421: END IF;
6419: l_api_name
6420: );
6421: END IF;
6422:
6423: FND_MSG_PUB.Count_And_Get
6424: ( p_encoded => FND_API.G_FALSE,
6425: p_count => x_msg_count,
6426: p_data => x_msg_data
6427: );
6473:
6474:
6475: -- Initialize message list if p_init_msg_list is set to TRUE.
6476: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6477: FND_MSG_PUB.initialize;
6478: END IF;
6479:
6480:
6481: -- Initialize API return status to success
6533: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6534: l_msg_index := 1;
6535: l_msg_count := x_msg_count;
6536: WHILE l_msg_count > 0 LOOP
6537: x_msg_data := FND_MSG_PUB.GET
6538: (l_msg_index,
6539: FND_API.G_FALSE );
6540:
6541: csi_gen_utility_pvt.put_line( ' Failed Pub:expire_extended_attrib_values..');
6566: ****/
6567:
6568:
6569: -- Standard call to get message count and if count is get message info.
6570: FND_MSG_PUB.Count_And_Get
6571: (p_encoded => FND_API.G_FALSE,
6572: p_count => x_msg_count ,
6573: p_data => x_msg_data
6574: );
6578:
6579: WHEN FND_API.G_EXC_ERROR THEN
6580: ROLLBACK TO delete_extended_attrib_values;
6581: x_return_status := FND_API.G_RET_STS_ERROR ;
6582: FND_MSG_PUB.Count_And_Get
6583: ( p_encoded => FND_API.G_FALSE,
6584: p_count => x_msg_count,
6585: p_data => x_msg_data
6586: );
6587:
6588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6589: ROLLBACK TO delete_extended_attrib_values;
6590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6591: FND_MSG_PUB.Count_And_Get
6592: ( p_encoded => FND_API.G_FALSE,
6593: p_count => x_msg_count,
6594: p_data => x_msg_data
6595: );
6597: WHEN OTHERS THEN
6598: ROLLBACK TO delete_extended_attrib_values;
6599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6600:
6601: IF FND_MSG_PUB.Check_Msg_Level
6602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6603: THEN
6604: FND_MSG_PUB.Add_Exc_Msg
6605: ( g_pkg_name ,
6598: ROLLBACK TO delete_extended_attrib_values;
6599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6600:
6601: IF FND_MSG_PUB.Check_Msg_Level
6602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6603: THEN
6604: FND_MSG_PUB.Add_Exc_Msg
6605: ( g_pkg_name ,
6606: l_api_name
6600:
6601: IF FND_MSG_PUB.Check_Msg_Level
6602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6603: THEN
6604: FND_MSG_PUB.Add_Exc_Msg
6605: ( g_pkg_name ,
6606: l_api_name
6607: );
6608: END IF;
6606: l_api_name
6607: );
6608: END IF;
6609:
6610: FND_MSG_PUB.Count_And_Get
6611: ( p_encoded => FND_API.G_FALSE,
6612: p_count => x_msg_count,
6613: p_data => x_msg_data
6614: );
6673: END IF;
6674:
6675: -- Initialize message list if p_init_msg_list is set to TRUE.
6676: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6677: FND_MSG_PUB.initialize;
6678: END IF;
6679:
6680: -- Initialize API return status to success
6681: x_return_status := FND_API.G_RET_STS_SUCCESS;
6736: );
6737:
6738: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6739: FOR i in 1..x_msg_Count LOOP
6740: FND_MSG_PUB.Get(p_msg_index => i,
6741: p_encoded => 'F',
6742: p_data => x_msg_data,
6743: p_msg_index_out => x_msg_index_out );
6744:
6756:
6757:
6758: -- Standard call to get message count and if count is get message info.
6759:
6760: FND_MSG_PUB.Count_And_Get
6761: (p_encoded => FND_API.G_FALSE,
6762: p_count => x_msg_count ,
6763: p_data => x_msg_data
6764: );
6767: EXCEPTION
6768: WHEN FND_API.G_EXC_ERROR THEN
6769: ROLLBACK TO copy_item_instance;
6770: x_return_status := FND_API.G_RET_STS_ERROR ;
6771: FND_MSG_PUB.Count_And_Get
6772: ( p_encoded => FND_API.G_FALSE,
6773: p_count => x_msg_count,
6774: p_data => x_msg_data
6775: );
6776:
6777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6778: ROLLBACK TO copy_item_instance;
6779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6780: FND_MSG_PUB.Count_And_Get
6781: ( p_encoded => FND_API.G_FALSE,
6782: p_count => x_msg_count,
6783: p_data => x_msg_data
6784: );
6785:
6786: WHEN OTHERS THEN
6787: ROLLBACK TO copy_item_instance;
6788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6789: IF FND_MSG_PUB.Check_Msg_Level
6790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6791: THEN
6792: FND_MSG_PUB.Add_Exc_Msg
6793: ( G_PKG_NAME ,
6786: WHEN OTHERS THEN
6787: ROLLBACK TO copy_item_instance;
6788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6789: IF FND_MSG_PUB.Check_Msg_Level
6790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6791: THEN
6792: FND_MSG_PUB.Add_Exc_Msg
6793: ( G_PKG_NAME ,
6794: l_api_name
6788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6789: IF FND_MSG_PUB.Check_Msg_Level
6790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6791: THEN
6792: FND_MSG_PUB.Add_Exc_Msg
6793: ( G_PKG_NAME ,
6794: l_api_name
6795: );
6796: END IF;
6794: l_api_name
6795: );
6796: END IF;
6797:
6798: FND_MSG_PUB.Count_And_Get
6799: ( p_encoded => FND_API.G_FALSE,
6800: p_count => x_msg_count,
6801: p_data => x_msg_data
6802: );
6948: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
6949: l_msg_index := 1;
6950: l_msg_count := x_msg_count;
6951: WHILE l_msg_count > 0 LOOP
6952: x_msg_data := FND_MSG_PUB.GET
6953: ( l_msg_index,
6954: FND_API.G_FALSE
6955: );
6956: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);