eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_UTILITY_GRP dependencies on FND_API

Line 88: -- fnd_api.g_exc_error exception

84:
85: --
86: -- This procedure check if the installed base is active, If not active
87: -- populates the error message in the message queue and raises the
88: -- fnd_api.g_exc_error exception
89: --
90:
91: PROCEDURE check_ib_active
92: IS

Line 99: RAISE FND_API.G_Exc_Error;

95: -- has Pragma restriction. (Cursor optimization)
96: IF NOT csi_gen_utility_pvt.IB_ACTIVE THEN
97: FND_MESSAGE.Set_Name('CSI', 'CSI_IB_NOT_ACTIVE');
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_Exc_Error;
100: END IF;
101: EXCEPTION
102: WHEN fnd_api.g_exc_error THEN
103:

Line 102: WHEN fnd_api.g_exc_error THEN

98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_Exc_Error;
100: END IF;
101: EXCEPTION
102: WHEN fnd_api.g_exc_error THEN
103:
104: RAISE fnd_api.g_exc_error;
105:
106: WHEN others THEN

Line 104: RAISE fnd_api.g_exc_error;

100: END IF;
101: EXCEPTION
102: WHEN fnd_api.g_exc_error THEN
103:
104: RAISE fnd_api.g_exc_error;
105:
106: WHEN others THEN
107: FND_MESSAGE.Set_Name('CSI', 'CSI_UNEXP_SQL_ERROR');
108: FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');

Line 112: RAISE fnd_api.g_exc_error;

108: FND_MESSAGE.Set_Token('API_NAME', 'Check_IB_Active');
109: FND_MESSAGE.Set_Token('SQL_ERROR', sqlerrm);
110: FND_MSG_PUB.Add;
111:
112: RAISE fnd_api.g_exc_error;
113: END check_ib_active;
114:
115:
116: --

Line 125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

121: x_config_session_key OUT NOCOPY config_session_key,
122: x_return_status OUT NOCOPY varchar2,
123: x_return_message OUT NOCOPY varchar2)
124: IS
125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
126: l_session_key config_session_key;
127:
128: BEGIN
129: x_return_status := fnd_api.g_ret_sts_success;

Line 129: x_return_status := fnd_api.g_ret_sts_success;

125: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
126: l_session_key config_session_key;
127:
128: BEGIN
129: x_return_status := fnd_api.g_ret_sts_success;
130:
131: BEGIN
132: SELECT config_header_id,
133: config_rev_nbr,

Line 151: RAISE fnd_api.g_exc_error;

147:
148: EXCEPTION
149: WHEN no_data_found THEN
150: -- stack error message
151: RAISE fnd_api.g_exc_error;
152: END;
153:
154: EXCEPTION
155: WHEN fnd_api.g_exc_error THEN

Line 155: WHEN fnd_api.g_exc_error THEN

151: RAISE fnd_api.g_exc_error;
152: END;
153:
154: EXCEPTION
155: WHEN fnd_api.g_exc_error THEN
156: x_return_status := fnd_api.g_ret_sts_error;
157: END get_config_key_for_om_line;
158:
159: --

Line 156: x_return_status := fnd_api.g_ret_sts_error;

152: END;
153:
154: EXCEPTION
155: WHEN fnd_api.g_exc_error THEN
156: x_return_status := fnd_api.g_ret_sts_error;
157: END get_config_key_for_om_line;
158:
159: --
160: --

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166: x_return_message OUT NOCOPY varchar2)
167: IS
168: BEGIN
169:
170: x_return_status := fnd_api.g_ret_sts_success;
171:
172: BEGIN
173:
174: SELECT config_valid_status

Line 184: RAISE fnd_api.g_exc_error;

180: AND ctd.config_inst_item_id = p_instance_key.inst_item_id
181: AND ctl.transaction_line_id = ctd.transaction_line_id;
182: EXCEPTION
183: WHEN no_data_found THEN
184: RAISE fnd_api.g_exc_error;
185: END;
186:
187: --x_config_valid_status := 'VALID';
188:

Line 190: WHEN fnd_api.g_exc_error THEN

186:
187: --x_config_valid_status := 'VALID';
188:
189: EXCEPTION
190: WHEN fnd_api.g_exc_error THEN
191: x_return_status := fnd_api.g_ret_sts_error;
192: END get_config_inst_valid_status;
193:
194: FUNCTION is_network_component(

Line 191: x_return_status := fnd_api.g_ret_sts_error;

187: --x_config_valid_status := 'VALID';
188:
189: EXCEPTION
190: WHEN fnd_api.g_exc_error THEN
191: x_return_status := fnd_api.g_ret_sts_error;
192: END get_config_inst_valid_status;
193:
194: FUNCTION is_network_component(
195: p_order_line_id IN number,

Line 204: x_return_status := fnd_api.g_ret_sts_success;

200: l_return_status varchar2(1);
201: l_macd_flag boolean := FALSE;
202: BEGIN
203:
204: x_return_status := fnd_api.g_ret_sts_success;
205:
206: SELECT config_header_id,
207: config_rev_nbr,
208: configuration_id

Line 224: WHEN fnd_api.g_exc_error THEN

220: END IF;
221:
222: return l_macd_flag;
223: EXCEPTION
224: WHEN fnd_api.g_exc_error THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: END is_network_component;
227:
228: PROCEDURE vld_item_ctrl_changes (

Line 225: x_return_status := fnd_api.g_ret_sts_error;

221:
222: return l_macd_flag;
223: EXCEPTION
224: WHEN fnd_api.g_exc_error THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: END is_network_component;
227:
228: PROCEDURE vld_item_ctrl_changes (
229: p_api_version IN NUMBER

Line 230: ,p_commit IN VARCHAR2 := fnd_api.g_false

226: END is_network_component;
227:
228: PROCEDURE vld_item_ctrl_changes (
229: p_api_version IN NUMBER
230: ,p_commit IN VARCHAR2 := fnd_api.g_false
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
233: ,p_inventory_item_id IN NUMBER
234: ,p_organization_id IN NUMBER

Line 231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

227:
228: PROCEDURE vld_item_ctrl_changes (
229: p_api_version IN NUMBER
230: ,p_commit IN VARCHAR2 := fnd_api.g_false
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
233: ,p_inventory_item_id IN NUMBER
234: ,p_organization_id IN NUMBER
235: ,p_item_attr_name IN VARCHAR2

Line 232: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

228: PROCEDURE vld_item_ctrl_changes (
229: p_api_version IN NUMBER
230: ,p_commit IN VARCHAR2 := fnd_api.g_false
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
233: ,p_inventory_item_id IN NUMBER
234: ,p_organization_id IN NUMBER
235: ,p_item_attr_name IN VARCHAR2
236: ,p_new_item_attr_value IN VARCHAR2

Line 294: x_return_status := fnd_api.g_ret_sts_success;

290: END IF;
291: END IF;
292:
293: x_msg_data := NULL;
294: x_return_status := fnd_api.g_ret_sts_success;
295: x_msg_count := NULL;
296:
297: EXCEPTION
298: WHEN sfm_event_error THEN

Line 300: x_return_status := fnd_api.g_ret_sts_error;

296:
297: EXCEPTION
298: WHEN sfm_event_error THEN
299: fnd_message.set_name('CSI','CSI_IM_EXIST_SFM_ERROR');
300: x_return_status := fnd_api.g_ret_sts_error;
301: x_msg_count := 1;
302: x_msg_data := fnd_message.get;
303:
304: WHEN csi_exist_txn_error THEN

Line 306: x_return_status := fnd_api.g_ret_sts_error;

302: x_msg_data := fnd_message.get;
303:
304: WHEN csi_exist_txn_error THEN
305: fnd_message.set_name('CSI','CSI_IM_EXIST_ERROR');
306: x_return_status := fnd_api.g_ret_sts_error;
307: x_msg_count := 1;
308: x_msg_data := fnd_message.get;
309:
310: WHEN mtl_iface_error THEN

Line 312: x_return_status := fnd_api.g_ret_sts_error;

308: x_msg_data := fnd_message.get;
309:
310: WHEN mtl_iface_error THEN
311: fnd_message.set_name('CSI','CSI_IM_MTL_IFACE_ERROR');
312: x_return_status := fnd_api.g_ret_sts_error;
313: x_msg_count := 1;
314: x_msg_data := fnd_message.get;
315:
316: WHEN mtl_temp_error THEN

Line 318: x_return_status := fnd_api.g_ret_sts_error;

314: x_msg_data := fnd_message.get;
315:
316: WHEN mtl_temp_error THEN
317: fnd_message.set_name('CSI','CSI_IM_MTL_IFACE_TEMP');
318: x_return_status := fnd_api.g_ret_sts_error;
319: x_msg_count := 1;
320: x_msg_data := fnd_message.get;
321:
322: WHEN active_ib_inst_error THEN

Line 324: x_return_status := fnd_api.g_ret_sts_error;

320: x_msg_data := fnd_message.get;
321:
322: WHEN active_ib_inst_error THEN
323: fnd_message.set_name('CSI','CSI_IM_ACTIVE_IB_INST');
324: x_return_status := fnd_api.g_ret_sts_error;
325: x_msg_count := 1;
326: x_msg_data := fnd_message.get;
327:
328: END vld_item_ctrl_changes;

Line 831: p_commit IN VARCHAR2 := fnd_api.g_false,

827:
828: /********** End New Functions for Inventory MACD validations **********/
829:
830: PROCEDURE get_impacted_item_instances( p_api_version IN NUMBER,
831: p_commit IN VARCHAR2 := fnd_api.g_false,
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
833: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
834: x_txn_inst_tbl OUT NOCOPY TXN_INST_TBL,
835: p_txn_oks_rec IN TXN_OKS_REC,

Line 832: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

828: /********** End New Functions for Inventory MACD validations **********/
829:
830: PROCEDURE get_impacted_item_instances( p_api_version IN NUMBER,
831: p_commit IN VARCHAR2 := fnd_api.g_false,
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
833: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
834: x_txn_inst_tbl OUT NOCOPY TXN_INST_TBL,
835: p_txn_oks_rec IN TXN_OKS_REC,
836: x_return_status OUT NOCOPY VARCHAR2,

Line 833: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

829:
830: PROCEDURE get_impacted_item_instances( p_api_version IN NUMBER,
831: p_commit IN VARCHAR2 := fnd_api.g_false,
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
833: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
834: x_txn_inst_tbl OUT NOCOPY TXN_INST_TBL,
835: p_txn_oks_rec IN TXN_OKS_REC,
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864: BEGIN
865:
866: debug('Start of get_impacted_instances...');
867:
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: IF p_txn_oks_rec.batch_id IS NULL THEN -- Single Instance Usability
871:
872: l_txn_oks_rec := p_txn_oks_rec;

Line 935: WHEN fnd_api.g_exc_error THEN

931:
932: END IF;
933:
934: EXCEPTION
935: WHEN fnd_api.g_exc_error THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: x_msg_count := l_msg_count;
938: x_msg_data := l_msg_data;
939:

Line 936: x_return_status := FND_API.G_RET_STS_ERROR;

932: END IF;
933:
934: EXCEPTION
935: WHEN fnd_api.g_exc_error THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: x_msg_count := l_msg_count;
938: x_msg_data := l_msg_data;
939:
940: WHEN others THEN

Line 945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

941: l_sql_error := SQLERRM;
942: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
943: fnd_message.set_token('API_NAME',l_api_name);
944: fnd_message.set_token('SQL_ERROR',l_sql_error);
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: x_msg_count := 1;
947: x_msg_data := fnd_message.get;
948:
949: END get_impacted_item_instances;

Line 967: l_get_dfs VARCHAR2(1) := FND_API.G_TRUE;

963: l_active_relationship_only VARCHAR2(1);
964: l_active_instances_only VARCHAR2(1);
965: l_config_only VARCHAR2(1); -- if true will retrieve instances with config keys
966: l_time_stamp DATE;
967: l_get_dfs VARCHAR2(1) := FND_API.G_TRUE;
968: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
969: l_return_status VARCHAR2(1);
970: l_error_message VARCHAR2(2000);
971: l_sql_error VARCHAR2(2000);

Line 1070: fnd_api.g_true, --l_active_relationship_only

1066: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
1067: csi_ii_relationships_pvt.Get_Children (l_relationship_query_rec ,
1068: l_rel_tbl ,
1069: NULL, --l_depth
1070: fnd_api.g_true, --l_active_relationship_only
1071: fnd_api.g_true, --l_active_instances_only
1072: fnd_api.g_false, --
1073: NULL,
1074: l_get_dfs ,

Line 1071: fnd_api.g_true, --l_active_instances_only

1067: csi_ii_relationships_pvt.Get_Children (l_relationship_query_rec ,
1068: l_rel_tbl ,
1069: NULL, --l_depth
1070: fnd_api.g_true, --l_active_relationship_only
1071: fnd_api.g_true, --l_active_instances_only
1072: fnd_api.g_false, --
1073: NULL,
1074: l_get_dfs ,
1075: l_ii_relationship_level_tbl ,

Line 1072: fnd_api.g_false, --

1068: l_rel_tbl ,
1069: NULL, --l_depth
1070: fnd_api.g_true, --l_active_relationship_only
1071: fnd_api.g_true, --l_active_instances_only
1072: fnd_api.g_false, --
1073: NULL,
1074: l_get_dfs ,
1075: l_ii_relationship_level_tbl ,
1076: x_return_status ,

Line 1082: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1078: x_msg_data );
1079:
1080: debug(' Does this instance have any children? ('||l_rel_tbl.count||')');
1081:
1082: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1083: l_msg_index := 1;
1084: WHILE l_msg_count > 0 loop
1085: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1086: l_msg_index := l_msg_index + 1;

Line 1085: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1081:
1082: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1083: l_msg_index := 1;
1084: WHILE l_msg_count > 0 loop
1085: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1086: l_msg_index := l_msg_index + 1;
1087: l_msg_count := l_msg_count - 1;
1088: END LOOP;
1089: RAISE fnd_api.g_exc_error;

Line 1089: RAISE fnd_api.g_exc_error;

1085: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1086: l_msg_index := l_msg_index + 1;
1087: l_msg_count := l_msg_count - 1;
1088: END LOOP;
1089: RAISE fnd_api.g_exc_error;
1090: END IF;
1091:
1092:
1093: IF l_rel_tbl.count = 0 THEN

Line 1216: fnd_api.g_true, --l_active_relationship_only

1212:
1213: csi_ii_relationships_pvt.Get_Children (l_relationship_query_rec ,
1214: l_rel_tbl ,
1215: NULL, --l_depth
1216: fnd_api.g_true, --l_active_relationship_only
1217: fnd_api.g_true, --l_active_instances_only
1218: fnd_api.g_false, --
1219: NULL,
1220: l_get_dfs ,

Line 1217: fnd_api.g_true, --l_active_instances_only

1213: csi_ii_relationships_pvt.Get_Children (l_relationship_query_rec ,
1214: l_rel_tbl ,
1215: NULL, --l_depth
1216: fnd_api.g_true, --l_active_relationship_only
1217: fnd_api.g_true, --l_active_instances_only
1218: fnd_api.g_false, --
1219: NULL,
1220: l_get_dfs ,
1221: l_ii_relationship_level_tbl ,

Line 1218: fnd_api.g_false, --

1214: l_rel_tbl ,
1215: NULL, --l_depth
1216: fnd_api.g_true, --l_active_relationship_only
1217: fnd_api.g_true, --l_active_instances_only
1218: fnd_api.g_false, --
1219: NULL,
1220: l_get_dfs ,
1221: l_ii_relationship_level_tbl ,
1222: x_return_status ,

Line 1226: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1222: x_return_status ,
1223: x_msg_count ,
1224: x_msg_data );
1225:
1226: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1227: l_msg_index := 1;
1228: WHILE l_msg_count > 0 loop
1229: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1230: l_msg_index := l_msg_index + 1;

Line 1229: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);

1225:
1226: IF NOT l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1227: l_msg_index := 1;
1228: WHILE l_msg_count > 0 loop
1229: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1230: l_msg_index := l_msg_index + 1;
1231: l_msg_count := l_msg_count - 1;
1232: END LOOP;
1233: RAISE fnd_api.g_exc_error;

Line 1233: RAISE fnd_api.g_exc_error;

1229: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1230: l_msg_index := l_msg_index + 1;
1231: l_msg_count := l_msg_count - 1;
1232: END LOOP;
1233: RAISE fnd_api.g_exc_error;
1234: END IF;
1235:
1236: IF l_rel_tbl.count = 0 THEN
1237: debug(' No Children so just add this instance to the out table');

Line 1323: WHEN fnd_api.g_exc_error THEN

1319:
1320: END IF; -- Batch ID
1321:
1322: EXCEPTION
1323: WHEN fnd_api.g_exc_error THEN
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: x_msg_count := l_msg_count;
1326: x_msg_data := l_msg_data;
1327:

Line 1324: x_return_status := FND_API.G_RET_STS_ERROR;

1320: END IF; -- Batch ID
1321:
1322: EXCEPTION
1323: WHEN fnd_api.g_exc_error THEN
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: x_msg_count := l_msg_count;
1326: x_msg_data := l_msg_data;
1327:
1328: WHEN others THEN

Line 1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1329: l_sql_error := SQLERRM;
1330: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
1331: fnd_message.set_token('API_NAME',l_api_name);
1332: fnd_message.set_token('SQL_ERROR',l_sql_error);
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_msg_count := 1;
1335: x_msg_data := fnd_message.get;
1336:
1337: END get_instances;

Line 1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

1370:
1371: l_csi_txn_found NUMBER := NULL;
1372:
1373: BEGIN
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375:
1376: -- Bulk Collect the Transaction Data and validate each transaction
1377: OPEN c_mtl_data (p_inv_period_from_date,p_inv_period_to_date);
1378: LOOP

Line 1428: x_return_status := fnd_api.g_ret_sts_error;

1424:
1425: EXCEPTION
1426: WHEN inv_purge_not_allowed THEN
1427: fnd_message.set_name('CSI','CSI_INV_NO_DATA_PURGE');
1428: x_return_status := fnd_api.g_ret_sts_error;
1429: x_return_message := fnd_message.get;
1430:
1431: WHEN inv_purge_allowed THEN
1432: x_return_status := fnd_api.g_ret_sts_success;

Line 1432: x_return_status := fnd_api.g_ret_sts_success;

1428: x_return_status := fnd_api.g_ret_sts_error;
1429: x_return_message := fnd_message.get;
1430:
1431: WHEN inv_purge_allowed THEN
1432: x_return_status := fnd_api.g_ret_sts_success;
1433: x_return_message := NULL;
1434:
1435: WHEN others THEN
1436: fnd_message.set_name('CSI','CSI_INV_NO_DATA_PURGE');

Line 1437: x_return_status := fnd_api.g_ret_sts_error;

1433: x_return_message := NULL;
1434:
1435: WHEN others THEN
1436: fnd_message.set_name('CSI','CSI_INV_NO_DATA_PURGE');
1437: x_return_status := fnd_api.g_ret_sts_error;
1438: x_return_message := fnd_message.get;
1439:
1440: END inv_txn_data_purge;
1441:

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: r_so_info c_so_info%rowtype;
1474:
1475: BEGIN
1476:
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: j := 1;
1480:
1481: -- OM will pass a table of order lines that belong to 1 order. We need to loop

Line 1560: x_return_status := fnd_api.g_ret_sts_error;

1556: EXCEPTION
1557: WHEN om_purge_not_allowed THEN
1558: fnd_message.set_name('CSI','CSI_OM_PURGE_ERROR');
1559: fnd_message.set_token('ORDER_NUMBER',r_so_info.order_number);
1560: x_return_status := fnd_api.g_ret_sts_error;
1561: x_return_message := fnd_message.get;
1562: debug_con_log('***** End of Install Base Purge Program for Order '||r_so_info.order_number||' *****');
1563: debug_con_log('');
1564:

Line 1566: x_return_status := fnd_api.g_ret_sts_success;

1562: debug_con_log('***** End of Install Base Purge Program for Order '||r_so_info.order_number||' *****');
1563: debug_con_log('');
1564:
1565: WHEN om_purge_allowed THEN
1566: x_return_status := fnd_api.g_ret_sts_success;
1567: x_return_message := NULL;
1568: debug_con_log('***** End of Install Base Purge Program for Order '||r_so_info.order_number||' *****');
1569: debug_con_log('');
1570:

Line 1574: x_return_status := fnd_api.g_ret_sts_error;

1570:
1571: WHEN others THEN
1572: fnd_message.set_name('CSI','CSI_OM_PURGE_ERROR');
1573: fnd_message.set_token('ORDER_NUMBER',r_so_info.order_number);
1574: x_return_status := fnd_api.g_ret_sts_error;
1575: x_return_message := fnd_message.get;
1576: debug_con_log('***** End of Install Base Purge Program for Order '||r_so_info.order_number||' *****');
1577: debug_con_log('');
1578:

Line 1589: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1585:
1586: l_order_status VARCHAR2(25) := NULL;
1587: l_processed_recs NUMBER;
1588: l_mass_update_recs NUMBER;
1589: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1590: l_msg_count NUMBER;
1591: l_msg_data VARCHAR2(2000);
1592:
1593: purge_error EXCEPTION;

Line 1647: ,p_commit => fnd_api.g_false

1643: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1644:
1645: csi_t_txn_details_grp.delete_transaction_dtls (
1646: p_api_version => 1.0
1647: ,p_commit => fnd_api.g_false
1648: ,p_init_msg_list => fnd_api.g_false
1649: ,p_validation_level => fnd_api.g_valid_level_full
1650: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1651: ,p_api_caller_identity => 'PURGE'

Line 1648: ,p_init_msg_list => fnd_api.g_false

1644:
1645: csi_t_txn_details_grp.delete_transaction_dtls (
1646: p_api_version => 1.0
1647: ,p_commit => fnd_api.g_false
1648: ,p_init_msg_list => fnd_api.g_false
1649: ,p_validation_level => fnd_api.g_valid_level_full
1650: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1651: ,p_api_caller_identity => 'PURGE'
1652: ,x_return_status => l_return_status

Line 1649: ,p_validation_level => fnd_api.g_valid_level_full

1645: csi_t_txn_details_grp.delete_transaction_dtls (
1646: p_api_version => 1.0
1647: ,p_commit => fnd_api.g_false
1648: ,p_init_msg_list => fnd_api.g_false
1649: ,p_validation_level => fnd_api.g_valid_level_full
1650: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1651: ,p_api_caller_identity => 'PURGE'
1652: ,x_return_status => l_return_status
1653: ,x_msg_count => l_msg_count

Line 1659: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1655:
1656: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');
1657: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_migrated_recs.transaction_line_id);
1658:
1659: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1660: debug_con_log(' l_msg_data: '||l_msg_data);
1661: Raise purge_error;
1662: END IF;
1663:

Line 1674: ,p_commit => fnd_api.g_false

1670: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Detail: '||r_migrated_recs.transaction_line_id);
1671:
1672: csi_t_txn_details_grp.delete_transaction_dtls (
1673: p_api_version => 1.0
1674: ,p_commit => fnd_api.g_false
1675: ,p_init_msg_list => fnd_api.g_false
1676: ,p_validation_level => fnd_api.g_valid_level_full
1677: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1678: ,p_api_caller_identity => 'PURGE'

Line 1675: ,p_init_msg_list => fnd_api.g_false

1671:
1672: csi_t_txn_details_grp.delete_transaction_dtls (
1673: p_api_version => 1.0
1674: ,p_commit => fnd_api.g_false
1675: ,p_init_msg_list => fnd_api.g_false
1676: ,p_validation_level => fnd_api.g_valid_level_full
1677: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1678: ,p_api_caller_identity => 'PURGE'
1679: ,x_return_status => l_return_status

Line 1676: ,p_validation_level => fnd_api.g_valid_level_full

1672: csi_t_txn_details_grp.delete_transaction_dtls (
1673: p_api_version => 1.0
1674: ,p_commit => fnd_api.g_false
1675: ,p_init_msg_list => fnd_api.g_false
1676: ,p_validation_level => fnd_api.g_valid_level_full
1677: ,p_transaction_line_id => r_migrated_recs.transaction_line_id
1678: ,p_api_caller_identity => 'PURGE'
1679: ,x_return_status => l_return_status
1680: ,x_msg_count => l_msg_count

Line 1686: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1682:
1683: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls to remove Txn Line Details');
1684: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_migrated_recs.transaction_line_id);
1685:
1686: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1687: debug_con_log(' l_msg_data: '||l_msg_data);
1688: Raise purge_error;
1689: END IF;
1690:

Line 1726: ,p_commit => fnd_api.g_false

1722: debug_con_log(' Before csi_t_txn_details_grp.delete_transaction_dtls');
1723:
1724: csi_t_txn_details_grp.delete_transaction_dtls (
1725: p_api_version => 1.0
1726: ,p_commit => fnd_api.g_false
1727: ,p_init_msg_list => fnd_api.g_false
1728: ,p_validation_level => fnd_api.g_valid_level_full
1729: ,p_transaction_line_id => r_processed_recs.transaction_line_id
1730: ,p_api_caller_identity => 'PURGE'

Line 1727: ,p_init_msg_list => fnd_api.g_false

1723:
1724: csi_t_txn_details_grp.delete_transaction_dtls (
1725: p_api_version => 1.0
1726: ,p_commit => fnd_api.g_false
1727: ,p_init_msg_list => fnd_api.g_false
1728: ,p_validation_level => fnd_api.g_valid_level_full
1729: ,p_transaction_line_id => r_processed_recs.transaction_line_id
1730: ,p_api_caller_identity => 'PURGE'
1731: ,x_return_status => l_return_status

Line 1728: ,p_validation_level => fnd_api.g_valid_level_full

1724: csi_t_txn_details_grp.delete_transaction_dtls (
1725: p_api_version => 1.0
1726: ,p_commit => fnd_api.g_false
1727: ,p_init_msg_list => fnd_api.g_false
1728: ,p_validation_level => fnd_api.g_valid_level_full
1729: ,p_transaction_line_id => r_processed_recs.transaction_line_id
1730: ,p_api_caller_identity => 'PURGE'
1731: ,x_return_status => l_return_status
1732: ,x_msg_count => l_msg_count

Line 1738: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1734:
1735: debug_con_log(' After csi_t_txn_details_grp.delete_transaction_dtls');
1736: debug_con_log(' Return Status is :'||l_return_status||' for Txn Line '||r_processed_recs.transaction_line_id);
1737:
1738: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1739: debug_con_log(' l_msg_data: '||l_msg_data);
1740: Raise purge_error;
1741: END IF;
1742: