[Home] [Help]
158: END IF;
159:
160: -- Initialize message list if p_init_msg_list is set to TRUE.
161: IF FND_API.to_Boolean( p_init_msg_list ) THEN
162: FND_MSG_PUB.initialize;
163: END IF;
164:
165: -- Initialize API return status to success
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
224: l_msg_index := 1;
225: l_msg_count := x_msg_count;
226: WHILE l_msg_count > 0 LOOP
227: x_msg_data := FND_MSG_PUB.GET
228: ( l_msg_index,
229: FND_API.G_FALSE );
230: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre API ');
231: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
269: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
270: l_msg_index := 1;
271: l_msg_count := x_msg_count;
272: WHILE l_msg_count > 0 LOOP
273: x_msg_data := FND_MSG_PUB.GET
274: ( l_msg_index,
275: FND_API.G_FALSE );
276: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre API ');
277: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
329: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
330: l_msg_index := 1;
331: l_msg_count := x_msg_count;
332: WHILE l_msg_count > 0 LOOP
333: x_msg_data := FND_MSG_PUB.GET
334: ( l_msg_index,
335: FND_API.G_FALSE );
336: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.. ');
337: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
368: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
369: l_msg_index := 1;
370: l_msg_count := x_msg_count;
371: WHILE l_msg_count > 0 LOOP
372: x_msg_data := FND_MSG_PUB.GET
373: ( l_msg_index,
374: FND_API.G_FALSE );
375: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
376: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
487: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
488: l_msg_index := 1;
489: l_msg_count := x_msg_count;
490: WHILE l_msg_count > 0 LOOP
491: x_msg_data := FND_MSG_PUB.GET
492: ( l_msg_index,
493: FND_API.G_FALSE );
494: csi_gen_utility_pvt.put_line( ' Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
495: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
527: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
528: l_msg_index := 1;
529: l_msg_count := x_msg_count;
530: WHILE l_msg_count > 0 LOOP
531: x_msg_data := FND_MSG_PUB.GET
532: ( l_msg_index,
533: FND_API.G_FALSE );
534: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PUB..');
535: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
568: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
569: l_msg_index := 1;
570: l_msg_count := x_msg_count;
571: WHILE l_msg_count > 0 LOOP
572: x_msg_data := FND_MSG_PUB.GET
573: ( l_msg_index,
574: FND_API.G_FALSE );
575:
576: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
609: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
610: l_msg_index := 1;
611: l_msg_count := x_msg_count;
612: WHILE l_msg_count > 0 LOOP
613: x_msg_data := FND_MSG_PUB.GET
614: ( l_msg_index,
615: FND_API.G_FALSE );
616:
617: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
649: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
650: l_msg_index := 1;
651: l_msg_count := x_msg_count;
652: WHILE l_msg_count > 0 LOOP
653: x_msg_data := FND_MSG_PUB.GET
654: ( l_msg_index,
655: FND_API.G_FALSE );
656: csi_gen_utility_pvt.put_line( ' Error from CSI_ASSET_PVT..');
657: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
672: (p_instance_rec.version_label = FND_API.G_MISS_CHAR)) THEN
673: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
674: IF l_version_label IS NULL THEN
675: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: ELSE
679: p_instance_rec.version_label := l_version_label;
680: END IF;
705: csi_gen_utility_pvt.put_line( ' Error from CSI_ITEM_INSTANCE_PVT.CREATE_VERSION_LABEL..');
706: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
707: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
708: FND_MESSAGE.SET_TOKEN('API_ERROR', 'CREATE_VERSION_LABEL');
709: FND_MSG_PUB.Add;
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:
713: -- End of addition by rtalluri for Bug 2256588 on 03/26/02
764: THEN
765: l_msg_index := 1;
766: l_msg_count := x_msg_count;
767: WHILE l_msg_count > 0 LOOP
768: x_msg_data := FND_MSG_PUB.GET
769: ( l_msg_index,
770: FND_API.G_FALSE
771: );
772: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
792: ,p_validation_mode => 'CREATE'
793: )
794: THEN
795: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
796: FND_MSG_PUB.Add;
797: RAISE fnd_api.g_exc_error;
798: END IF;
799:
800: BEGIN
813: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_NOT_IN_CZ');
814: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
815: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
816: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
817: FND_MSG_PUB.Add;
818: RAISE FND_API.G_EXC_ERROR;
819: END;
820:
821: IF l_component_ins_type='I'
829: ,x_return_status => x_return_status);
830:
831: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
832: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
833: FND_MSG_PUB.Add;
834: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837: END IF;
843: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
844: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
845: THEN
846: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
847: FND_MSG_PUB.Add;
848: RAISE fnd_api.g_exc_error;
849: END IF;
850: END IF;
851: -- End att enhancements
897: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: l_msg_index := 1;
899: l_msg_count := x_msg_count;
900: WHILE l_msg_count > 0 LOOP
901: x_msg_data := FND_MSG_PUB.GET
902: ( l_msg_index,
903: FND_API.G_FALSE );
904: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
905: csi_gen_utility_pvt.put_line( 'while updating config status');
949: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
950: l_msg_index := 1;
951: l_msg_count := x_msg_count;
952: WHILE l_msg_count > 0 LOOP
953: x_msg_data := FND_MSG_PUB.GET
954: ( l_msg_index,
955: FND_API.G_FALSE );
956: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
957: csi_gen_utility_pvt.put_line( 'while updating config status');
999: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1000: l_msg_index := 1;
1001: l_msg_count := x_msg_count;
1002: WHILE l_msg_count > 0 LOOP
1003: x_msg_data := FND_MSG_PUB.GET
1004: ( l_msg_index,
1005: FND_API.G_FALSE );
1006: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
1007: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1039: l_msg_index := 1;
1040: l_msg_count := x_msg_count;
1041:
1042: WHILE l_msg_count > 0 LOOP
1043: x_msg_data := FND_MSG_PUB.GET
1044: (l_msg_index,
1045: FND_API.G_FALSE );
1046: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
1047: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1080: l_msg_index := 1;
1081: l_msg_count := x_msg_count;
1082:
1083: WHILE l_msg_count > 0 LOOP
1084: x_msg_data := FND_MSG_PUB.GET
1085: (l_msg_index,
1086: FND_API.G_FALSE );
1087: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
1088: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1109: ****/
1110: -- End disable trace
1111:
1112: -- Standard call to get message count and if count is get message info.
1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count ,
1115: p_data => x_msg_data
1116: );
1117:
1143: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1144: l_msg_index := 1;
1145: l_msg_count := x_msg_count;
1146: WHILE l_msg_count > 0 LOOP
1147: x_msg_data := FND_MSG_PUB.GET
1148: ( l_msg_index,
1149: FND_API.G_FALSE );
1150: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post API ');
1151: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1169:
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR ;
1172: ROLLBACK TO create_item_instance;
1173: FND_MSG_PUB.Count_And_Get
1174: ( p_count => x_msg_count,
1175: p_data => x_msg_data
1176: );
1177:
1177:
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1180: ROLLBACK TO create_item_instance;
1181: FND_MSG_PUB.Count_And_Get
1182: ( p_count => x_msg_count,
1183: p_data => x_msg_data
1184: );
1185:
1185:
1186: WHEN OTHERS THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188: ROLLBACK TO create_item_instance;
1189: IF FND_MSG_PUB.Check_Msg_Level
1190: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1191: THEN
1192: FND_MSG_PUB.Add_Exc_Msg
1193: (G_PKG_NAME,
1186: WHEN OTHERS THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188: ROLLBACK TO create_item_instance;
1189: IF FND_MSG_PUB.Check_Msg_Level
1190: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1191: THEN
1192: FND_MSG_PUB.Add_Exc_Msg
1193: (G_PKG_NAME,
1194: l_api_name
1188: ROLLBACK TO create_item_instance;
1189: IF FND_MSG_PUB.Check_Msg_Level
1190: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1191: THEN
1192: FND_MSG_PUB.Add_Exc_Msg
1193: (G_PKG_NAME,
1194: l_api_name
1195: );
1196: END IF;
1193: (G_PKG_NAME,
1194: l_api_name
1195: );
1196: END IF;
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_count => x_msg_count,
1199: p_data => x_msg_data
1200: );
1201:
1434: END IF;
1435:
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1438: FND_MSG_PUB.initialize;
1439: END IF;
1440:
1441: -- Initialize API return status to success
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1479: --
1480: IF l_internal_party_id IS NULL THEN
1481: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: -- Begin Add Code for Siebel Genesis Project
1506: NULL;
1507: ELSE
1508: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_LOCKED');
1509: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_rec.instance_id);
1510: FND_MSG_PUB.ADD;
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513: END IF;
1514: END IF;
1540: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1541: l_msg_index := 1;
1542: l_msg_count := x_msg_count;
1543: WHILE l_msg_count > 0 LOOP
1544: x_msg_data := FND_MSG_PUB.GET
1545: ( l_msg_index,
1546: FND_API.G_FALSE );
1547: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Pre API ');
1548: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1587: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1588: l_msg_index := 1;
1589: l_msg_count := x_msg_count;
1590: WHILE l_msg_count > 0 LOOP
1591: x_msg_data := FND_MSG_PUB.GET
1592: ( l_msg_index,
1593: FND_API.G_FALSE );
1594: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Pre API ');
1595: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1906: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1907: l_msg_index := 1;
1908: l_msg_count := x_msg_count;
1909: WHILE l_msg_count > 0 LOOP
1910: x_msg_data := FND_MSG_PUB.GET
1911: ( l_msg_index,
1912: FND_API.G_FALSE );
1913: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
1914: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1946: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1947: l_msg_index := 1;
1948: l_msg_count := x_msg_count;
1949: WHILE l_msg_count > 0 LOOP
1950: x_msg_data := FND_MSG_PUB.GET
1951: ( l_msg_index,
1952: FND_API.G_FALSE
1953: );
1954: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1990: l_tmp_return_status := 'W';
1991: l_msg_index := 1;
1992: l_msg_count := x_msg_count;
1993: WHILE l_msg_count > 0 LOOP
1994: x_msg_data := FND_MSG_PUB.GET
1995: ( l_msg_index,
1996: FND_API.G_FALSE
1997: );
1998: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1998: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1999: l_msg_index := l_msg_index + 1;
2000: l_msg_count := l_msg_count - 1;
2001: END LOOP;
2002: FND_MSG_PUB.Count_And_Get
2003: ( p_count => x_msg_count,
2004: p_data => x_msg_data
2005: );
2006: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2006: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2007: l_msg_index := 1;
2008: l_msg_count := x_msg_count;
2009: WHILE l_msg_count > 0 LOOP
2010: x_msg_data := FND_MSG_PUB.GET
2011: ( l_msg_index,
2012: FND_API.G_FALSE
2013: );
2014: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2050: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2051: l_msg_index := 1;
2052: l_msg_count := x_msg_count;
2053: WHILE l_msg_count > 0 LOOP
2054: x_msg_data := FND_MSG_PUB.GET
2055: ( l_msg_index,
2056: FND_API.G_FALSE );
2057: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Post API ');
2058: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2260: l_msg_index := 1;
2261: l_msg_count := x_msg_count;
2262: WHILE l_msg_count > 0
2263: LOOP
2264: x_msg_data := FND_MSG_PUB.GET
2265: ( l_msg_index,
2266: FND_API.G_FALSE );
2267: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2268: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2332: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2333: l_msg_index := 1;
2334: l_msg_count := x_msg_count;
2335: WHILE l_msg_count > 0 LOOP
2336: x_msg_data := FND_MSG_PUB.GET
2337: ( l_msg_index,
2338: FND_API.G_FALSE );
2339: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2340: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2365: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2366: l_msg_index := 1;
2367: l_msg_count := x_msg_count;
2368: WHILE l_msg_count > 0 LOOP
2369: x_msg_data := FND_MSG_PUB.GET
2370: ( l_msg_index,
2371: FND_API.G_FALSE );
2372: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
2373: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2451: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2452: l_msg_index := 1;
2453: l_msg_count := x_msg_count;
2454: WHILE l_msg_count > 0 LOOP
2455: x_msg_data := FND_MSG_PUB.GET
2456: ( l_msg_index,
2457: FND_API.G_FALSE );
2458: csi_gen_utility_pvt.put_line( ' Error from CSI_ORGANIZATION_UNIT_PUB..');
2459: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2505: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2506: l_msg_index := 1;
2507: l_msg_count := x_msg_count;
2508: WHILE l_msg_count > 0 LOOP
2509: x_msg_data := FND_MSG_PUB.GET
2510: ( l_msg_index,
2511: FND_API.G_FALSE );
2512: csi_gen_utility_pvt.put_line( ' Error from CSI_PRICING_ATTRIBS_PUB..');
2513: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2567: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2568: l_msg_index := 1;
2569: l_msg_count := x_msg_count;
2570: WHILE l_msg_count > 0 LOOP
2571: x_msg_data := FND_MSG_PUB.GET
2572: ( l_msg_index,
2573: FND_API.G_FALSE );
2574: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2575: l_msg_index := l_msg_index + 1;
2627: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2628: l_msg_index := 1;
2629: l_msg_count := x_msg_count;
2630: WHILE l_msg_count > 0 LOOP
2631: x_msg_data := FND_MSG_PUB.GET
2632: ( l_msg_index,
2633: FND_API.G_FALSE );
2634: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2635: l_msg_index := l_msg_index + 1;
2680: ,p_validation_mode => 'UPDATE'
2681: )
2682: THEN
2683: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
2684: FND_MSG_PUB.Add;
2685: RAISE fnd_api.g_exc_error;
2686: END IF;
2687:
2688: BEGIN
2702: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
2703: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
2704: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
2705:
2706: FND_MSG_PUB.Add;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END;
2709:
2710: IF l_component_ins_type='I'
2719: ,x_return_status => x_return_status);
2720:
2721: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2722: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
2723: FND_MSG_PUB.Add;
2724: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
2725: RAISE FND_API.G_EXC_ERROR;
2726: END IF;
2727: END IF;
2734: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
2735: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
2736: THEN
2737: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
2738: FND_MSG_PUB.Add;
2739: RAISE fnd_api.g_exc_error;
2740: END IF;
2741: END IF;
2742: END IF;
2789: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2790: l_msg_index := 1;
2791: l_msg_count := x_msg_count;
2792: WHILE l_msg_count > 0 LOOP
2793: x_msg_data := FND_MSG_PUB.GET
2794: ( l_msg_index,
2795: FND_API.G_FALSE );
2796: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
2797: csi_gen_utility_pvt.put_line( 'while updating config status');
2840: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2841: l_msg_index := 1;
2842: l_msg_count := x_msg_count;
2843: WHILE l_msg_count > 0 LOOP
2844: x_msg_data := FND_MSG_PUB.GET
2845: ( l_msg_index,
2846: FND_API.G_FALSE );
2847: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
2848: csi_gen_utility_pvt.put_line( 'while updating config status');
2910: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2911: l_msg_index := 1;
2912: l_msg_count := x_msg_count;
2913: WHILE l_msg_count > 0 LOOP
2914: x_msg_data := FND_MSG_PUB.GET
2915: ( l_msg_index,
2916: FND_API.G_FALSE );
2917: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
2918: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2960: AND version_label = p_instance_rec.version_label
2961: AND ROWNUM=1;
2962:
2963: fnd_message.set_name('CSI','CSI_VERSION_LABEL_EXIST');
2964: fnd_msg_pub.add;
2965: RAISE fnd_api.g_exc_error;
2966: EXCEPTION
2967: WHEN NO_DATA_FOUND THEN
2968: NULL;
2988:
2989: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2990: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_CREATE_VERSION');
2991: FND_MESSAGE.SET_TOKEN('API_ERROR', 'CREATE_VERSION_LABEL');
2992: FND_MSG_PUB.Add;
2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995: END IF;
2996: END IF;
3104: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3105: l_msg_index := 1;
3106: l_msg_count := x_msg_count;
3107: WHILE l_msg_count > 0 LOOP
3108: x_msg_data := FND_MSG_PUB.GET
3109: ( l_msg_index,
3110: FND_API.G_FALSE
3111: );
3112: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3153: IF x_return_status = 'W' THEN -- Warning from OKS
3154: l_msg_index := 1;
3155: l_msg_count := x_msg_count;
3156: WHILE l_msg_count > 0 LOOP
3157: x_msg_data := FND_MSG_PUB.GET
3158: ( l_msg_index,
3159: FND_API.G_FALSE
3160: );
3161: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3161: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3162: l_msg_index := l_msg_index + 1;
3163: l_msg_count := l_msg_count - 1;
3164: END LOOP;
3165: FND_MSG_PUB.Count_And_Get
3166: ( p_count => x_msg_count,
3167: p_data => x_msg_data
3168: );
3169: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3169: ELSIF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3170: l_msg_index := 1;
3171: l_msg_count := x_msg_count;
3172: WHILE l_msg_count > 0 LOOP
3173: x_msg_data := FND_MSG_PUB.GET
3174: ( l_msg_index,
3175: FND_API.G_FALSE );
3176: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
3177: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3193: END IF;
3194: -- End disable trace
3195: ****/
3196: -- Standard call to get message count and if count is get message info.
3197: FND_MSG_PUB.Count_And_Get
3198: (p_count => x_msg_count ,
3199: p_data => x_msg_data
3200: );
3201:
3227: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3228: l_msg_index := 1;
3229: l_msg_count := x_msg_count;
3230: WHILE l_msg_count > 0 LOOP
3231: x_msg_data := FND_MSG_PUB.GET
3232: ( l_msg_index,
3233: FND_API.G_FALSE );
3234: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Post API ');
3235: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3295: l_msg_index := 1;
3296: l_msg_count := x_msg_count;
3297:
3298: WHILE l_msg_count > 0 LOOP
3299: x_msg_data := FND_MSG_PUB.GET
3300: (l_msg_index,
3301: FND_API.G_FALSE );
3302: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
3303: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3337: l_msg_index := 1;
3338: l_msg_count := x_msg_count;
3339:
3340: WHILE l_msg_count > 0 LOOP
3341: x_msg_data := FND_MSG_PUB.GET
3342: (l_msg_index,
3343: FND_API.G_FALSE );
3344: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
3345: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3393: l_msg_index := 1;
3394: l_msg_count := x_msg_count;
3395:
3396: WHILE l_msg_count > 0 LOOP
3397: x_msg_data := FND_MSG_PUB.GET
3398: (l_msg_index,
3399: FND_API.G_FALSE );
3400: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
3401: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3414: EXCEPTION
3415: WHEN FND_API.G_EXC_ERROR THEN
3416: ROLLBACK TO update_item_instance;
3417: x_return_status := FND_API.G_RET_STS_ERROR ;
3418: FND_MSG_PUB.Count_And_Get
3419: ( p_count => x_msg_count,
3420: p_data => x_msg_data
3421: );
3422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: );
3422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3423: ROLLBACK TO update_item_instance;
3424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3425: FND_MSG_PUB.Count_And_Get
3426: ( p_count => x_msg_count,
3427: p_data => x_msg_data
3428: );
3429: WHEN OTHERS THEN
3428: );
3429: WHEN OTHERS THEN
3430: ROLLBACK TO update_item_instance;
3431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3432: IF FND_MSG_PUB.Check_Msg_Level
3433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3434: THEN
3435: FND_MSG_PUB.Add_Exc_Msg
3436: ( G_PKG_NAME,
3429: WHEN OTHERS THEN
3430: ROLLBACK TO update_item_instance;
3431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3432: IF FND_MSG_PUB.Check_Msg_Level
3433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3434: THEN
3435: FND_MSG_PUB.Add_Exc_Msg
3436: ( G_PKG_NAME,
3437: l_api_name
3431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3432: IF FND_MSG_PUB.Check_Msg_Level
3433: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3434: THEN
3435: FND_MSG_PUB.Add_Exc_Msg
3436: ( G_PKG_NAME,
3437: l_api_name
3438: );
3439: END IF;
3436: ( G_PKG_NAME,
3437: l_api_name
3438: );
3439: END IF;
3440: FND_MSG_PUB.Count_And_Get
3441: ( p_count => x_msg_count,
3442: p_data => x_msg_data
3443: );
3444: END update_item_instance;
3553: END IF;
3554:
3555: -- Initialize message list if p_init_msg_list is set to TRUE.
3556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3557: FND_MSG_PUB.initialize;
3558: END IF;
3559:
3560: -- Initialize API return status to success
3561: x_return_status := FND_API.G_RET_STS_SUCCESS;
3607: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3608: l_msg_index := 1;
3609: l_msg_count := x_msg_count;
3610: WHILE l_msg_count > 0 LOOP
3611: x_msg_data := FND_MSG_PUB.GET
3612: ( l_msg_index,
3613: FND_API.G_FALSE );
3614: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Pre API ');
3615: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3646: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3647: l_msg_index := 1;
3648: l_msg_count := x_msg_count;
3649: WHILE l_msg_count > 0 LOOP
3650: x_msg_data := FND_MSG_PUB.GET
3651: ( l_msg_index,
3652: FND_API.G_FALSE );
3653: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Pre API ');
3654: 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: );
3691: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
3715: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3716: l_msg_index := 1;
3717: l_msg_count := x_msg_count;
3718: WHILE l_msg_count > 0 LOOP
3719: x_msg_data := FND_MSG_PUB.GET
3720: ( l_msg_index,
3721: FND_API.G_FALSE );
3722: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Post API ');
3723: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3762: ,p_validation_mode => 'UPDATE'
3763: )
3764: THEN
3765: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_KEY_EXISTS');
3766: FND_MSG_PUB.Add;
3767: RAISE fnd_api.g_exc_error;
3768: END IF;
3769:
3770: BEGIN
3784: FND_MESSAGE.SET_TOKEN('INSTANCE_HDR_ID',p_instance_rec.config_inst_hdr_id);
3785: FND_MESSAGE.SET_TOKEN('INSTANCE_REV_NBR',p_instance_rec.config_inst_rev_num);
3786: FND_MESSAGE.SET_TOKEN('CONFIG_ITEM_ID',p_instance_rec.config_inst_item_id);
3787:
3788: FND_MSG_PUB.Add;
3789: RAISE FND_API.G_EXC_ERROR;
3790: END;
3791:
3792: IF l_component_ins_type='I'
3801: ,x_return_status => x_return_status);
3802:
3803: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3804: FND_MESSAGE.SET_NAME('CSI','CSI_CONFIG_ERROR');
3805: FND_MSG_PUB.Add;
3806: csi_gen_utility_pvt.put_line('Call to batch validation has errored ');
3807: RAISE FND_API.G_EXC_ERROR;
3808: END IF;
3809: END IF;
3816: AND (p_instance_rec.config_inst_item_id IS NOT NULL AND p_instance_rec.config_inst_item_id <> fnd_api.g_miss_num)
3817: AND (p_instance_rec.config_inst_rev_num IS NULL OR p_instance_rec.config_inst_rev_num = fnd_api.g_miss_num))
3818: THEN
3819: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_CONFIG_COMB');
3820: FND_MSG_PUB.Add;
3821: RAISE fnd_api.g_exc_error;
3822: END IF;
3823: END IF;
3824: END IF;
3871: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3872: l_msg_index := 1;
3873: l_msg_count := x_msg_count;
3874: WHILE l_msg_count > 0 LOOP
3875: x_msg_data := FND_MSG_PUB.GET
3876: ( l_msg_index,
3877: FND_API.G_FALSE );
3878: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
3879: csi_gen_utility_pvt.put_line( 'while updating config status');
3922: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3923: l_msg_index := 1;
3924: l_msg_count := x_msg_count;
3925: WHILE l_msg_count > 0 LOOP
3926: x_msg_data := FND_MSG_PUB.GET
3927: ( l_msg_index,
3928: FND_API.G_FALSE );
3929: csi_gen_utility_pvt.put_line( 'Error from UPDATE_ITEM_INSTANCE_PVT..');
3930: csi_gen_utility_pvt.put_line( 'while updating config status');
3972: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3973: l_msg_index := 1;
3974: l_msg_count := x_msg_count;
3975: WHILE l_msg_count > 0 LOOP
3976: x_msg_data := FND_MSG_PUB.GET
3977: ( l_msg_index,
3978: FND_API.G_FALSE );
3979: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
3980: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3996: END IF;
3997: -- End disable trace
3998: ****/
3999: -- Standard call to get message count and if count is get message info.
4000: FND_MSG_PUB.Count_And_Get
4001: (p_count => x_msg_count ,
4002: p_data => x_msg_data );
4003: -- Call Post Vertical User Hook
4004: BEGIN
4021: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4022: l_msg_index := 1;
4023: l_msg_count := x_msg_count;
4024: WHILE l_msg_count > 0 LOOP
4025: x_msg_data := FND_MSG_PUB.GET
4026: ( l_msg_index,
4027: FND_API.G_FALSE );
4028: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Post API ');
4029: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4043: EXCEPTION
4044: WHEN FND_API.G_EXC_ERROR THEN
4045: ROLLBACK TO expire_item_instance;
4046: x_return_status := FND_API.G_RET_STS_ERROR ;
4047: FND_MSG_PUB.Count_And_Get
4048: ( p_count => x_msg_count,
4049: p_data => x_msg_data
4050: );
4051:
4051:
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: ROLLBACK TO expire_item_instance;
4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4055: FND_MSG_PUB.Count_And_Get
4056: ( p_count => x_msg_count,
4057: p_data => x_msg_data );
4058:
4059: WHEN OTHERS THEN
4058:
4059: WHEN OTHERS THEN
4060: ROLLBACK TO expire_item_instance;
4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4062: IF FND_MSG_PUB.Check_Msg_Level
4063: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4064: THEN
4065: FND_MSG_PUB.Add_Exc_Msg
4066: ( G_PKG_NAME, l_api_name );
4059: WHEN OTHERS THEN
4060: ROLLBACK TO expire_item_instance;
4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4062: IF FND_MSG_PUB.Check_Msg_Level
4063: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4064: THEN
4065: FND_MSG_PUB.Add_Exc_Msg
4066: ( G_PKG_NAME, l_api_name );
4067: END IF;
4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4062: IF FND_MSG_PUB.Check_Msg_Level
4063: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4064: THEN
4065: FND_MSG_PUB.Add_Exc_Msg
4066: ( G_PKG_NAME, l_api_name );
4067: END IF;
4068: FND_MSG_PUB.Count_And_Get
4069: ( p_count => x_msg_count,
4064: THEN
4065: FND_MSG_PUB.Add_Exc_Msg
4066: ( G_PKG_NAME, l_api_name );
4067: END IF;
4068: FND_MSG_PUB.Count_And_Get
4069: ( p_count => x_msg_count,
4070: p_data => x_msg_data );
4071:
4072: END expire_item_instance;
4139: END IF;
4140:
4141: -- Initialize message list if p_init_msg_list is set to TRUE.
4142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4143: FND_MSG_PUB.initialize;
4144: END IF;
4145:
4146: -- Initialize API return status to success
4147: x_return_status := FND_API.G_RET_STS_SUCCESS;
4225: AND (p_instance_query_rec.OPERATIONAL_STATUS_CODE = FND_API.G_MISS_CHAR) -- Addition of columns for FA Integration
4226: THEN
4227:
4228: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_ERROR;
4231:
4232: END IF;
4233:
4324: -- End disable trace
4325: ****/
4326:
4327: -- Standard call to get message count and if count is get message info.
4328: FND_MSG_PUB.Count_And_Get
4329: (p_count => x_msg_count ,
4330: p_data => x_msg_data
4331: );
4332:
4334:
4335: WHEN FND_API.G_EXC_ERROR THEN
4336: -- ROLLBACK TO get_item_instances;
4337: x_return_status := FND_API.G_RET_STS_ERROR ;
4338: FND_MSG_PUB.Count_And_Get
4339: ( p_count => x_msg_count,
4340: p_data => x_msg_data
4341: );
4342:
4342:
4343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4344: -- ROLLBACK TO get_item_instances;
4345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4346: FND_MSG_PUB.Count_And_Get
4347: ( p_count => x_msg_count,
4348: p_data => x_msg_data );
4349:
4350: WHEN OTHERS THEN
4349:
4350: WHEN OTHERS THEN
4351: -- ROLLBACK TO get_item_instances;
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4353: IF FND_MSG_PUB.Check_Msg_Level
4354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4355: THEN
4356: FND_MSG_PUB.Add_Exc_Msg
4357: ( G_PKG_NAME, l_api_name );
4350: WHEN OTHERS THEN
4351: -- ROLLBACK TO get_item_instances;
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4353: IF FND_MSG_PUB.Check_Msg_Level
4354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4355: THEN
4356: FND_MSG_PUB.Add_Exc_Msg
4357: ( G_PKG_NAME, l_api_name );
4358: END IF;
4352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4353: IF FND_MSG_PUB.Check_Msg_Level
4354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4355: THEN
4356: FND_MSG_PUB.Add_Exc_Msg
4357: ( G_PKG_NAME, l_api_name );
4358: END IF;
4359: FND_MSG_PUB.Count_And_Get
4360: ( p_count => x_msg_count,
4355: THEN
4356: FND_MSG_PUB.Add_Exc_Msg
4357: ( G_PKG_NAME, l_api_name );
4358: END IF;
4359: FND_MSG_PUB.Count_And_Get
4360: ( p_count => x_msg_count,
4361: p_data => x_msg_data );
4362:
4363: END get_item_instances;
4467: END IF;
4468:
4469: -- Initialize message list if p_init_msg_list is set to TRUE.
4470: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4471: FND_MSG_PUB.initialize;
4472: END IF;
4473:
4474:
4475: -- Initialize API return status to success
4554: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
4555: 'Please provide a valid datetime stamp.');
4556: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
4557: FND_MESSAGE.Set_Token('LAST_PURGE_DATE', l_last_purge_date);
4558: FND_MSG_PUB.ADD;
4559: END IF;
4560: IF (p_time_stamp <= sysdate) THEN
4561: -- construct from the history if the p_time_stamp
4562: -- is < than sysdate
4562: -- is < than sysdate
4563: csi_item_instance_pvt.Construct_inst_from_hist(p_instance_rec, l_time_stamp);
4564: ELSE
4565: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
4566: FND_MSG_PUB.ADD;
4567: RAISE FND_API.G_EXC_ERROR;
4568: END IF;
4569: END IF;
4570: --
4605: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4606: l_msg_index := 1;
4607: l_msg_count := x_msg_count;
4608: WHILE l_msg_count > 0 LOOP
4609: x_msg_data := FND_MSG_PUB.GET
4610: ( l_msg_index,
4611: FND_API.G_FALSE );
4612: csi_gen_utility_pvt.put_line( ' Error from csi_party_relationships_pub.get_inst_party_relationships.. ');
4613: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4643: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4644: l_msg_index := 1;
4645: l_msg_count := x_msg_count;
4646: WHILE l_msg_count > 0 LOOP
4647: x_msg_data := FND_MSG_PUB.GET
4648: ( l_msg_index,
4649: FND_API.G_FALSE );
4650: csi_gen_utility_pvt.put_line( ' Error from csi_party_relationships_pub.get_inst_party_accounts.. ');
4651: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4693: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4694: l_msg_index := 1;
4695: l_msg_count := x_msg_count;
4696: WHILE l_msg_count > 0 LOOP
4697: x_msg_data := FND_MSG_PUB.GET
4698: ( l_msg_index,
4699: FND_API.G_FALSE );
4700: csi_gen_utility_pvt.put_line( ' Error from csi_organization_unit_pub.get_organization_unit.. ');
4701: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4725: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4726: l_msg_index := 1;
4727: l_msg_count := x_msg_count;
4728: WHILE l_msg_count > 0 LOOP
4729: x_msg_data := FND_MSG_PUB.GET
4730: ( l_msg_index,
4731: FND_API.G_FALSE );
4732: csi_gen_utility_pvt.put_line( ' Error from csi_pricing_attribs_pub.get_pricing_attribs.. ');
4733: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4758: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4759: l_msg_index := 1;
4760: l_msg_count := x_msg_count;
4761: WHILE l_msg_count > 0 LOOP
4762: x_msg_data := FND_MSG_PUB.GET
4763: ( l_msg_index,
4764: FND_API.G_FALSE );
4765: csi_gen_utility_pvt.put_line( ' Error from get_extended_attrib_values.. ');
4766: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4791: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4792: l_msg_index := 1;
4793: l_msg_count := x_msg_count;
4794: WHILE l_msg_count > 0 LOOP
4795: x_msg_data := FND_MSG_PUB.GET
4796: ( l_msg_index,
4797: FND_API.G_FALSE );
4798: csi_gen_utility_pvt.put_line( ' Error from csi_asset_pvt.get_instance_assets.. ');
4799: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4821: -- End disable trace
4822: ****/
4823:
4824: -- Standard call to get message count and if count is get message info.
4825: FND_MSG_PUB.Count_And_Get
4826: (p_count => x_msg_count ,
4827: p_data => x_msg_data
4828: );
4829:
4832: WHEN FND_API.G_EXC_ERROR THEN
4833:
4834: -- ROLLBACK TO get_item_instance_details;
4835: x_return_status := FND_API.G_RET_STS_ERROR ;
4836: FND_MSG_PUB.Count_And_Get
4837: ( p_count => x_msg_count,
4838: p_data => x_msg_data
4839: );
4840:
4841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4842:
4843: -- ROLLBACK TO get_item_instance_details;
4844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4845: FND_MSG_PUB.Count_And_Get
4846: ( p_count => x_msg_count,
4847: p_data => x_msg_data
4848: );
4849: WHEN OTHERS THEN
4852: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4853: END IF;
4854: -- ROLLBACK TO get_item_instance_details;
4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4857: FND_MSG_PUB.Add_Exc_Msg
4858: ( G_PKG_NAME ,
4859: l_api_name );
4860: END IF;
4853: END IF;
4854: -- ROLLBACK TO get_item_instance_details;
4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4857: FND_MSG_PUB.Add_Exc_Msg
4858: ( G_PKG_NAME ,
4859: l_api_name );
4860: END IF;
4861: FND_MSG_PUB.Count_And_Get
4857: FND_MSG_PUB.Add_Exc_Msg
4858: ( G_PKG_NAME ,
4859: l_api_name );
4860: END IF;
4861: FND_MSG_PUB.Count_And_Get
4862: ( p_count => x_msg_count,
4863: p_data => x_msg_data );
4864:
4865: END get_item_instance_details;
4917: END IF;
4918:
4919: -- Initialize message list if p_init_msg_list is set to TRUE.
4920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4921: FND_MSG_PUB.initialize;
4922: END IF;
4923:
4924: -- Initialize API return status to success
4925: x_return_status := FND_API.G_RET_STS_SUCCESS;
4954: AND (p_version_label_query_rec.version_label = FND_API.G_MISS_CHAR)
4955: AND (p_version_label_query_rec.date_time_stamp = FND_API.G_MISS_DATE) THEN
4956:
4957: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_ERROR;
4960: END IF;
4961:
4962: -- Generate the where clause
4996: csi_item_instance_pvt.Construct_ver_from_hist(x_version_label_tbl, p_time_stamp);
4997: ELSE
4998: If (p_time_stamp <> fnd_api.g_miss_date and p_time_stamp > sysdate) THEN
4999: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
5000: FND_MSG_PUB.ADD;
5001: RAISE FND_API.G_EXC_ERROR;
5002: END IF;
5003: END IF;
5004:
5020: -- End disable trace
5021: ****/
5022:
5023: -- Standard call to get message count and if count is get message info.
5024: FND_MSG_PUB.Count_And_Get
5025: (p_count => x_msg_count ,
5026: p_data => x_msg_data);
5027:
5028: EXCEPTION
5028: EXCEPTION
5029: WHEN FND_API.G_EXC_ERROR THEN
5030: -- ROLLBACK TO get_version_label_pub;
5031: x_return_status := FND_API.G_RET_STS_ERROR ;
5032: FND_MSG_PUB.Count_And_Get
5033: ( p_count => x_msg_count,
5034: p_data => x_msg_data);
5035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5036: -- ROLLBACK TO get_version_label_pub;
5034: p_data => x_msg_data);
5035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5036: -- ROLLBACK TO get_version_label_pub;
5037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5038: FND_MSG_PUB.Count_And_Get
5039: ( p_count => x_msg_count,
5040: p_data => x_msg_data );
5041: WHEN OTHERS THEN
5042: -- ROLLBACK TO get_version_label_pub;
5040: p_data => x_msg_data );
5041: WHEN OTHERS THEN
5042: -- ROLLBACK TO get_version_label_pub;
5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5044: IF FND_MSG_PUB.Check_Msg_Level
5045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5046: THEN
5047: FND_MSG_PUB.Add_Exc_Msg
5048: ( G_PKG_NAME, l_api_name );
5041: WHEN OTHERS THEN
5042: -- ROLLBACK TO get_version_label_pub;
5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5044: IF FND_MSG_PUB.Check_Msg_Level
5045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5046: THEN
5047: FND_MSG_PUB.Add_Exc_Msg
5048: ( G_PKG_NAME, l_api_name );
5049: END IF;
5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5044: IF FND_MSG_PUB.Check_Msg_Level
5045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5046: THEN
5047: FND_MSG_PUB.Add_Exc_Msg
5048: ( G_PKG_NAME, l_api_name );
5049: END IF;
5050: FND_MSG_PUB.Count_And_Get
5051: ( p_count => x_msg_count,
5046: THEN
5047: FND_MSG_PUB.Add_Exc_Msg
5048: ( G_PKG_NAME, l_api_name );
5049: END IF;
5050: FND_MSG_PUB.Count_And_Get
5051: ( p_count => x_msg_count,
5052: p_data => x_msg_data);
5053: END get_version_labels;
5054:
5097: END IF;
5098:
5099: -- Initialize message list if p_init_msg_list is set to TRUE.
5100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5101: FND_MSG_PUB.initialize;
5102: END IF;
5103:
5104: -- Initialize API return status to success
5105: x_return_status := FND_API.G_RET_STS_SUCCESS;
5153: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5154: l_msg_index := 1;
5155: l_msg_count := x_msg_count;
5156: WHILE l_msg_count > 0 LOOP
5157: x_msg_data := FND_MSG_PUB.GET(
5158: l_msg_index,
5159: FND_API.G_FALSE);
5160: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5161: l_msg_index := l_msg_index + 1;
5183: -- End disable trace
5184: ****/
5185:
5186: -- Standard call to get message count and if count is get message info.
5187: FND_MSG_PUB.Count_And_Get
5188: (p_count => x_msg_count ,
5189: p_data => x_msg_data );
5190:
5191: EXCEPTION
5191: EXCEPTION
5192: WHEN FND_API.G_EXC_ERROR THEN
5193: ROLLBACK TO create_version_label_pub;
5194: x_return_status := FND_API.G_RET_STS_ERROR ;
5195: FND_MSG_PUB.Count_And_Get
5196: ( p_count => x_msg_count,
5197: p_data => x_msg_data );
5198:
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198:
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: ROLLBACK TO create_version_label_pub;
5201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5202: FND_MSG_PUB.Count_And_Get
5203: ( p_count => x_msg_count,
5204: p_data => x_msg_data );
5205: WHEN OTHERS THEN
5206: ROLLBACK TO create_version_label_pub;
5204: p_data => x_msg_data );
5205: WHEN OTHERS THEN
5206: ROLLBACK TO create_version_label_pub;
5207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5208: IF FND_MSG_PUB.Check_Msg_Level
5209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5210: THEN
5211: FND_MSG_PUB.Add_Exc_Msg
5212: ( G_PKG_NAME, l_api_name );
5205: WHEN OTHERS THEN
5206: ROLLBACK TO create_version_label_pub;
5207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5208: IF FND_MSG_PUB.Check_Msg_Level
5209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5210: THEN
5211: FND_MSG_PUB.Add_Exc_Msg
5212: ( G_PKG_NAME, l_api_name );
5213: END IF;
5207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5208: IF FND_MSG_PUB.Check_Msg_Level
5209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5210: THEN
5211: FND_MSG_PUB.Add_Exc_Msg
5212: ( G_PKG_NAME, l_api_name );
5213: END IF;
5214: FND_MSG_PUB.Count_And_Get
5215: ( p_count => x_msg_count,
5210: THEN
5211: FND_MSG_PUB.Add_Exc_Msg
5212: ( G_PKG_NAME, l_api_name );
5213: END IF;
5214: FND_MSG_PUB.Count_And_Get
5215: ( p_count => x_msg_count,
5216: p_data => x_msg_data);
5217: END create_version_label;
5218:
5264:
5265:
5266: -- Initialize message list if p_init_msg_list is set to TRUE.
5267: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5268: FND_MSG_PUB.initialize;
5269: END IF;
5270:
5271: -- Initialize API return status to success
5272: x_return_status := FND_API.G_RET_STS_SUCCESS;
5320: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5321: l_msg_index := 1;
5322: l_msg_count := x_msg_count;
5323: WHILE l_msg_count > 0 LOOP
5324: x_msg_data := FND_MSG_PUB.GET(
5325: l_msg_index,
5326: FND_API.G_FALSE );
5327: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5328: l_msg_index := l_msg_index + 1;
5348: -- End disable trace
5349: ****/
5350:
5351: -- Standard call to get message count and if count is get message info.
5352: FND_MSG_PUB.Count_And_Get
5353: (p_count => x_msg_count ,
5354: p_data => x_msg_data);
5355: EXCEPTION
5356: WHEN FND_API.G_EXC_ERROR THEN
5355: EXCEPTION
5356: WHEN FND_API.G_EXC_ERROR THEN
5357: ROLLBACK TO update_version_label_pub;
5358: x_return_status := FND_API.G_RET_STS_ERROR ;
5359: FND_MSG_PUB.Count_And_Get
5360: ( p_count => x_msg_count,
5361: p_data => x_msg_data);
5362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5363: ROLLBACK TO update_version_label_pub;
5361: p_data => x_msg_data);
5362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5363: ROLLBACK TO update_version_label_pub;
5364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5365: FND_MSG_PUB.Count_And_Get
5366: ( p_count => x_msg_count,
5367: p_data => x_msg_data);
5368: WHEN OTHERS THEN
5369: ROLLBACK TO update_version_label_pub;
5367: p_data => x_msg_data);
5368: WHEN OTHERS THEN
5369: ROLLBACK TO update_version_label_pub;
5370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5371: IF FND_MSG_PUB.Check_Msg_Level
5372: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5373: THEN
5374: FND_MSG_PUB.Add_Exc_Msg
5375: ( G_PKG_NAME, l_api_name );
5368: WHEN OTHERS THEN
5369: ROLLBACK TO update_version_label_pub;
5370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5371: IF FND_MSG_PUB.Check_Msg_Level
5372: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5373: THEN
5374: FND_MSG_PUB.Add_Exc_Msg
5375: ( G_PKG_NAME, l_api_name );
5376: END IF;
5370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5371: IF FND_MSG_PUB.Check_Msg_Level
5372: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5373: THEN
5374: FND_MSG_PUB.Add_Exc_Msg
5375: ( G_PKG_NAME, l_api_name );
5376: END IF;
5377: FND_MSG_PUB.Count_And_Get
5378: ( p_count => x_msg_count,
5373: THEN
5374: FND_MSG_PUB.Add_Exc_Msg
5375: ( G_PKG_NAME, l_api_name );
5376: END IF;
5377: FND_MSG_PUB.Count_And_Get
5378: ( p_count => x_msg_count,
5379: p_data => x_msg_data);
5380:
5381: END update_version_label;
5427: END IF;
5428:
5429: -- Initialize message list if p_init_msg_list is set to TRUE.
5430: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5431: FND_MSG_PUB.initialize;
5432: END IF;
5433:
5434: -- Initialize API return status to success
5435: x_return_status := FND_API.G_RET_STS_SUCCESS;
5478: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5479: l_msg_index := 1;
5480: l_msg_count := x_msg_count;
5481: WHILE l_msg_count > 0 LOOP
5482: x_msg_data := FND_MSG_PUB.GET(
5483: l_msg_index,
5484: FND_API.G_FALSE );
5485: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5486: l_msg_index := l_msg_index + 1;
5506: -- End disable trace
5507: ****/
5508:
5509: -- Standard call to get message count and if count is get message info.
5510: FND_MSG_PUB.Count_And_Get
5511: (p_count => x_msg_count ,
5512: p_data => x_msg_data );
5513: EXCEPTION
5514: WHEN FND_API.G_EXC_ERROR THEN
5513: EXCEPTION
5514: WHEN FND_API.G_EXC_ERROR THEN
5515: ROLLBACK TO expire_version_label_pub;
5516: x_return_status := FND_API.G_RET_STS_ERROR ;
5517: FND_MSG_PUB.Count_And_Get
5518: ( p_count => x_msg_count,
5519: p_data => x_msg_data);
5520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5521: ROLLBACK TO expire_version_label_pub;
5519: p_data => x_msg_data);
5520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5521: ROLLBACK TO expire_version_label_pub;
5522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5523: FND_MSG_PUB.Count_And_Get
5524: ( p_count => x_msg_count,
5525: p_data => x_msg_data);
5526: WHEN OTHERS THEN
5527: ROLLBACK TO expire_version_label_pub;
5525: p_data => x_msg_data);
5526: WHEN OTHERS THEN
5527: ROLLBACK TO expire_version_label_pub;
5528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5529: IF FND_MSG_PUB.Check_Msg_Level
5530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5531: THEN
5532: FND_MSG_PUB.Add_Exc_Msg
5533: ( G_PKG_NAME, l_api_name );
5526: WHEN OTHERS THEN
5527: ROLLBACK TO expire_version_label_pub;
5528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5529: IF FND_MSG_PUB.Check_Msg_Level
5530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5531: THEN
5532: FND_MSG_PUB.Add_Exc_Msg
5533: ( G_PKG_NAME, l_api_name );
5534: END IF;
5528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5529: IF FND_MSG_PUB.Check_Msg_Level
5530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5531: THEN
5532: FND_MSG_PUB.Add_Exc_Msg
5533: ( G_PKG_NAME, l_api_name );
5534: END IF;
5535: FND_MSG_PUB.Count_And_Get
5536: ( p_count => x_msg_count,
5531: THEN
5532: FND_MSG_PUB.Add_Exc_Msg
5533: ( G_PKG_NAME, l_api_name );
5534: END IF;
5535: FND_MSG_PUB.Count_And_Get
5536: ( p_count => x_msg_count,
5537: p_data => x_msg_data);
5538: END expire_version_label;
5539:
5740:
5741:
5742: -- Initialize message list if p_init_msg_list is set to TRUE.
5743: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5744: FND_MSG_PUB.initialize;
5745: END IF;
5746:
5747:
5748: -- Initialize API return status to success
5783: AND ( p_ext_attribs_query_rec.attribute_id = FND_API.G_MISS_NUM)
5784: THEN
5785:
5786: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
5787: FND_MSG_PUB.ADD;
5788: RAISE FND_API.G_EXC_ERROR;
5789: END IF;
5790:
5791:
5857: IF p_time_stamp <= sysdate THEN
5858: csi_item_instance_pvt.Construct_ext_From_Hist(x_ext_attrib_tbl, p_time_stamp);
5859: ELSE
5860: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
5861: FND_MSG_PUB.ADD;
5862: RAISE FND_API.G_EXC_ERROR;
5863: END IF;
5864: END IF;
5865:
5919: -- End disable trace
5920: ****/
5921:
5922: -- Standard call to get message count and if count is get message info.
5923: FND_MSG_PUB.Count_And_Get
5924: (p_count => x_msg_count ,
5925: p_data => x_msg_data
5926: );
5927:
5929: EXCEPTION
5930: WHEN FND_API.G_EXC_ERROR THEN
5931: -- ROLLBACK TO get_extended_attrib_values;
5932: x_return_status := FND_API.G_RET_STS_ERROR ;
5933: FND_MSG_PUB.Count_And_Get
5934: ( p_count => x_msg_count,
5935: p_data => x_msg_data
5936: );
5937:
5937:
5938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5939: -- ROLLBACK TO get_extended_attrib_values;
5940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5941: FND_MSG_PUB.Count_And_Get
5942: ( p_count => x_msg_count,
5943: p_data => x_msg_data
5944: );
5945:
5950:
5951: -- ROLLBACK TO get_extended_attrib_values;
5952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5953:
5954: IF FND_MSG_PUB.Check_Msg_Level
5955: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5956: THEN
5957: FND_MSG_PUB.Add_Exc_Msg
5958: ( g_pkg_name,
5951: -- ROLLBACK TO get_extended_attrib_values;
5952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5953:
5954: IF FND_MSG_PUB.Check_Msg_Level
5955: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5956: THEN
5957: FND_MSG_PUB.Add_Exc_Msg
5958: ( g_pkg_name,
5959: l_api_name
5953:
5954: IF FND_MSG_PUB.Check_Msg_Level
5955: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5956: THEN
5957: FND_MSG_PUB.Add_Exc_Msg
5958: ( g_pkg_name,
5959: l_api_name
5960: );
5961: END IF;
5959: l_api_name
5960: );
5961: END IF;
5962:
5963: FND_MSG_PUB.Count_And_Get
5964: ( p_count => x_msg_count,
5965: p_data => x_msg_data
5966: );
5967:
6016:
6017:
6018: -- Initialize message list if p_init_msg_list is set to TRUE.
6019: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6020: FND_MSG_PUB.initialize;
6021: END IF;
6022:
6023:
6024: -- Initialize API return status to success
6081: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6082: l_msg_index := 1;
6083: l_msg_count := x_msg_count;
6084: WHILE l_msg_count > 0 LOOP
6085: x_msg_data := FND_MSG_PUB.GET
6086: (l_msg_index,
6087: FND_API.G_FALSE );
6088:
6089: csi_gen_utility_pvt.put_line( ' Failed Pub:create_extended_attrib_values..');
6114: ****/
6115:
6116:
6117: -- Standard call to get message count and if count is get message info.
6118: FND_MSG_PUB.Count_And_Get
6119: (p_count => x_msg_count ,
6120: p_data => x_msg_data
6121: );
6122:
6125:
6126: WHEN FND_API.G_EXC_ERROR THEN
6127: ROLLBACK TO create_extended_attrib_values;
6128: x_return_status := FND_API.G_RET_STS_ERROR ;
6129: FND_MSG_PUB.Count_And_Get
6130: ( p_count => x_msg_count,
6131: p_data => x_msg_data
6132: );
6133:
6133:
6134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6135: ROLLBACK TO create_extended_attrib_values;
6136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6137: FND_MSG_PUB.Count_And_Get
6138: ( p_count => x_msg_count,
6139: p_data => x_msg_data
6140: );
6141:
6143:
6144: ROLLBACK TO create_extended_attrib_values;
6145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6146:
6147: IF FND_MSG_PUB.Check_Msg_Level
6148: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6149: THEN
6150: FND_MSG_PUB.Add_Exc_Msg
6151: ( g_pkg_name,
6144: ROLLBACK TO create_extended_attrib_values;
6145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6146:
6147: IF FND_MSG_PUB.Check_Msg_Level
6148: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6149: THEN
6150: FND_MSG_PUB.Add_Exc_Msg
6151: ( g_pkg_name,
6152: l_api_name
6146:
6147: IF FND_MSG_PUB.Check_Msg_Level
6148: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6149: THEN
6150: FND_MSG_PUB.Add_Exc_Msg
6151: ( g_pkg_name,
6152: l_api_name
6153: );
6154: END IF;
6152: l_api_name
6153: );
6154: END IF;
6155:
6156: FND_MSG_PUB.Count_And_Get
6157: ( p_count => x_msg_count,
6158: p_data => x_msg_data
6159: );
6160:
6209:
6210:
6211: -- Initialize message list if p_init_msg_list is set to TRUE.
6212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6213: FND_MSG_PUB.initialize;
6214: END IF;
6215:
6216:
6217: -- Initialize API return status to success
6271: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6272: l_msg_index := 1;
6273: l_msg_count := x_msg_count;
6274: WHILE l_msg_count > 0 LOOP
6275: x_msg_data := FND_MSG_PUB.GET
6276: (l_msg_index,
6277: FND_API.G_FALSE );
6278:
6279: csi_gen_utility_pvt.put_line( ' Failed Pub:update_extended_attrib_values..');
6303: -- End disable trace
6304: ****/
6305:
6306: -- Standard call to get message count and if count is get message info.
6307: FND_MSG_PUB.Count_And_Get
6308: (p_count => x_msg_count ,
6309: p_data => x_msg_data
6310: );
6311:
6314:
6315: WHEN FND_API.G_EXC_ERROR THEN
6316: ROLLBACK TO update_extended_attrib_values;
6317: x_return_status := FND_API.G_RET_STS_ERROR ;
6318: FND_MSG_PUB.Count_And_Get
6319: ( p_count => x_msg_count,
6320: p_data => x_msg_data
6321: );
6322:
6322:
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: ROLLBACK TO update_extended_attrib_values;
6325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6326: FND_MSG_PUB.Count_And_Get
6327: ( p_count => x_msg_count,
6328: p_data => x_msg_data
6329: );
6330:
6331: WHEN OTHERS THEN
6332: ROLLBACK TO update_extended_attrib_values;
6333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6334:
6335: IF FND_MSG_PUB.Check_Msg_Level
6336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6337: THEN
6338: FND_MSG_PUB.Add_Exc_Msg
6339: ( g_pkg_name ,
6332: ROLLBACK TO update_extended_attrib_values;
6333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6334:
6335: IF FND_MSG_PUB.Check_Msg_Level
6336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6337: THEN
6338: FND_MSG_PUB.Add_Exc_Msg
6339: ( g_pkg_name ,
6340: l_api_name
6334:
6335: IF FND_MSG_PUB.Check_Msg_Level
6336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6337: THEN
6338: FND_MSG_PUB.Add_Exc_Msg
6339: ( g_pkg_name ,
6340: l_api_name
6341: );
6342: END IF;
6340: l_api_name
6341: );
6342: END IF;
6343:
6344: FND_MSG_PUB.Count_And_Get
6345: ( p_count => x_msg_count,
6346: p_data => x_msg_data
6347: );
6348:
6393:
6394:
6395: -- Initialize message list if p_init_msg_list is set to TRUE.
6396: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6397: FND_MSG_PUB.initialize;
6398: END IF;
6399:
6400:
6401: -- Initialize API return status to success
6453: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6454: l_msg_index := 1;
6455: l_msg_count := x_msg_count;
6456: WHILE l_msg_count > 0 LOOP
6457: x_msg_data := FND_MSG_PUB.GET
6458: (l_msg_index,
6459: FND_API.G_FALSE );
6460:
6461: csi_gen_utility_pvt.put_line( ' Failed Pub:expire_extended_attrib_values..');
6486: ****/
6487:
6488:
6489: -- Standard call to get message count and if count is get message info.
6490: FND_MSG_PUB.Count_And_Get
6491: (p_count => x_msg_count ,
6492: p_data => x_msg_data
6493: );
6494:
6497:
6498: WHEN FND_API.G_EXC_ERROR THEN
6499: ROLLBACK TO delete_extended_attrib_values;
6500: x_return_status := FND_API.G_RET_STS_ERROR ;
6501: FND_MSG_PUB.Count_And_Get
6502: ( p_count => x_msg_count,
6503: p_data => x_msg_data
6504: );
6505:
6505:
6506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6507: ROLLBACK TO delete_extended_attrib_values;
6508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6509: FND_MSG_PUB.Count_And_Get
6510: ( p_count => x_msg_count,
6511: p_data => x_msg_data
6512: );
6513:
6514: WHEN OTHERS THEN
6515: ROLLBACK TO delete_extended_attrib_values;
6516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6517:
6518: IF FND_MSG_PUB.Check_Msg_Level
6519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6520: THEN
6521: FND_MSG_PUB.Add_Exc_Msg
6522: ( g_pkg_name ,
6515: ROLLBACK TO delete_extended_attrib_values;
6516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6517:
6518: IF FND_MSG_PUB.Check_Msg_Level
6519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6520: THEN
6521: FND_MSG_PUB.Add_Exc_Msg
6522: ( g_pkg_name ,
6523: l_api_name
6517:
6518: IF FND_MSG_PUB.Check_Msg_Level
6519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6520: THEN
6521: FND_MSG_PUB.Add_Exc_Msg
6522: ( g_pkg_name ,
6523: l_api_name
6524: );
6525: END IF;
6523: l_api_name
6524: );
6525: END IF;
6526:
6527: FND_MSG_PUB.Count_And_Get
6528: ( p_count => x_msg_count,
6529: p_data => x_msg_data
6530: );
6531:
6589: END IF;
6590:
6591: -- Initialize message list if p_init_msg_list is set to TRUE.
6592: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6593: FND_MSG_PUB.initialize;
6594: END IF;
6595:
6596: -- Initialize API return status to success
6597: x_return_status := FND_API.G_RET_STS_SUCCESS;
6652: );
6653:
6654: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6655: FOR i in 1..x_msg_Count LOOP
6656: FND_MSG_PUB.Get(p_msg_index => i,
6657: p_encoded => 'F',
6658: p_data => x_msg_data,
6659: p_msg_index_out => x_msg_index_out );
6660:
6672:
6673:
6674: -- Standard call to get message count and if count is get message info.
6675:
6676: FND_MSG_PUB.Count_And_Get
6677: (p_count => x_msg_count ,
6678: p_data => x_msg_data
6679: );
6680:
6682: EXCEPTION
6683: WHEN FND_API.G_EXC_ERROR THEN
6684: ROLLBACK TO copy_item_instance;
6685: x_return_status := FND_API.G_RET_STS_ERROR ;
6686: FND_MSG_PUB.Count_And_Get
6687: ( p_count => x_msg_count,
6688: p_data => x_msg_data
6689: );
6690:
6690:
6691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6692: ROLLBACK TO copy_item_instance;
6693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6694: FND_MSG_PUB.Count_And_Get
6695: ( p_count => x_msg_count,
6696: p_data => x_msg_data
6697: );
6698:
6698:
6699: WHEN OTHERS THEN
6700: ROLLBACK TO copy_item_instance;
6701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6702: IF FND_MSG_PUB.Check_Msg_Level
6703: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6704: THEN
6705: FND_MSG_PUB.Add_Exc_Msg
6706: ( G_PKG_NAME ,
6699: WHEN OTHERS THEN
6700: ROLLBACK TO copy_item_instance;
6701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6702: IF FND_MSG_PUB.Check_Msg_Level
6703: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6704: THEN
6705: FND_MSG_PUB.Add_Exc_Msg
6706: ( G_PKG_NAME ,
6707: l_api_name
6701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6702: IF FND_MSG_PUB.Check_Msg_Level
6703: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6704: THEN
6705: FND_MSG_PUB.Add_Exc_Msg
6706: ( G_PKG_NAME ,
6707: l_api_name
6708: );
6709: END IF;
6707: l_api_name
6708: );
6709: END IF;
6710:
6711: FND_MSG_PUB.Count_And_Get
6712: ( p_count => x_msg_count,
6713: p_data => x_msg_data
6714: );
6715:
6860: csi_gen_utility_pvt.put_line('Error from Call_to_contracts...');
6861: l_msg_index := 1;
6862: l_msg_count := x_msg_count;
6863: WHILE l_msg_count > 0 LOOP
6864: x_msg_data := FND_MSG_PUB.GET
6865: ( l_msg_index,
6866: FND_API.G_FALSE
6867: );
6868: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);