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 86: (p_encoded => FND_API.G_FALSE,

82: x_msg_count,
83: x_msg_data);
84:
85: FND_MSG_PUB.Count_And_Get
86: (p_encoded => FND_API.G_FALSE,
87: p_count => x_msg_count,
88: p_data => x_msg_data);
89:
90: EXCEPTION

Line 92: WHEN FND_API.G_EXC_ERROR THEN

88: p_data => x_msg_data);
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_encoded => FND_API.G_FALSE,

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_encoded => FND_API.G_FALSE,
97: p_count => x_msg_count,

Line 96: ( p_encoded => FND_API.G_FALSE,

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_encoded => FND_API.G_FALSE,
97: p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100:

Line 101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 219: WHEN FND_API.G_EXC_ERROR THEN

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

Line 220: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 312: WHEN FND_API.G_EXC_ERROR THEN

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

Line 313: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 408: WHEN FND_API.G_EXC_ERROR THEN

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

Line 409: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 498: WHEN FND_API.G_EXC_ERROR THEN

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

Line 499: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 612: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 619: RAISE FND_API.G_EXC_ERROR;

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

Line 684: WHEN FND_API.G_EXC_ERROR THEN

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

Line 685: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 806: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1009: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1010: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1079: IF fnd_api.to_boolean(p_commit)

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

Line 1085: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1099: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1122: ,p_commit => fnd_api.g_false

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

Line 1123: ,p_init_msg_list => fnd_api.g_false

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

Line 1124: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1156: ,p_commit => fnd_api.g_false

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

Line 1157: ,p_init_msg_list => fnd_api.g_false

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

Line 1158: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1189: ,p_commit => fnd_api.g_false

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

Line 1190: ,p_init_msg_list => fnd_api.g_false

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

Line 1191: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1224: ,p_commit => fnd_api.g_false

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

Line 1225: ,p_init_msg_list => fnd_api.g_false

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

Line 1226: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1259: ,p_commit => fnd_api.g_false

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

Line 1260: ,p_init_msg_list => fnd_api.g_false

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

Line 1261: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1294: ,p_commit => fnd_api.g_false

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

Line 1295: ,p_init_msg_list => fnd_api.g_false

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

Line 1296: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1329: ,p_commit => fnd_api.g_false

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

Line 1330: ,p_init_msg_list => fnd_api.g_false

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

Line 1331: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1363: ,p_commit => fnd_api.g_false

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

Line 1364: ,p_init_msg_list => fnd_api.g_false

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

Line 1365: ,p_validation_level => fnd_api.g_valid_level_full

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

Line 1381: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1398: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1399: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1450: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1455: x_return_status := FND_API.g_ret_sts_success;

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

Line 1474: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1478: ( p_encoded => FND_API.G_FALSE,

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

Line 1483: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1485: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1487: ( p_encoded => FND_API.G_FALSE,

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

Line 1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1496: ( p_encoded => FND_API.G_FALSE,

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

Line 1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1512: ( p_encoded => FND_API.G_FALSE,

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

Line 1584: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1585: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

Line 1700: l_validation_level number := fnd_api.g_valid_level_full;

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

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

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

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

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

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

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

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

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

Line 1811: l_validation_level number := fnd_api.g_valid_level_full;

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

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

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

Line 1820: l_active_relationship_only VARCHAR2(1) := fnd_api.g_true;

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

Line 2023: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 2026: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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