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_JAVA_INTERFACE_PKG dependencies on FND_API

Line 92: WHEN FND_API.G_EXC_ERROR THEN

88: );
89:
90: EXCEPTION
91:
92: WHEN FND_API.G_EXC_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: ROLLBACK TO create_item_instance;
95: FND_MSG_PUB.Count_And_Get
96: ( p_count => x_msg_count,

Line 93: x_return_status := FND_API.G_RET_STS_ERROR ;

89:
90: EXCEPTION
91:
92: WHEN FND_API.G_EXC_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: ROLLBACK TO create_item_instance;
95: FND_MSG_PUB.Count_And_Get
96: ( p_count => x_msg_count,
97: p_data => x_msg_data

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96: ( p_count => x_msg_count,
97: p_data => x_msg_data
98: );
99:
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: ROLLBACK TO create_item_instance;
103: FND_MSG_PUB.Count_And_Get
104: ( p_count => x_msg_count,

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

97: p_data => x_msg_data
98: );
99:
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: ROLLBACK TO create_item_instance;
103: FND_MSG_PUB.Count_And_Get
104: ( p_count => x_msg_count,
105: p_data => x_msg_data

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

105: p_data => x_msg_data
106: );
107:
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
110: ROLLBACK TO create_item_instance;
111: IF FND_MSG_PUB.Check_Msg_Level
112: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
113: THEN

Line 218: WHEN FND_API.G_EXC_ERROR THEN

214:
215: WHEN NO_DATA_FOUND THEN
216: NULL;
217:
218: WHEN FND_API.G_EXC_ERROR THEN
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: -- ROLLBACK TO create_item_instance;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,

Line 219: x_return_status := FND_API.G_RET_STS_ERROR ;

215: WHEN NO_DATA_FOUND THEN
216: NULL;
217:
218: WHEN FND_API.G_EXC_ERROR THEN
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: -- ROLLBACK TO create_item_instance;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,
223: p_data => x_msg_data

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: ( p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: -- ROLLBACK TO create_item_instance;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

223: p_data => x_msg_data
224: );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: -- ROLLBACK TO create_item_instance;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
231: p_data => x_msg_data

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
235: -- ROLLBACK TO create_item_instance;
236: IF FND_MSG_PUB.Check_Msg_Level
237: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN

Line 311: WHEN FND_API.G_EXC_ERROR THEN

307: );
308:
309: EXCEPTION
310:
311: WHEN FND_API.G_EXC_ERROR THEN
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313: ROLLBACK TO copy_item_instance;
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,

Line 312: x_return_status := FND_API.G_RET_STS_ERROR ;

308:
309: EXCEPTION
310:
311: WHEN FND_API.G_EXC_ERROR THEN
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313: ROLLBACK TO copy_item_instance;
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,
316: p_data => x_msg_data

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: ( p_count => x_msg_count,
316: p_data => x_msg_data
317: );
318:
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: ROLLBACK TO copy_item_instance;
322: FND_MSG_PUB.Count_And_Get
323: ( p_count => x_msg_count,

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

316: p_data => x_msg_data
317: );
318:
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: ROLLBACK TO copy_item_instance;
322: FND_MSG_PUB.Count_And_Get
323: ( p_count => x_msg_count,
324: p_data => x_msg_data

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

324: p_data => x_msg_data
325: );
326:
327: WHEN OTHERS THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: ROLLBACK TO copy_item_instance;
330: IF FND_MSG_PUB.Check_Msg_Level
331: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
332: THEN

Line 407: WHEN FND_API.G_EXC_ERROR THEN

403: );
404:
405: EXCEPTION
406:
407: WHEN FND_API.G_EXC_ERROR THEN
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: ROLLBACK TO split_item_instance;
410: FND_MSG_PUB.Count_And_Get
411: ( p_count => x_msg_count,

Line 408: x_return_status := FND_API.G_RET_STS_ERROR ;

404:
405: EXCEPTION
406:
407: WHEN FND_API.G_EXC_ERROR THEN
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: ROLLBACK TO split_item_instance;
410: FND_MSG_PUB.Count_And_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: ROLLBACK TO split_item_instance;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

420: p_data => x_msg_data
421: );
422:
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425: ROLLBACK TO split_item_instance;
426: IF FND_MSG_PUB.Check_Msg_Level
427: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
428: THEN

Line 497: WHEN FND_API.G_EXC_ERROR THEN

493: );
494:
495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR ;
499: ROLLBACK TO split_item_instance_lines;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,

Line 498: x_return_status := FND_API.G_RET_STS_ERROR ;

494:
495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR ;
499: ROLLBACK TO split_item_instance_lines;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

501: ( p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: ROLLBACK TO split_item_instance_lines;
508: FND_MSG_PUB.Count_And_Get
509: ( p_count => x_msg_count,

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

502: p_data => x_msg_data
503: );
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: ROLLBACK TO split_item_instance_lines;
508: FND_MSG_PUB.Count_And_Get
509: ( p_count => x_msg_count,
510: p_data => x_msg_data

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

510: p_data => x_msg_data
511: );
512:
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
515: ROLLBACK TO split_item_instance_lines;
516: IF FND_MSG_PUB.Check_Msg_Level
517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN

Line 611: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

607: x_msg_data => x_msg_data,
608: x_ent_contracts => l_ent_contracts);
609: x_return_status := l_return_status;
610: IF ( l_return_status ) <> 'S' Then
611: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
612: End IF;
613: /*-- bug 4736062
614: -- throw exception when there are too many coverage lines
615: IF ( l_ent_contracts.LAST ) > 5000 Then

Line 618: RAISE FND_API.G_EXC_ERROR;

614: -- throw exception when there are too many coverage lines
615: IF ( l_ent_contracts.LAST ) > 5000 Then
616: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_SEARCH_BY_CONTR_NUM');
617: FND_MSG_PUB.ADD;
618: RAISE FND_API.G_EXC_ERROR;
619: End IF;
620: */
621: -- If the debug level = 2 then dump all the output data.
622: IF (l_debug_level > 1) THEN

Line 683: WHEN FND_API.G_EXC_ERROR THEN

679: );
680:
681: EXCEPTION
682:
683: WHEN FND_API.G_EXC_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data

Line 684: x_return_status := FND_API.G_RET_STS_ERROR ;

680:
681: EXCEPTION
682:
683: WHEN FND_API.G_EXC_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count,
687: p_data => x_msg_data
688: );

Line 690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

686: ( p_count => x_msg_count,
687: p_data => x_msg_data
688: );
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: FND_MSG_PUB.Count_And_Get
693: ( p_count => x_msg_count,
694: p_data => x_msg_data

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

687: p_data => x_msg_data
688: );
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: FND_MSG_PUB.Count_And_Get
693: ( p_count => x_msg_count,
694: p_data => x_msg_data
695: );

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

694: p_data => x_msg_data
695: );
696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: IF FND_MSG_PUB.Check_Msg_Level
700: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg

Line 805: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

801: fnd_message.error;
802: End LOOP;
803: End IF;
804: */
805: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
806: End IF;
807:
808: -- fnd_message.debug('l_rec_count = '||to_char(l_rec_count));
809:

Line 1008: WHEN FND_API.G_EXC_ERROR THEN

1004: x_where_clause := l_contract_where_clause;
1005:
1006: EXCEPTION
1007:
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010: FND_MSG_PUB.Count_And_Get
1011: ( p_count => x_msg_count,
1012: p_data => x_msg_data

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR ;

1005:
1006: EXCEPTION
1007:
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010: FND_MSG_PUB.Count_And_Get
1011: ( p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );

Line 1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1011: ( p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );
1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data

Line 1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1012: p_data => x_msg_data
1013: );
1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: p_data => x_msg_data
1020: );
1021:
1022: WHEN OTHERS THEN
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024: IF FND_MSG_PUB.Check_Msg_Level
1025: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026: THEN
1027: FND_MSG_PUB.Add_Exc_Msg

Line 1078: IF fnd_api.to_boolean(p_commit)

1074: x_index number;
1075:
1076: BEGIN
1077:
1078: IF fnd_api.to_boolean(p_commit)
1079: THEN
1080: SAVEPOINT get_history_transactions;
1081: END IF;
1082:

Line 1084: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1080: SAVEPOINT get_history_transactions;
1081: END IF;
1082:
1083: -- Standard call to check for call compatibility.
1084: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1085: p_api_version ,
1086: l_api_name ,
1087: G_PKG_NAME )
1088: THEN

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1085: p_api_version ,
1086: l_api_name ,
1087: G_PKG_NAME )
1088: THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1093: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1094: FND_MSG_PUB.initialize;
1095: END IF;
1096:
1097: -- Initialize API return status to success

Line 1098: x_return_status := FND_API.G_RET_STS_SUCCESS;

1094: FND_MSG_PUB.initialize;
1095: END IF;
1096:
1097: -- Initialize API return status to success
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: /** bug 3304439
1100: -- Check for the profile option and enable trace
1101: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1102: dbms_session.set_sql_trace(TRUE);

Line 1121: ,p_commit => fnd_api.g_false

1117: AND ROWNUM = 1;
1118:
1119: csi_item_instance_pvt.get_instance_hist
1120: ( p_api_version => 1.0
1121: ,p_commit => fnd_api.g_false
1122: ,p_init_msg_list => fnd_api.g_false
1123: ,p_validation_level => fnd_api.g_valid_level_full
1124: ,p_transaction_id => p_transaction_id
1125: ,x_instance_history_tbl => temp_instance_history_tbl

Line 1122: ,p_init_msg_list => fnd_api.g_false

1118:
1119: csi_item_instance_pvt.get_instance_hist
1120: ( p_api_version => 1.0
1121: ,p_commit => fnd_api.g_false
1122: ,p_init_msg_list => fnd_api.g_false
1123: ,p_validation_level => fnd_api.g_valid_level_full
1124: ,p_transaction_id => p_transaction_id
1125: ,x_instance_history_tbl => temp_instance_history_tbl
1126: ,x_return_status => x_return_status

Line 1123: ,p_validation_level => fnd_api.g_valid_level_full

1119: csi_item_instance_pvt.get_instance_hist
1120: ( p_api_version => 1.0
1121: ,p_commit => fnd_api.g_false
1122: ,p_init_msg_list => fnd_api.g_false
1123: ,p_validation_level => fnd_api.g_valid_level_full
1124: ,p_transaction_id => p_transaction_id
1125: ,x_instance_history_tbl => temp_instance_history_tbl
1126: ,x_return_status => x_return_status
1127: ,x_msg_count => x_msg_count

Line 1155: ,p_commit => fnd_api.g_false

1151: WHERE transaction_id = p_transaction_id
1152: AND ROWNUM = 1;
1153: csi_asset_pvt.get_instance_asset_hist
1154: ( p_api_version => 1.0
1155: ,p_commit => fnd_api.g_false
1156: ,p_init_msg_list => fnd_api.g_false
1157: ,p_validation_level => fnd_api.g_valid_level_full
1158: ,p_transaction_id => p_transaction_id
1159: ,x_ins_asset_hist_tbl => temp_ins_asset_hist_tbl

Line 1156: ,p_init_msg_list => fnd_api.g_false

1152: AND ROWNUM = 1;
1153: csi_asset_pvt.get_instance_asset_hist
1154: ( p_api_version => 1.0
1155: ,p_commit => fnd_api.g_false
1156: ,p_init_msg_list => fnd_api.g_false
1157: ,p_validation_level => fnd_api.g_valid_level_full
1158: ,p_transaction_id => p_transaction_id
1159: ,x_ins_asset_hist_tbl => temp_ins_asset_hist_tbl
1160: ,x_return_status => x_return_status

Line 1157: ,p_validation_level => fnd_api.g_valid_level_full

1153: csi_asset_pvt.get_instance_asset_hist
1154: ( p_api_version => 1.0
1155: ,p_commit => fnd_api.g_false
1156: ,p_init_msg_list => fnd_api.g_false
1157: ,p_validation_level => fnd_api.g_valid_level_full
1158: ,p_transaction_id => p_transaction_id
1159: ,x_ins_asset_hist_tbl => temp_ins_asset_hist_tbl
1160: ,x_return_status => x_return_status
1161: ,x_msg_count => x_msg_count

Line 1188: ,p_commit => fnd_api.g_false

1184: WHERE transaction_id = p_transaction_id
1185: AND ROWNUM = 1;
1186: csi_party_relationships_pvt.get_inst_party_rel_hist
1187: ( p_api_version => 1.0
1188: ,p_commit => fnd_api.g_false
1189: ,p_init_msg_list => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_transaction_id => p_transaction_id
1192: ,x_party_history_tbl => temp_party_history_tbl

Line 1189: ,p_init_msg_list => fnd_api.g_false

1185: AND ROWNUM = 1;
1186: csi_party_relationships_pvt.get_inst_party_rel_hist
1187: ( p_api_version => 1.0
1188: ,p_commit => fnd_api.g_false
1189: ,p_init_msg_list => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_transaction_id => p_transaction_id
1192: ,x_party_history_tbl => temp_party_history_tbl
1193: ,x_return_status => x_return_status

Line 1190: ,p_validation_level => fnd_api.g_valid_level_full

1186: csi_party_relationships_pvt.get_inst_party_rel_hist
1187: ( p_api_version => 1.0
1188: ,p_commit => fnd_api.g_false
1189: ,p_init_msg_list => fnd_api.g_false
1190: ,p_validation_level => fnd_api.g_valid_level_full
1191: ,p_transaction_id => p_transaction_id
1192: ,x_party_history_tbl => temp_party_history_tbl
1193: ,x_return_status => x_return_status
1194: ,x_msg_count => x_msg_count

Line 1223: ,p_commit => fnd_api.g_false

1219: AND rownum=1;
1220:
1221: csi_party_relationships_pvt.get_inst_party_account_hist
1222: ( p_api_version => 1.0
1223: ,p_commit => fnd_api.g_false
1224: ,p_init_msg_list => fnd_api.g_false
1225: ,p_validation_level => fnd_api.g_valid_level_full
1226: ,p_transaction_id => p_transaction_id
1227: ,x_account_history_tbl => temp_account_history_tbl

Line 1224: ,p_init_msg_list => fnd_api.g_false

1220:
1221: csi_party_relationships_pvt.get_inst_party_account_hist
1222: ( p_api_version => 1.0
1223: ,p_commit => fnd_api.g_false
1224: ,p_init_msg_list => fnd_api.g_false
1225: ,p_validation_level => fnd_api.g_valid_level_full
1226: ,p_transaction_id => p_transaction_id
1227: ,x_account_history_tbl => temp_account_history_tbl
1228: ,x_return_status => x_return_status

Line 1225: ,p_validation_level => fnd_api.g_valid_level_full

1221: csi_party_relationships_pvt.get_inst_party_account_hist
1222: ( p_api_version => 1.0
1223: ,p_commit => fnd_api.g_false
1224: ,p_init_msg_list => fnd_api.g_false
1225: ,p_validation_level => fnd_api.g_valid_level_full
1226: ,p_transaction_id => p_transaction_id
1227: ,x_account_history_tbl => temp_account_history_tbl
1228: ,x_return_status => x_return_status
1229: ,x_msg_count => x_msg_count

Line 1258: ,p_commit => fnd_api.g_false

1254: AND ROWNUM = 1;
1255:
1256: csi_organization_unit_pvt.get_org_unit_history
1257: ( p_api_version => 1.0
1258: ,p_commit => fnd_api.g_false
1259: ,p_init_msg_list => fnd_api.g_false
1260: ,p_validation_level => fnd_api.g_valid_level_full
1261: ,p_transaction_id => p_transaction_id
1262: ,x_org_unit_history_tbl => temp_org_unit_history_tbl

Line 1259: ,p_init_msg_list => fnd_api.g_false

1255:
1256: csi_organization_unit_pvt.get_org_unit_history
1257: ( p_api_version => 1.0
1258: ,p_commit => fnd_api.g_false
1259: ,p_init_msg_list => fnd_api.g_false
1260: ,p_validation_level => fnd_api.g_valid_level_full
1261: ,p_transaction_id => p_transaction_id
1262: ,x_org_unit_history_tbl => temp_org_unit_history_tbl
1263: ,x_return_status => x_return_status

Line 1260: ,p_validation_level => fnd_api.g_valid_level_full

1256: csi_organization_unit_pvt.get_org_unit_history
1257: ( p_api_version => 1.0
1258: ,p_commit => fnd_api.g_false
1259: ,p_init_msg_list => fnd_api.g_false
1260: ,p_validation_level => fnd_api.g_valid_level_full
1261: ,p_transaction_id => p_transaction_id
1262: ,x_org_unit_history_tbl => temp_org_unit_history_tbl
1263: ,x_return_status => x_return_status
1264: ,x_msg_count => x_msg_count

Line 1293: ,p_commit => fnd_api.g_false

1289: AND ROWNUM = 1;
1290:
1291: csi_item_instance_pvt.get_ext_attrib_val_hist
1292: ( p_api_version => 1.0
1293: ,p_commit => fnd_api.g_false
1294: ,p_init_msg_list => fnd_api.g_false
1295: ,p_validation_level => fnd_api.g_valid_level_full
1296: ,p_transaction_id => p_transaction_id
1297: ,x_ext_attrib_val_hist_tbl => temp_ext_attrib_val_hist_tbl

Line 1294: ,p_init_msg_list => fnd_api.g_false

1290:
1291: csi_item_instance_pvt.get_ext_attrib_val_hist
1292: ( p_api_version => 1.0
1293: ,p_commit => fnd_api.g_false
1294: ,p_init_msg_list => fnd_api.g_false
1295: ,p_validation_level => fnd_api.g_valid_level_full
1296: ,p_transaction_id => p_transaction_id
1297: ,x_ext_attrib_val_hist_tbl => temp_ext_attrib_val_hist_tbl
1298: ,x_return_status => x_return_status

Line 1295: ,p_validation_level => fnd_api.g_valid_level_full

1291: csi_item_instance_pvt.get_ext_attrib_val_hist
1292: ( p_api_version => 1.0
1293: ,p_commit => fnd_api.g_false
1294: ,p_init_msg_list => fnd_api.g_false
1295: ,p_validation_level => fnd_api.g_valid_level_full
1296: ,p_transaction_id => p_transaction_id
1297: ,x_ext_attrib_val_hist_tbl => temp_ext_attrib_val_hist_tbl
1298: ,x_return_status => x_return_status
1299: ,x_msg_count => x_msg_count

Line 1328: ,p_commit => fnd_api.g_false

1324: AND rownum=1;
1325:
1326: csi_ii_relationships_pvt.get_inst_relationship_hist
1327: ( p_api_version => 1.0
1328: ,p_commit => fnd_api.g_false
1329: ,p_init_msg_list => fnd_api.g_false
1330: ,p_validation_level => fnd_api.g_valid_level_full
1331: ,p_transaction_id => p_transaction_id
1332: ,x_rel_history_tbl => temp_rel_history_tbl

Line 1329: ,p_init_msg_list => fnd_api.g_false

1325:
1326: csi_ii_relationships_pvt.get_inst_relationship_hist
1327: ( p_api_version => 1.0
1328: ,p_commit => fnd_api.g_false
1329: ,p_init_msg_list => fnd_api.g_false
1330: ,p_validation_level => fnd_api.g_valid_level_full
1331: ,p_transaction_id => p_transaction_id
1332: ,x_rel_history_tbl => temp_rel_history_tbl
1333: ,x_return_status => x_return_status

Line 1330: ,p_validation_level => fnd_api.g_valid_level_full

1326: csi_ii_relationships_pvt.get_inst_relationship_hist
1327: ( p_api_version => 1.0
1328: ,p_commit => fnd_api.g_false
1329: ,p_init_msg_list => fnd_api.g_false
1330: ,p_validation_level => fnd_api.g_valid_level_full
1331: ,p_transaction_id => p_transaction_id
1332: ,x_rel_history_tbl => temp_rel_history_tbl
1333: ,x_return_status => x_return_status
1334: ,x_msg_count => x_msg_count

Line 1362: ,p_commit => fnd_api.g_false

1358: AND ROWNUM = 1;
1359:
1360: csi_item_instance_pvt.get_version_label_history
1361: ( p_api_version => 1.0
1362: ,p_commit => fnd_api.g_false
1363: ,p_init_msg_list => fnd_api.g_false
1364: ,p_validation_level => fnd_api.g_valid_level_full
1365: ,p_transaction_id => p_transaction_id
1366: ,x_version_label_hist_tbl => x_version_label_hist_tbl

Line 1363: ,p_init_msg_list => fnd_api.g_false

1359:
1360: csi_item_instance_pvt.get_version_label_history
1361: ( p_api_version => 1.0
1362: ,p_commit => fnd_api.g_false
1363: ,p_init_msg_list => fnd_api.g_false
1364: ,p_validation_level => fnd_api.g_valid_level_full
1365: ,p_transaction_id => p_transaction_id
1366: ,x_version_label_hist_tbl => x_version_label_hist_tbl
1367: ,x_return_status => x_return_status

Line 1364: ,p_validation_level => fnd_api.g_valid_level_full

1360: csi_item_instance_pvt.get_version_label_history
1361: ( p_api_version => 1.0
1362: ,p_commit => fnd_api.g_false
1363: ,p_init_msg_list => fnd_api.g_false
1364: ,p_validation_level => fnd_api.g_valid_level_full
1365: ,p_transaction_id => p_transaction_id
1366: ,x_version_label_hist_tbl => x_version_label_hist_tbl
1367: ,x_return_status => x_return_status
1368: ,x_msg_count => x_msg_count

Line 1380: IF FND_API.To_Boolean( p_commit ) THEN

1376: */
1377: -- End of API body
1378:
1379: -- Standard check of p_commit.
1380: IF FND_API.To_Boolean( p_commit ) THEN
1381: COMMIT WORK;
1382: END IF;
1383: /** bug 3304439
1384: -- Check for the profile option and disable the trace

Line 1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1393: (p_count => x_msg_count ,
1394: p_data => x_msg_data );
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: IF fnd_api.to_boolean(p_commit)
1399: THEN
1400: ROLLBACK TO get_history_transactions;
1401: END IF;

Line 1398: IF fnd_api.to_boolean(p_commit)

1394: p_data => x_msg_data );
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: IF fnd_api.to_boolean(p_commit)
1399: THEN
1400: ROLLBACK TO get_history_transactions;
1401: END IF;
1402: IF FND_MSG_PUB.Check_Msg_Level

Line 1440: /*IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1436: l_user_id := fnd_global.user_id;
1437:
1438: SAVEPOINT CSI_CONFIG_LAUNCH_PRMS;
1439: -- Standard call to check for call compatibility.
1440: /*IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1441: p_api_version ,
1442: l_api_name ,
1443: G_PKG_NAME )
1444: THEN

Line 1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1441: p_api_version ,
1442: l_api_name ,
1443: G_PKG_NAME )
1444: THEN
1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: END IF;*/
1447:
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1449: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: END IF;*/
1447:
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1450: FND_MSG_PUB.initialize;
1451: END IF;
1452:
1453: -- Initialize API rturn status to success

Line 1454: x_return_status := FND_API.g_ret_sts_success;

1450: FND_MSG_PUB.initialize;
1451: END IF;
1452:
1453: -- Initialize API rturn status to success
1454: x_return_status := FND_API.g_ret_sts_success;
1455:
1456:
1457: l_resp_id := fnd_profile.value('RESP_ID');
1458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

Line 1473: IF FND_API.To_Boolean( p_commit ) THEN

1469: -- get the SYSDATE
1470: x_sysdate := to_char(sysdate,'mm-dd-yyyy-hh24-mi-ss');
1471:
1472:
1473: IF FND_API.To_Boolean( p_commit ) THEN
1474: COMMIT WORK;
1475: END IF;
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_encoded => FND_API.G_FALSE,

Line 1477: ( p_encoded => FND_API.G_FALSE,

1473: IF FND_API.To_Boolean( p_commit ) THEN
1474: COMMIT WORK;
1475: END IF;
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_encoded => FND_API.G_FALSE,
1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );
1481: EXCEPTION

Line 1482: WHEN FND_API.G_EXC_ERROR THEN

1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );
1481: EXCEPTION
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1484: x_return_status := FND_API.G_RET_STS_ERROR ;
1485: FND_MSG_PUB.Count_And_Get
1486: ( p_encoded => FND_API.G_FALSE,

Line 1484: x_return_status := FND_API.G_RET_STS_ERROR ;

1480: );
1481: EXCEPTION
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1484: x_return_status := FND_API.G_RET_STS_ERROR ;
1485: FND_MSG_PUB.Count_And_Get
1486: ( p_encoded => FND_API.G_FALSE,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data

Line 1486: ( p_encoded => FND_API.G_FALSE,

1482: WHEN FND_API.G_EXC_ERROR THEN
1483: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1484: x_return_status := FND_API.G_RET_STS_ERROR ;
1485: FND_MSG_PUB.Count_And_Get
1486: ( p_encoded => FND_API.G_FALSE,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );
1490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1486: ( p_encoded => FND_API.G_FALSE,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );
1490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1491: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: UNEXPECTED ERROR EXCEPTION ');
1492: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: FND_MSG_PUB.Count_And_Get

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1489: );
1490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1491: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: UNEXPECTED ERROR EXCEPTION ');
1492: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: FND_MSG_PUB.Count_And_Get
1495: ( p_encoded => FND_API.G_FALSE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data

Line 1495: ( p_encoded => FND_API.G_FALSE,

1491: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: UNEXPECTED ERROR EXCEPTION ');
1492: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494: FND_MSG_PUB.Count_And_Get
1495: ( p_encoded => FND_API.G_FALSE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data
1498: );
1499: WHEN OTHERS THEN

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1498: );
1499: WHEN OTHERS THEN
1500: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: OTHER EXCEPTION ');
1501: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1503: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: FND_MSG_PUB.Add_Exc_Msg
1506: ( G_PKG_NAME,

Line 1511: ( p_encoded => FND_API.G_FALSE,

1507: l_api_name
1508: );
1509: END IF;*/
1510: FND_MSG_PUB.Count_And_Get
1511: ( p_encoded => FND_API.G_FALSE,
1512: p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );
1515: /*ibe_util.disable_debug;*/

Line 1583: WHEN FND_API.G_EXC_ERROR THEN

1579: );
1580:
1581: EXCEPTION
1582:
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: x_return_status := FND_API.G_RET_STS_ERROR ;
1585: ROLLBACK TO get_instance_link_location;
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count,

Line 1584: x_return_status := FND_API.G_RET_STS_ERROR ;

1580:
1581: EXCEPTION
1582:
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: x_return_status := FND_API.G_RET_STS_ERROR ;
1585: ROLLBACK TO get_instance_link_location;
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count,
1588: p_data => x_msg_data

Line 1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1587: ( p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );
1590:
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: ROLLBACK TO get_instance_link_location;
1594: FND_MSG_PUB.Count_And_Get
1595: ( p_count => x_msg_count,

Line 1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1588: p_data => x_msg_data
1589: );
1590:
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: ROLLBACK TO get_instance_link_location;
1594: FND_MSG_PUB.Count_And_Get
1595: ( p_count => x_msg_count,
1596: p_data => x_msg_data

Line 1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1596: p_data => x_msg_data
1597: );
1598:
1599: WHEN OTHERS THEN
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1601: ROLLBACK TO get_instance_link_location;
1602: IF FND_MSG_PUB.Check_Msg_Level
1603: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1604: THEN

Line 1697: l_commit varchar2(1) := fnd_api.g_false;

1693: p_relationship_type_code IN VARCHAR2,
1694: p_time_stamp IN DATE
1695: ) IS
1696: l_api_version number := 1.0;
1697: l_commit varchar2(1) := fnd_api.g_false;
1698: l_init_msg_list varchar2(1) := fnd_api.g_false;
1699: l_validation_level number := fnd_api.g_valid_level_full;
1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;

Line 1698: l_init_msg_list varchar2(1) := fnd_api.g_false;

1694: p_time_stamp IN DATE
1695: ) IS
1696: l_api_version number := 1.0;
1697: l_commit varchar2(1) := fnd_api.g_false;
1698: l_init_msg_list varchar2(1) := fnd_api.g_false;
1699: l_validation_level number := fnd_api.g_valid_level_full;
1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;
1702: l_msg_count number;

Line 1699: l_validation_level number := fnd_api.g_valid_level_full;

1695: ) IS
1696: l_api_version number := 1.0;
1697: l_commit varchar2(1) := fnd_api.g_false;
1698: l_init_msg_list varchar2(1) := fnd_api.g_false;
1699: l_validation_level number := fnd_api.g_valid_level_full;
1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;
1702: l_msg_count number;
1703: l_msg_data varchar2(240);

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

1700: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1701: l_rel_tbl1 csi_datastructures_pub.ii_relationship_tbl;
1702: l_msg_count number;
1703: l_msg_data varchar2(240);
1704: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1705: l_depth NUMBER := null;
1706: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1707: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;
1708: l_all_parents_id varchar2(4000);

Line 1710: l_active_relationship_only VARCHAR2(1) := fnd_api.g_true; --fix for bug5222952

1706: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1707: l_relationship_query_rec1 csi_datastructures_pub.relationship_query_rec;
1708: l_all_parents_id varchar2(4000);
1709: l_time_stamp DATE := p_time_stamp;
1710: l_active_relationship_only VARCHAR2(1) := fnd_api.g_true; --fix for bug5222952
1711: l_var integer;
1712: l_connected_relationship_tbl connected_relationship_tbl;
1713: l_instanceid_tbl instanceid_tbl;
1714: l_instanceid_tbl1 instanceid_tbl1;

Line 1808: l_commit varchar2(1) := fnd_api.g_false;

1804: p_subject_id IN NUMBER,
1805: p_time_stamp IN DATE
1806: ) RETURN VARCHAR2 IS
1807: l_api_version number := 1.0;
1808: l_commit varchar2(1) := fnd_api.g_false;
1809: l_init_msg_list varchar2(1) := fnd_api.g_false;
1810: l_validation_level number := fnd_api.g_valid_level_full;
1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1812: l_msg_count number;

Line 1809: l_init_msg_list varchar2(1) := fnd_api.g_false;

1805: p_time_stamp IN DATE
1806: ) RETURN VARCHAR2 IS
1807: l_api_version number := 1.0;
1808: l_commit varchar2(1) := fnd_api.g_false;
1809: l_init_msg_list varchar2(1) := fnd_api.g_false;
1810: l_validation_level number := fnd_api.g_valid_level_full;
1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1812: l_msg_count number;
1813: l_msg_data varchar2(240);

Line 1810: l_validation_level number := fnd_api.g_valid_level_full;

1806: ) RETURN VARCHAR2 IS
1807: l_api_version number := 1.0;
1808: l_commit varchar2(1) := fnd_api.g_false;
1809: l_init_msg_list varchar2(1) := fnd_api.g_false;
1810: l_validation_level number := fnd_api.g_valid_level_full;
1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1812: l_msg_count number;
1813: l_msg_data varchar2(240);
1814: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

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

1810: l_validation_level number := fnd_api.g_valid_level_full;
1811: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
1812: l_msg_count number;
1813: l_msg_data varchar2(240);
1814: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1815: l_depth NUMBER := null;
1816: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1817: l_all_parents_id varchar2(4000);
1818: l_time_stamp DATE :=p_time_stamp;

Line 1819: l_active_relationship_only VARCHAR2(1) := fnd_api.g_false;

1815: l_depth NUMBER := null;
1816: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
1817: l_all_parents_id varchar2(4000);
1818: l_time_stamp DATE :=p_time_stamp;
1819: l_active_relationship_only VARCHAR2(1) := fnd_api.g_false;
1820: l_output varchar2(4000);
1821: l_var integer;
1822: BEGIN
1823: l_relationship_query_rec.Subject_id:=p_subject_id ;

Line 2022: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2018:
2019: l_api_name CONSTANT VARCHAR2(30) := 'delete_search_oks_temp';
2020:
2021: BEGIN
2022: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2023:
2024: IF p_sequence_id IS NULL THEN
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026: FND_MSG_PUB.Count_And_Get

Line 2025: x_return_status := FND_API.G_RET_STS_ERROR ;

2021: BEGIN
2022: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2023:
2024: IF p_sequence_id IS NULL THEN
2025: x_return_status := FND_API.G_RET_STS_ERROR ;
2026: FND_MSG_PUB.Count_And_Get
2027: ( p_count => x_msg_count,
2028: p_data => x_msg_data
2029: );

Line 2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2033: END IF;
2034:
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2038: IF FND_MSG_PUB.Check_Msg_Level
2039: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2040: THEN
2041: FND_MSG_PUB.Add_Exc_Msg