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.OZF_RESALE_WF_PVT dependencies on FND_API

Line 58: p_encoded => FND_API.g_false,

54:
55: FOR i IN 1..p_msg_count LOOP
56: FND_MSG_PUB.get(
57: p_msg_index => p_msg_count - i +1 ,
58: p_encoded => FND_API.g_false,
59: p_data => l_msg_data,
60: p_msg_index_out => l_msg_index
61: );
62: l_temp_mesg := l_msg_index ||': ' ||

Line 186: p_init_msg_list => FND_API.G_FALSE,

182: l_batch_return_status := l_batch_status;
183: ELSE
184: OZF_RESALE_COMMON_PVT.Update_Duplicates (
185: p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
189: p_resale_batch_id => l_batch_id,
190: p_resale_batch_type => l_batch_type,

Line 187: p_commit => FND_API.G_FALSE,

183: ELSE
184: OZF_RESALE_COMMON_PVT.Update_Duplicates (
185: p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
189: p_resale_batch_id => l_batch_id,
190: p_resale_batch_type => l_batch_type,
191: p_batch_status => l_batch_status,

Line 188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

184: OZF_RESALE_COMMON_PVT.Update_Duplicates (
185: p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
189: p_resale_batch_id => l_batch_id,
190: p_resale_batch_type => l_batch_type,
191: p_batch_status => l_batch_status,
192: x_batch_status => l_batch_return_status,

Line 201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

197: IF OZF_DEBUG_LOW_ON THEN
198: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
199: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
200: END IF;
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: RAISE FND_API.G_EXC_ERROR;
203: END IF;
204: END IF;
205: ELSE

Line 202: RAISE FND_API.G_EXC_ERROR;

198: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
199: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
200: END IF;
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: RAISE FND_API.G_EXC_ERROR;
203: END IF;
204: END IF;
205: ELSE
206: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 207: RAISE FND_API.G_EXC_ERROR;

203: END IF;
204: END IF;
205: ELSE
206: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: WF_ENGINE.SetItemAttrText(
211: itemtype => itemtype,

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231:
232: resultout := l_resultout;
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => l_msg_count,
239: p_data => l_msg_data

Line 237: p_encoded => FND_API.G_FALSE,

233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => l_msg_count,
239: p_data => l_msg_data
240: );
241: Handle_Error(

Line 256: p_encoded => FND_API.G_FALSE,

252: IF OZF_UNEXP_ERROR THEN
253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
254: END IF;
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => l_msg_count,
258: p_data => l_msg_data
259: );
260: Handle_Error(

Line 349: --RAISE FND_API.G_EXC_ERROR;

345: IF l_auto_tp_accrual is NULL THEN
346: -- 11/23/04 yizhang: default flag to FALSE instead of raising an error
347: l_auto_tp_accrual := 'F';
348: --OZF_UTILITY_PVT.error_message('OZF_RESALE_AUTO_TP_NULL');
349: --RAISE FND_API.G_EXC_ERROR;
350: END IF;
351: l_resultout := 'COMPLETE:' || l_auto_tp_accrual;
352: --
353: ELSIF (funcmode = 'CANCEL') THEN

Line 364: WHEN FND_API.G_EXC_ERROR THEN

360:
361: resultout := l_resultout;
362:
363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => l_msg_count,
368: p_data => l_msg_data

Line 366: p_encoded => FND_API.G_FALSE,

362:
363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => l_msg_count,
368: p_data => l_msg_data
369: );
370: Handle_Error(

Line 385: p_encoded => FND_API.G_FALSE,

381: IF OZF_UNEXP_ERROR THEN
382: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
383: END IF;
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => l_msg_count,
387: p_data => l_msg_data
388: );
389: Handle_Error(

Line 486: RAISE FND_API.G_EXC_ERROR;

482:
483: IF l_batch_caller NOT IN (G_WF_LKUP_UI, G_WF_LKUP_XML, G_WF_LKUP_WEBADI)
484: THEN
485: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch caller '|| l_batch_caller);
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: -- SET attribute OZF_BATCH_NUM_W_DATE for event key
490: l_batch_number := WF_ENGINE.GetItemAttrText(

Line 519: WHEN FND_API.G_EXC_ERROR THEN

515:
516: resultout := l_resultout;
517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => l_msg_count,
523: p_data => l_msg_data

Line 521: p_encoded => FND_API.G_FALSE,

517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => l_msg_count,
523: p_data => l_msg_data
524: );
525: Handle_Error(

Line 540: p_encoded => FND_API.G_FALSE,

536: IF OZF_UNEXP_ERROR THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => l_msg_count,
542: p_data => l_msg_data
543: );
544: Handle_Error(

Line 657: WHEN FND_API.G_EXC_ERROR THEN

653:
654: resultout := l_resultout;
655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_ERROR THEN
658: FND_MSG_PUB.Count_And_Get (
659: p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data

Line 659: p_encoded => FND_API.G_FALSE,

655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_ERROR THEN
658: FND_MSG_PUB.Count_And_Get (
659: p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data
662: );
663: Handle_Error(

Line 678: p_encoded => FND_API.G_FALSE,

674: IF OZF_UNEXP_ERROR THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
676: END IF;
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => l_msg_count,
680: p_data => l_msg_data
681: );
682: Handle_Error(

Line 768: RAISE FND_API.G_EXC_ERROR;

764: IF l_batch_type NOT IN (G_WF_LKUP_CHARGEBACK, G_WF_LKUP_SPECIALPRICE, G_WF_LKUP_TRACING) OR
765: l_batch_type IS NULL
766: THEN
767: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch Type '|| l_batch_type);
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: IF OZF_DEBUG_LOW_ON THEN
772: OZF_UTILITY_PVT.debug_message('Batch Type '|| l_batch_type );

Line 787: WHEN FND_API.G_EXC_ERROR THEN

783:
784: resultout := l_resultout;
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: FND_MSG_PUB.Count_And_Get (
789: p_encoded => FND_API.G_FALSE,
790: p_count => l_msg_count,
791: p_data => l_msg_data

Line 789: p_encoded => FND_API.G_FALSE,

785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: FND_MSG_PUB.Count_And_Get (
789: p_encoded => FND_API.G_FALSE,
790: p_count => l_msg_count,
791: p_data => l_msg_data
792: );
793: Handle_Error(

Line 808: p_encoded => FND_API.G_FALSE,

804: IF OZF_UNEXP_ERROR THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => l_msg_count,
810: p_data => l_msg_data
811: );
812: Handle_Error(

Line 887: RAISE FND_API.G_EXC_ERROR;

883: aname => G_WF_ATTR_BATCH_ID
884: );
885: IF l_resale_batch_id is NULL THEN
886: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: OPEN batch_num_csr (l_resale_batch_id);
891: FETCH batch_num_csr into l_batch_number

Line 961: WHEN FND_API.G_EXC_ERROR THEN

957: RETURN;
958: END IF;
959: --
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => l_msg_count,
965: p_data => l_msg_data

Line 963: p_encoded => FND_API.G_FALSE,

959: --
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => l_msg_count,
965: p_data => l_msg_data
966: );
967: Handle_Error(

Line 982: p_encoded => FND_API.G_FALSE,

978: IF OZF_UNEXP_ERROR THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (
982: p_encoded => FND_API.G_FALSE,
983: p_count => l_msg_count,
984: p_data => l_msg_data
985: );
986: Handle_Error(

Line 1067: ,p_init_msg_list => FND_API.G_FALSE

1063: itemkey => itemkey,
1064: aname => G_WF_ATTR_BATCH_ID);
1065: OZF_RESALE_PVT.Initiate_Payment (
1066: p_api_version => 1.0
1067: ,p_init_msg_list => FND_API.G_FALSE
1068: ,p_commit => FND_API.G_FALSE
1069: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1070: ,p_resale_batch_id => l_resale_batch_id
1071: ,x_return_status => l_return_status

Line 1068: ,p_commit => FND_API.G_FALSE

1064: aname => G_WF_ATTR_BATCH_ID);
1065: OZF_RESALE_PVT.Initiate_Payment (
1066: p_api_version => 1.0
1067: ,p_init_msg_list => FND_API.G_FALSE
1068: ,p_commit => FND_API.G_FALSE
1069: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1070: ,p_resale_batch_id => l_resale_batch_id
1071: ,x_return_status => l_return_status
1072: ,x_msg_data => l_msg_data

Line 1069: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1065: OZF_RESALE_PVT.Initiate_Payment (
1066: p_api_version => 1.0
1067: ,p_init_msg_list => FND_API.G_FALSE
1068: ,p_commit => FND_API.G_FALSE
1069: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1070: ,p_resale_batch_id => l_resale_batch_id
1071: ,x_return_status => l_return_status
1072: ,x_msg_data => l_msg_data
1073: ,x_msg_count => l_msg_count

Line 1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1074: );
1075: IF OZF_DEBUG_LOW_ON THEN
1076: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
1077: END IF;
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: l_resultout := 'COMPLETE:SUCCESS';
1082: --

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: IF OZF_DEBUG_LOW_ON THEN
1076: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
1077: END IF;
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: l_resultout := 'COMPLETE:SUCCESS';
1082: --
1083: ELSIF (funcmode = 'CANCEL') THEN

Line 1094: WHEN FND_API.G_EXC_ERROR THEN

1090:
1091: resultout := l_resultout;
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => l_msg_count,
1098: p_data => l_msg_data

Line 1096: p_encoded => FND_API.G_FALSE,

1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => l_msg_count,
1098: p_data => l_msg_data
1099: );
1100: Handle_Error(

Line 1116: p_encoded => FND_API.G_FALSE,

1112: IF OZF_UNEXP_ERROR THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get (
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => l_msg_count,
1118: p_data => l_msg_data
1119: );
1120: Handle_Error(

Line 1203: ,p_init_msg_list => FND_API.G_FALSE

1199: itemkey => itemkey,
1200: aname => G_WF_ATTR_BATCH_ID);
1201: OZF_CHARGEBACK_PVT.Initiate_Payment (
1202: p_api_version => 1.0
1203: ,p_init_msg_list => FND_API.G_FALSE
1204: ,p_commit => FND_API.G_FALSE
1205: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1206: ,p_resale_batch_id => l_resale_batch_id
1207: ,x_return_status => l_return_status

Line 1204: ,p_commit => FND_API.G_FALSE

1200: aname => G_WF_ATTR_BATCH_ID);
1201: OZF_CHARGEBACK_PVT.Initiate_Payment (
1202: p_api_version => 1.0
1203: ,p_init_msg_list => FND_API.G_FALSE
1204: ,p_commit => FND_API.G_FALSE
1205: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1206: ,p_resale_batch_id => l_resale_batch_id
1207: ,x_return_status => l_return_status
1208: ,x_msg_data => l_msg_data

Line 1205: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1201: OZF_CHARGEBACK_PVT.Initiate_Payment (
1202: p_api_version => 1.0
1203: ,p_init_msg_list => FND_API.G_FALSE
1204: ,p_commit => FND_API.G_FALSE
1205: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1206: ,p_resale_batch_id => l_resale_batch_id
1207: ,x_return_status => l_return_status
1208: ,x_msg_data => l_msg_data
1209: ,x_msg_count => l_msg_count

Line 1211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1207: ,x_return_status => l_return_status
1208: ,x_msg_data => l_msg_data
1209: ,x_msg_count => l_msg_count
1210: );
1211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214: l_resultout := 'COMPLETE:SUCCESS';
1215: --

Line 1212: RAISE FND_API.G_EXC_ERROR;

1208: ,x_msg_data => l_msg_data
1209: ,x_msg_count => l_msg_count
1210: );
1211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214: l_resultout := 'COMPLETE:SUCCESS';
1215: --
1216: ELSIF (funcmode = 'CANCEL') THEN

Line 1227: WHEN FND_API.G_EXC_ERROR THEN

1223:
1224: resultout := l_resultout;
1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => l_msg_count,
1231: p_data => l_msg_data

Line 1229: p_encoded => FND_API.G_FALSE,

1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => l_msg_count,
1231: p_data => l_msg_data
1232: );
1233: Handle_Error(

Line 1249: p_encoded => FND_API.G_FALSE,

1245: IF OZF_UNEXP_ERROR THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: FND_MSG_PUB.Count_And_Get (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => l_msg_count,
1251: p_data => l_msg_data
1252: );
1253: Handle_Error(

Line 1335: ,p_init_msg_list => FND_API.G_FALSE

1331: itemkey => itemkey,
1332: aname => G_WF_ATTR_BATCH_ID);
1333: OZF_SPECIAL_PRICING_PVT.Initiate_Payment (
1334: p_api_version => 1.0
1335: ,p_init_msg_list => FND_API.G_FALSE
1336: ,p_commit => FND_API.G_FALSE
1337: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1338: ,p_resale_batch_id => l_resale_batch_id
1339: ,x_return_status => l_return_status

Line 1336: ,p_commit => FND_API.G_FALSE

1332: aname => G_WF_ATTR_BATCH_ID);
1333: OZF_SPECIAL_PRICING_PVT.Initiate_Payment (
1334: p_api_version => 1.0
1335: ,p_init_msg_list => FND_API.G_FALSE
1336: ,p_commit => FND_API.G_FALSE
1337: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1338: ,p_resale_batch_id => l_resale_batch_id
1339: ,x_return_status => l_return_status
1340: ,x_msg_data => l_msg_data

Line 1337: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1333: OZF_SPECIAL_PRICING_PVT.Initiate_Payment (
1334: p_api_version => 1.0
1335: ,p_init_msg_list => FND_API.G_FALSE
1336: ,p_commit => FND_API.G_FALSE
1337: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1338: ,p_resale_batch_id => l_resale_batch_id
1339: ,x_return_status => l_return_status
1340: ,x_msg_data => l_msg_data
1341: ,x_msg_count => l_msg_count

Line 1343: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1339: ,x_return_status => l_return_status
1340: ,x_msg_data => l_msg_data
1341: ,x_msg_count => l_msg_count
1342: );
1343: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: l_resultout := 'COMPLETE:SUCCESS';
1347: --

Line 1344: RAISE FND_API.G_EXC_ERROR;

1340: ,x_msg_data => l_msg_data
1341: ,x_msg_count => l_msg_count
1342: );
1343: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: l_resultout := 'COMPLETE:SUCCESS';
1347: --
1348: ELSIF (funcmode = 'CANCEL') THEN

Line 1359: WHEN FND_API.G_EXC_ERROR THEN

1355:
1356: resultout := l_resultout;
1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => l_msg_count,
1363: p_data => l_msg_data

Line 1361: p_encoded => FND_API.G_FALSE,

1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => l_msg_count,
1363: p_data => l_msg_data
1364: );
1365: Handle_Error(

Line 1381: p_encoded => FND_API.G_FALSE,

1377: IF OZF_UNEXP_ERROR THEN
1378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get (
1381: p_encoded => FND_API.G_FALSE,
1382: p_count => l_msg_count,
1383: p_data => l_msg_data
1384: );
1385: Handle_Error(

Line 1436: ,p_init_msg_list => FND_API.G_FALSE

1432: itemkey => itemkey,
1433: aname => G_WF_ATTR_BATCH_ID);
1434: OZF_TRACING_ORDER_PVT.Initiate_Payment (
1435: p_api_version => 1.0
1436: ,p_init_msg_list => FND_API.G_FALSE
1437: ,p_commit => FND_API.G_FALSE
1438: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1439: ,p_resale_batch_id => l_resale_batch_id
1440: ,x_return_status => l_return_status

Line 1437: ,p_commit => FND_API.G_FALSE

1433: aname => G_WF_ATTR_BATCH_ID);
1434: OZF_TRACING_ORDER_PVT.Initiate_Payment (
1435: p_api_version => 1.0
1436: ,p_init_msg_list => FND_API.G_FALSE
1437: ,p_commit => FND_API.G_FALSE
1438: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1439: ,p_resale_batch_id => l_resale_batch_id
1440: ,x_return_status => l_return_status
1441: ,x_msg_data => l_msg_data

Line 1438: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1434: OZF_TRACING_ORDER_PVT.Initiate_Payment (
1435: p_api_version => 1.0
1436: ,p_init_msg_list => FND_API.G_FALSE
1437: ,p_commit => FND_API.G_FALSE
1438: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1439: ,p_resale_batch_id => l_resale_batch_id
1440: ,x_return_status => l_return_status
1441: ,x_msg_data => l_msg_data
1442: ,x_msg_count => l_msg_count

Line 1444: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1440: ,x_return_status => l_return_status
1441: ,x_msg_data => l_msg_data
1442: ,x_msg_count => l_msg_count
1443: );
1444: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447: l_resultout := 'COMPLETE:SUCCESS';
1448: --

Line 1445: RAISE FND_API.G_EXC_ERROR;

1441: ,x_msg_data => l_msg_data
1442: ,x_msg_count => l_msg_count
1443: );
1444: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447: l_resultout := 'COMPLETE:SUCCESS';
1448: --
1449: ELSIF (funcmode = 'CANCEL') THEN

Line 1460: WHEN FND_API.G_EXC_ERROR THEN

1456:
1457: resultout := l_resultout;
1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: FND_MSG_PUB.Count_And_Get (
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => l_msg_count,
1464: p_data => l_msg_data

Line 1462: p_encoded => FND_API.G_FALSE,

1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: FND_MSG_PUB.Count_And_Get (
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => l_msg_count,
1464: p_data => l_msg_data
1465: );
1466: Handle_Error(

Line 1482: p_encoded => FND_API.G_FALSE,

1478: IF OZF_UNEXP_ERROR THEN
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1480: END IF;
1481: FND_MSG_PUB.Count_And_Get (
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => l_msg_count,
1484: p_data => l_msg_data
1485: );
1486: Handle_Error(

Line 1567: ,p_init_msg_list => FND_API.G_FALSE

1563: itemkey => itemkey,
1564: aname => G_WF_ATTR_BATCH_ID);
1565: OZF_CHARGEBACK_PVT.Process_Order(
1566: p_api_version => 1.0
1567: ,p_init_msg_list => FND_API.G_FALSE
1568: ,p_commit => FND_API.G_FALSE
1569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1570: ,p_resale_batch_id => l_resale_batch_id
1571: ,x_return_status => l_return_status

Line 1568: ,p_commit => FND_API.G_FALSE

1564: aname => G_WF_ATTR_BATCH_ID);
1565: OZF_CHARGEBACK_PVT.Process_Order(
1566: p_api_version => 1.0
1567: ,p_init_msg_list => FND_API.G_FALSE
1568: ,p_commit => FND_API.G_FALSE
1569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1570: ,p_resale_batch_id => l_resale_batch_id
1571: ,x_return_status => l_return_status
1572: ,x_msg_data => l_msg_data

Line 1569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1565: OZF_CHARGEBACK_PVT.Process_Order(
1566: p_api_version => 1.0
1567: ,p_init_msg_list => FND_API.G_FALSE
1568: ,p_commit => FND_API.G_FALSE
1569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1570: ,p_resale_batch_id => l_resale_batch_id
1571: ,x_return_status => l_return_status
1572: ,x_msg_data => l_msg_data
1573: ,x_msg_count => l_msg_count

Line 1578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1574: );
1575: IF OZF_DEBUG_LOW_ON THEN
1576: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1577: END IF;
1578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: l_resultout := 'COMPLETE:SUCCESS';
1582: --

Line 1579: RAISE FND_API.G_EXC_ERROR;

1575: IF OZF_DEBUG_LOW_ON THEN
1576: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1577: END IF;
1578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: l_resultout := 'COMPLETE:SUCCESS';
1582: --
1583: ELSIF (funcmode = 'CANCEL') THEN

Line 1594: WHEN FND_API.G_EXC_ERROR THEN

1590:
1591: resultout := l_resultout;
1592:
1593: EXCEPTION
1594: WHEN FND_API.G_EXC_ERROR THEN
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => l_msg_count,
1598: p_data => l_msg_data

Line 1596: p_encoded => FND_API.G_FALSE,

1592:
1593: EXCEPTION
1594: WHEN FND_API.G_EXC_ERROR THEN
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => l_msg_count,
1598: p_data => l_msg_data
1599: );
1600: Handle_Error(

Line 1616: p_encoded => FND_API.G_FALSE,

1612: IF OZF_UNEXP_ERROR THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: FND_MSG_PUB.Count_And_Get (
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => l_msg_count,
1618: p_data => l_msg_data
1619: );
1620: Handle_Error(

Line 1703: ,p_init_msg_list => FND_API.G_FALSE

1699: itemkey => itemkey,
1700: aname => G_WF_ATTR_BATCH_ID);
1701: OZF_RESALE_PVT.Process_Resale (
1702: p_api_version => 1
1703: ,p_init_msg_list => FND_API.G_FALSE
1704: ,p_commit => FND_API.G_FALSE
1705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1706: ,p_resale_batch_id => l_resale_batch_id
1707: ,x_return_status => l_return_status

Line 1704: ,p_commit => FND_API.G_FALSE

1700: aname => G_WF_ATTR_BATCH_ID);
1701: OZF_RESALE_PVT.Process_Resale (
1702: p_api_version => 1
1703: ,p_init_msg_list => FND_API.G_FALSE
1704: ,p_commit => FND_API.G_FALSE
1705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1706: ,p_resale_batch_id => l_resale_batch_id
1707: ,x_return_status => l_return_status
1708: ,x_msg_data => l_msg_data

Line 1705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1701: OZF_RESALE_PVT.Process_Resale (
1702: p_api_version => 1
1703: ,p_init_msg_list => FND_API.G_FALSE
1704: ,p_commit => FND_API.G_FALSE
1705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1706: ,p_resale_batch_id => l_resale_batch_id
1707: ,x_return_status => l_return_status
1708: ,x_msg_data => l_msg_data
1709: ,x_msg_count => l_msg_count

Line 1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1707: ,x_return_status => l_return_status
1708: ,x_msg_data => l_msg_data
1709: ,x_msg_count => l_msg_count
1710: );
1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: RAISE FND_API.G_EXC_ERROR;
1713: END IF;
1714: l_resultout := 'COMPLETE:SUCCESS';
1715: --

Line 1712: RAISE FND_API.G_EXC_ERROR;

1708: ,x_msg_data => l_msg_data
1709: ,x_msg_count => l_msg_count
1710: );
1711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: RAISE FND_API.G_EXC_ERROR;
1713: END IF;
1714: l_resultout := 'COMPLETE:SUCCESS';
1715: --
1716: ELSIF (funcmode = 'CANCEL') THEN

Line 1727: WHEN FND_API.G_EXC_ERROR THEN

1723:
1724: resultout := l_resultout;
1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: FND_MSG_PUB.Count_And_Get (
1729: p_encoded => FND_API.G_FALSE,
1730: p_count => l_msg_count,
1731: p_data => l_msg_data

Line 1729: p_encoded => FND_API.G_FALSE,

1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: FND_MSG_PUB.Count_And_Get (
1729: p_encoded => FND_API.G_FALSE,
1730: p_count => l_msg_count,
1731: p_data => l_msg_data
1732: );
1733: Handle_Error(

Line 1749: p_encoded => FND_API.G_FALSE,

1745: IF OZF_UNEXP_ERROR THEN
1746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1747: END IF;
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => l_msg_count,
1751: p_data => l_msg_data
1752: );
1753: Handle_Error(

Line 1835: ,p_init_msg_list => FND_API.G_FALSE

1831: itemkey => itemkey,
1832: aname => G_WF_ATTR_BATCH_ID);
1833: OZF_SPECIAL_PRICING_PVT.Process_Order(
1834: p_api_version => 1.0
1835: ,p_init_msg_list => FND_API.G_FALSE
1836: ,p_commit => FND_API.G_FALSE
1837: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: ,p_resale_batch_id => l_resale_batch_id
1839: ,x_return_status => l_return_status

Line 1836: ,p_commit => FND_API.G_FALSE

1832: aname => G_WF_ATTR_BATCH_ID);
1833: OZF_SPECIAL_PRICING_PVT.Process_Order(
1834: p_api_version => 1.0
1835: ,p_init_msg_list => FND_API.G_FALSE
1836: ,p_commit => FND_API.G_FALSE
1837: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: ,p_resale_batch_id => l_resale_batch_id
1839: ,x_return_status => l_return_status
1840: ,x_msg_data => l_msg_data

Line 1837: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1833: OZF_SPECIAL_PRICING_PVT.Process_Order(
1834: p_api_version => 1.0
1835: ,p_init_msg_list => FND_API.G_FALSE
1836: ,p_commit => FND_API.G_FALSE
1837: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: ,p_resale_batch_id => l_resale_batch_id
1839: ,x_return_status => l_return_status
1840: ,x_msg_data => l_msg_data
1841: ,x_msg_count => l_msg_count

Line 1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1842: );
1843: IF OZF_DEBUG_LOW_ON THEN
1844: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1845: END IF;
1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: l_resultout := 'COMPLETE:SUCCESS';
1850: --

Line 1847: RAISE FND_API.G_EXC_ERROR;

1843: IF OZF_DEBUG_LOW_ON THEN
1844: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1845: END IF;
1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: l_resultout := 'COMPLETE:SUCCESS';
1850: --
1851: ELSIF (funcmode = 'CANCEL') THEN

Line 1862: WHEN FND_API.G_EXC_ERROR THEN

1858:
1859: resultout := l_resultout;
1860:
1861: EXCEPTION
1862: WHEN FND_API.G_EXC_ERROR THEN
1863: FND_MSG_PUB.Count_And_Get (
1864: p_encoded => FND_API.G_FALSE,
1865: p_count => l_msg_count,
1866: p_data => l_msg_data

Line 1864: p_encoded => FND_API.G_FALSE,

1860:
1861: EXCEPTION
1862: WHEN FND_API.G_EXC_ERROR THEN
1863: FND_MSG_PUB.Count_And_Get (
1864: p_encoded => FND_API.G_FALSE,
1865: p_count => l_msg_count,
1866: p_data => l_msg_data
1867: );
1868: Handle_Error(

Line 1884: p_encoded => FND_API.G_FALSE,

1880: IF OZF_UNEXP_ERROR THEN
1881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1882: END IF;
1883: FND_MSG_PUB.Count_And_Get (
1884: p_encoded => FND_API.G_FALSE,
1885: p_count => l_msg_count,
1886: p_data => l_msg_data
1887: );
1888: Handle_Error(

Line 1970: ,p_init_msg_list => FND_API.G_FALSE

1966: itemkey => itemkey,
1967: aname => G_WF_ATTR_BATCH_ID);
1968: OZF_TRACING_ORDER_PVT.Process_Order(
1969: p_api_version => 1.0
1970: ,p_init_msg_list => FND_API.G_FALSE
1971: ,p_commit => FND_API.G_FALSE
1972: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1973: ,p_resale_batch_id => l_resale_batch_id
1974: ,x_return_status => l_return_status

Line 1971: ,p_commit => FND_API.G_FALSE

1967: aname => G_WF_ATTR_BATCH_ID);
1968: OZF_TRACING_ORDER_PVT.Process_Order(
1969: p_api_version => 1.0
1970: ,p_init_msg_list => FND_API.G_FALSE
1971: ,p_commit => FND_API.G_FALSE
1972: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1973: ,p_resale_batch_id => l_resale_batch_id
1974: ,x_return_status => l_return_status
1975: ,x_msg_data => l_msg_data

Line 1972: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1968: OZF_TRACING_ORDER_PVT.Process_Order(
1969: p_api_version => 1.0
1970: ,p_init_msg_list => FND_API.G_FALSE
1971: ,p_commit => FND_API.G_FALSE
1972: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1973: ,p_resale_batch_id => l_resale_batch_id
1974: ,x_return_status => l_return_status
1975: ,x_msg_data => l_msg_data
1976: ,x_msg_count => l_msg_count

Line 1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1977: );
1978: IF OZF_DEBUG_LOW_ON THEN
1979: OZF_UTILITY_PVT.debug_message('subscribe process tracing order complete ');
1980: END IF;
1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;
1984: l_resultout := 'COMPLETE:SUCCESS';
1985: --

Line 1982: RAISE FND_API.G_EXC_ERROR;

1978: IF OZF_DEBUG_LOW_ON THEN
1979: OZF_UTILITY_PVT.debug_message('subscribe process tracing order complete ');
1980: END IF;
1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;
1984: l_resultout := 'COMPLETE:SUCCESS';
1985: --
1986: ELSIF (funcmode = 'CANCEL') THEN

Line 1997: WHEN FND_API.G_EXC_ERROR THEN

1993:
1994: resultout := l_resultout;
1995:
1996: EXCEPTION
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: FND_MSG_PUB.Count_And_Get (
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => l_msg_count,
2001: p_data => l_msg_data

Line 1999: p_encoded => FND_API.G_FALSE,

1995:
1996: EXCEPTION
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: FND_MSG_PUB.Count_And_Get (
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => l_msg_count,
2001: p_data => l_msg_data
2002: );
2003: Handle_Error(

Line 2019: p_encoded => FND_API.G_FALSE,

2015: IF OZF_UNEXP_ERROR THEN
2016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2017: END IF;
2018: FND_MSG_PUB.Count_And_Get (
2019: p_encoded => FND_API.G_FALSE,
2020: p_count => l_msg_count,
2021: p_data => l_msg_data
2022: );
2023: Handle_Error(

Line 2093: RAISE FND_API.G_EXC_ERROR;

2089: CLOSE batch_status_csr;
2090:
2091: IF l_batch_status is null THEN
2092: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095:
2096: -- reset the status based on # of disputed lines
2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);

Line 2145: WHEN FND_API.G_EXC_ERROR THEN

2141: result := l_resultout;
2142: RETURN;
2143: --
2144: EXCEPTION
2145: WHEN FND_API.G_EXC_ERROR THEN
2146: FND_MSG_PUB.Count_And_Get (
2147: p_encoded => FND_API.G_FALSE,
2148: p_count => l_msg_count,
2149: p_data => l_msg_data

Line 2147: p_encoded => FND_API.G_FALSE,

2143: --
2144: EXCEPTION
2145: WHEN FND_API.G_EXC_ERROR THEN
2146: FND_MSG_PUB.Count_And_Get (
2147: p_encoded => FND_API.G_FALSE,
2148: p_count => l_msg_count,
2149: p_data => l_msg_data
2150: );
2151: Handle_Error(

Line 2166: p_encoded => FND_API.G_FALSE,

2162: IF OZF_UNEXP_ERROR THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
2165: FND_MSG_PUB.Count_And_Get (
2166: p_encoded => FND_API.G_FALSE,
2167: p_count => l_msg_count,
2168: p_data => l_msg_data
2169: );
2170: Handle_Error(

Line 2315: RAISE FND_API.G_EXC_ERROR;

2311:
2312: --
2313: IF l_batch_status is null THEN
2314: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;
2317:
2318:
2319: IF l_batch_status in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING,

Line 2333: RAISE FND_API.G_EXC_ERROR;

2329: WHERE resale_batch_id = l_resale_batch_id;
2330:
2331: ELSE
2332: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_ERR');
2333: RAISE FND_API.G_EXC_ERROR;
2334: END IF;
2335: END IF;
2336:
2337:

Line 2356: WHEN FND_API.G_EXC_ERROR THEN

2352: resultout := l_resultout;
2353: RETURN;
2354: --
2355: EXCEPTION
2356: WHEN FND_API.G_EXC_ERROR THEN
2357: FND_MSG_PUB.Count_And_Get (
2358: p_encoded => FND_API.G_FALSE,
2359: p_count => l_msg_count,
2360: p_data => l_msg_data

Line 2358: p_encoded => FND_API.G_FALSE,

2354: --
2355: EXCEPTION
2356: WHEN FND_API.G_EXC_ERROR THEN
2357: FND_MSG_PUB.Count_And_Get (
2358: p_encoded => FND_API.G_FALSE,
2359: p_count => l_msg_count,
2360: p_data => l_msg_data
2361: );
2362: Handle_Error(

Line 2377: p_encoded => FND_API.G_FALSE,

2373: IF OZF_UNEXP_ERROR THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2375: END IF;
2376: FND_MSG_PUB.Count_And_Get (
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => l_msg_count,
2379: p_data => l_msg_data
2380: );
2381: Handle_Error(

Line 2486: WHEN FND_API.G_EXC_ERROR THEN

2482: resultout := l_resultout;
2483: RETURN;
2484: --
2485: EXCEPTION
2486: WHEN FND_API.G_EXC_ERROR THEN
2487: FND_MSG_PUB.Count_And_Get (
2488: p_encoded => FND_API.G_FALSE,
2489: p_count => l_msg_count,
2490: p_data => l_msg_data

Line 2488: p_encoded => FND_API.G_FALSE,

2484: --
2485: EXCEPTION
2486: WHEN FND_API.G_EXC_ERROR THEN
2487: FND_MSG_PUB.Count_And_Get (
2488: p_encoded => FND_API.G_FALSE,
2489: p_count => l_msg_count,
2490: p_data => l_msg_data
2491: );
2492: Handle_Error(

Line 2507: p_encoded => FND_API.G_FALSE,

2503: IF OZF_UNEXP_ERROR THEN
2504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2505: END IF;
2506: FND_MSG_PUB.Count_And_Get (
2507: p_encoded => FND_API.G_FALSE,
2508: p_count => l_msg_count,
2509: p_data => l_msg_data
2510: );
2511: Handle_Error(

Line 2728: WHEN FND_API.G_EXC_ERROR THEN

2724: resultout := l_resultout;
2725: RETURN;
2726: --
2727: EXCEPTION
2728: WHEN FND_API.G_EXC_ERROR THEN
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => l_msg_count,
2732: p_data => l_msg_data

Line 2730: p_encoded => FND_API.G_FALSE,

2726: --
2727: EXCEPTION
2728: WHEN FND_API.G_EXC_ERROR THEN
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => l_msg_count,
2732: p_data => l_msg_data
2733: );
2734: Handle_Error(

Line 2749: p_encoded => FND_API.G_FALSE,

2745: IF OZF_UNEXP_ERROR THEN
2746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2747: END IF;
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => l_msg_count,
2751: p_data => l_msg_data
2752: );
2753: Handle_Error(

Line 2843: p_init_msg_list => FND_API.G_FALSE,

2839: END IF;
2840: IF l_batch_id IS NOT NULL THEN
2841: OZF_RESALE_COMMON_PVT.Validate_Batch (
2842: p_api_version => 1.0,
2843: p_init_msg_list => FND_API.G_FALSE,
2844: p_commit => FND_API.G_FALSE,
2845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2846: p_resale_batch_id => l_batch_id,
2847: x_batch_status => l_batch_status,

Line 2844: p_commit => FND_API.G_FALSE,

2840: IF l_batch_id IS NOT NULL THEN
2841: OZF_RESALE_COMMON_PVT.Validate_Batch (
2842: p_api_version => 1.0,
2843: p_init_msg_list => FND_API.G_FALSE,
2844: p_commit => FND_API.G_FALSE,
2845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2846: p_resale_batch_id => l_batch_id,
2847: x_batch_status => l_batch_status,
2848: x_return_status => l_return_status,

Line 2845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2841: OZF_RESALE_COMMON_PVT.Validate_Batch (
2842: p_api_version => 1.0,
2843: p_init_msg_list => FND_API.G_FALSE,
2844: p_commit => FND_API.G_FALSE,
2845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2846: p_resale_batch_id => l_batch_id,
2847: x_batch_status => l_batch_status,
2848: x_return_status => l_return_status,
2849: x_msg_count => l_msg_count,

Line 2855: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2851:
2852: IF OZF_DEBUG_LOW_ON THEN
2853: OZF_UTILITY_PVT.debug_message('Validate Batch is complete '||l_return_status);
2854: END IF;
2855: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2856: RAISE FND_API.G_EXC_ERROR;
2857: END IF;
2858: l_resultout := 'COMPLETE:SUCCESS';
2859: ELSE

Line 2856: RAISE FND_API.G_EXC_ERROR;

2852: IF OZF_DEBUG_LOW_ON THEN
2853: OZF_UTILITY_PVT.debug_message('Validate Batch is complete '||l_return_status);
2854: END IF;
2855: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2856: RAISE FND_API.G_EXC_ERROR;
2857: END IF;
2858: l_resultout := 'COMPLETE:SUCCESS';
2859: ELSE
2860: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 2861: RAISE FND_API.G_EXC_ERROR;

2857: END IF;
2858: l_resultout := 'COMPLETE:SUCCESS';
2859: ELSE
2860: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
2861: RAISE FND_API.G_EXC_ERROR;
2862: END IF;
2863: l_resultout := 'COMPLETE:SUCCESS';
2864: --
2865: ELSIF (funcmode = 'CANCEL') THEN

Line 2876: WHEN FND_API.G_EXC_ERROR THEN

2872:
2873: resultout := l_resultout;
2874:
2875: EXCEPTION
2876: WHEN FND_API.G_EXC_ERROR THEN
2877: FND_MSG_PUB.Count_And_Get (
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => l_msg_count,
2880: p_data => l_msg_data

Line 2878: p_encoded => FND_API.G_FALSE,

2874:
2875: EXCEPTION
2876: WHEN FND_API.G_EXC_ERROR THEN
2877: FND_MSG_PUB.Count_And_Get (
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => l_msg_count,
2880: p_data => l_msg_data
2881: );
2882: Handle_Error(

Line 2898: p_encoded => FND_API.G_FALSE,

2894: IF OZF_UNEXP_ERROR THEN
2895: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2896: END IF;
2897: FND_MSG_PUB.Count_And_Get (
2898: p_encoded => FND_API.G_FALSE,
2899: p_count => l_msg_count,
2900: p_data => l_msg_data
2901: );
2902: Handle_Error(

Line 2990: ,p_init_msg_list => FND_API.G_FALSE

2986: IF l_batch_id IS NOT NULL THEN
2987: -- Verify the line information for this batch
2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (
2989: p_api_version => 1.0
2990: ,p_init_msg_list => FND_API.G_FALSE
2991: ,p_commit => FND_API.G_FALSE
2992: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2993: ,p_resale_batch_id => l_batch_id
2994: ,x_return_status => l_return_status

Line 2991: ,p_commit => FND_API.G_FALSE

2987: -- Verify the line information for this batch
2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (
2989: p_api_version => 1.0
2990: ,p_init_msg_list => FND_API.G_FALSE
2991: ,p_commit => FND_API.G_FALSE
2992: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2993: ,p_resale_batch_id => l_batch_id
2994: ,x_return_status => l_return_status
2995: ,x_msg_data => l_msg_data

Line 2992: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (
2989: p_api_version => 1.0
2990: ,p_init_msg_list => FND_API.G_FALSE
2991: ,p_commit => FND_API.G_FALSE
2992: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2993: ,p_resale_batch_id => l_batch_id
2994: ,x_return_status => l_return_status
2995: ,x_msg_data => l_msg_data
2996: ,x_msg_count => l_msg_count

Line 2998: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

2994: ,x_return_status => l_return_status
2995: ,x_msg_data => l_msg_data
2996: ,x_msg_count => l_msg_count
2997: );
2998: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
2999: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: ELSE

Line 3000: RAISE FND_API.G_EXC_ERROR;

2996: ,x_msg_count => l_msg_count
2997: );
2998: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
2999: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: ELSE
3003: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3004: RAISE FND_API.G_EXC_ERROR;

Line 3004: RAISE FND_API.G_EXC_ERROR;

3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: ELSE
3003: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3004: RAISE FND_API.G_EXC_ERROR;
3005: END IF;
3006:
3007: l_resultout := 'COMPLETE:SUCCESS';
3008: --

Line 3020: WHEN FND_API.G_EXC_ERROR THEN

3016:
3017: resultout := l_resultout;
3018:
3019: EXCEPTION
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: FND_MSG_PUB.Count_And_Get (
3022: p_encoded => FND_API.G_FALSE,
3023: p_count => l_msg_count,
3024: p_data => l_msg_data

Line 3022: p_encoded => FND_API.G_FALSE,

3018:
3019: EXCEPTION
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: FND_MSG_PUB.Count_And_Get (
3022: p_encoded => FND_API.G_FALSE,
3023: p_count => l_msg_count,
3024: p_data => l_msg_data
3025: );
3026: Handle_Error(

Line 3042: p_encoded => FND_API.G_FALSE,

3038: IF OZF_UNEXP_ERROR THEN
3039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3040: END IF;
3041: FND_MSG_PUB.Count_And_Get (
3042: p_encoded => FND_API.G_FALSE,
3043: p_count => l_msg_count,
3044: p_data => l_msg_data
3045: );
3046: Handle_Error(

Line 3136: ,p_init_msg_list => FND_API.G_FALSE

3132: IF l_batch_id IS NOT NULL THEN
3133: -- Verify the line information for this batch
3134: OZF_CHARGEBACK_PVT.Validate_Order_Record (
3135: p_api_version => 1
3136: ,p_init_msg_list => FND_API.G_FALSE
3137: ,p_commit => FND_API.G_FALSE
3138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3139: ,p_resale_batch_id => l_batch_id
3140: ,x_return_status => l_return_status

Line 3137: ,p_commit => FND_API.G_FALSE

3133: -- Verify the line information for this batch
3134: OZF_CHARGEBACK_PVT.Validate_Order_Record (
3135: p_api_version => 1
3136: ,p_init_msg_list => FND_API.G_FALSE
3137: ,p_commit => FND_API.G_FALSE
3138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3139: ,p_resale_batch_id => l_batch_id
3140: ,x_return_status => l_return_status
3141: ,x_msg_data => l_msg_data

Line 3138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3134: OZF_CHARGEBACK_PVT.Validate_Order_Record (
3135: p_api_version => 1
3136: ,p_init_msg_list => FND_API.G_FALSE
3137: ,p_commit => FND_API.G_FALSE
3138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3139: ,p_resale_batch_id => l_batch_id
3140: ,x_return_status => l_return_status
3141: ,x_msg_data => l_msg_data
3142: ,x_msg_count => l_msg_count

Line 3144: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

3140: ,x_return_status => l_return_status
3141: ,x_msg_data => l_msg_data
3142: ,x_msg_count => l_msg_count
3143: );
3144: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3145: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148: ELSE

Line 3146: RAISE FND_API.G_EXC_ERROR;

3142: ,x_msg_count => l_msg_count
3143: );
3144: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3145: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148: ELSE
3149: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3150: RAISE FND_API.G_EXC_ERROR;

Line 3150: RAISE FND_API.G_EXC_ERROR;

3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148: ELSE
3149: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3150: RAISE FND_API.G_EXC_ERROR;
3151: END IF;
3152: l_resultout := 'COMPLETE:SUCCESS';
3153: --
3154: ELSIF (funcmode = 'CANCEL') THEN

Line 3165: WHEN FND_API.G_EXC_ERROR THEN

3161:
3162: resultout := l_resultout;
3163:
3164: EXCEPTION
3165: WHEN FND_API.G_EXC_ERROR THEN
3166: FND_MSG_PUB.Count_And_Get (
3167: p_encoded => FND_API.G_FALSE,
3168: p_count => l_msg_count,
3169: p_data => l_msg_data

Line 3167: p_encoded => FND_API.G_FALSE,

3163:
3164: EXCEPTION
3165: WHEN FND_API.G_EXC_ERROR THEN
3166: FND_MSG_PUB.Count_And_Get (
3167: p_encoded => FND_API.G_FALSE,
3168: p_count => l_msg_count,
3169: p_data => l_msg_data
3170: );
3171: Handle_Error(

Line 3187: p_encoded => FND_API.G_FALSE,

3183: IF OZF_UNEXP_ERROR THEN
3184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3185: END IF;
3186: FND_MSG_PUB.Count_And_Get (
3187: p_encoded => FND_API.G_FALSE,
3188: p_count => l_msg_count,
3189: p_data => l_msg_data
3190: );
3191: Handle_Error(

Line 3280: ,p_init_msg_list => FND_API.G_FALSE

3276: IF l_batch_id IS NOT NULL THEN
3277: -- Verify the line information for this batch
3278: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record (
3279: p_api_version => 1
3280: ,p_init_msg_list => FND_API.G_FALSE
3281: ,p_commit => FND_API.G_FALSE
3282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3283: ,p_resale_batch_id => l_batch_id
3284: ,x_return_status => l_return_status

Line 3281: ,p_commit => FND_API.G_FALSE

3277: -- Verify the line information for this batch
3278: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record (
3279: p_api_version => 1
3280: ,p_init_msg_list => FND_API.G_FALSE
3281: ,p_commit => FND_API.G_FALSE
3282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3283: ,p_resale_batch_id => l_batch_id
3284: ,x_return_status => l_return_status
3285: ,x_msg_data => l_msg_data

Line 3282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3278: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record (
3279: p_api_version => 1
3280: ,p_init_msg_list => FND_API.G_FALSE
3281: ,p_commit => FND_API.G_FALSE
3282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3283: ,p_resale_batch_id => l_batch_id
3284: ,x_return_status => l_return_status
3285: ,x_msg_data => l_msg_data
3286: ,x_msg_count => l_msg_count

Line 3288: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

3284: ,x_return_status => l_return_status
3285: ,x_msg_data => l_msg_data
3286: ,x_msg_count => l_msg_count
3287: );
3288: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3289: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: ELSE

Line 3290: RAISE FND_API.G_EXC_ERROR;

3286: ,x_msg_count => l_msg_count
3287: );
3288: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3289: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: ELSE
3293: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3294: RAISE FND_API.G_EXC_ERROR;

Line 3294: RAISE FND_API.G_EXC_ERROR;

3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: ELSE
3293: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3294: RAISE FND_API.G_EXC_ERROR;
3295: END IF;
3296: l_resultout := 'COMPLETE:SUCCESS';
3297: --
3298: ELSIF (funcmode = 'CANCEL') THEN

Line 3309: WHEN FND_API.G_EXC_ERROR THEN

3305:
3306: resultout := l_resultout;
3307:
3308: EXCEPTION
3309: WHEN FND_API.G_EXC_ERROR THEN
3310: FND_MSG_PUB.Count_And_Get (
3311: p_encoded => FND_API.G_FALSE,
3312: p_count => l_msg_count,
3313: p_data => l_msg_data

Line 3311: p_encoded => FND_API.G_FALSE,

3307:
3308: EXCEPTION
3309: WHEN FND_API.G_EXC_ERROR THEN
3310: FND_MSG_PUB.Count_And_Get (
3311: p_encoded => FND_API.G_FALSE,
3312: p_count => l_msg_count,
3313: p_data => l_msg_data
3314: );
3315: Handle_Error(

Line 3331: p_encoded => FND_API.G_FALSE,

3327: IF OZF_UNEXP_ERROR THEN
3328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3329: END IF;
3330: FND_MSG_PUB.Count_And_Get (
3331: p_encoded => FND_API.G_FALSE,
3332: p_count => l_msg_count,
3333: p_data => l_msg_data
3334: );
3335: Handle_Error(

Line 3425: ,p_init_msg_list => FND_API.G_FALSE

3421: IF l_batch_id IS NOT NULL THEN
3422: -- Verify the line information for this batch
3423: OZF_TRACING_ORDER_PVT.Validate_Order_Record (
3424: p_api_version => 1
3425: ,p_init_msg_list => FND_API.G_FALSE
3426: ,p_commit => FND_API.G_FALSE
3427: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3428: ,p_resale_batch_id => l_batch_id
3429: ,x_return_status => l_return_status

Line 3426: ,p_commit => FND_API.G_FALSE

3422: -- Verify the line information for this batch
3423: OZF_TRACING_ORDER_PVT.Validate_Order_Record (
3424: p_api_version => 1
3425: ,p_init_msg_list => FND_API.G_FALSE
3426: ,p_commit => FND_API.G_FALSE
3427: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3428: ,p_resale_batch_id => l_batch_id
3429: ,x_return_status => l_return_status
3430: ,x_msg_data => l_msg_data

Line 3427: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3423: OZF_TRACING_ORDER_PVT.Validate_Order_Record (
3424: p_api_version => 1
3425: ,p_init_msg_list => FND_API.G_FALSE
3426: ,p_commit => FND_API.G_FALSE
3427: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3428: ,p_resale_batch_id => l_batch_id
3429: ,x_return_status => l_return_status
3430: ,x_msg_data => l_msg_data
3431: ,x_msg_count => l_msg_count

Line 3433: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

3429: ,x_return_status => l_return_status
3430: ,x_msg_data => l_msg_data
3431: ,x_msg_count => l_msg_count
3432: );
3433: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3434: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: ELSE

Line 3435: RAISE FND_API.G_EXC_ERROR;

3431: ,x_msg_count => l_msg_count
3432: );
3433: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3434: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: ELSE
3438: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3439: RAISE FND_API.G_EXC_ERROR;

Line 3439: RAISE FND_API.G_EXC_ERROR;

3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: ELSE
3438: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3439: RAISE FND_API.G_EXC_ERROR;
3440: END IF;
3441: l_resultout := 'COMPLETE:SUCCESS';
3442: --
3443: ELSIF (funcmode = 'CANCEL') THEN

Line 3454: WHEN FND_API.G_EXC_ERROR THEN

3450:
3451: resultout := l_resultout;
3452:
3453: EXCEPTION
3454: WHEN FND_API.G_EXC_ERROR THEN
3455: FND_MSG_PUB.Count_And_Get (
3456: p_encoded => FND_API.G_FALSE,
3457: p_count => l_msg_count,
3458: p_data => l_msg_data

Line 3456: p_encoded => FND_API.G_FALSE,

3452:
3453: EXCEPTION
3454: WHEN FND_API.G_EXC_ERROR THEN
3455: FND_MSG_PUB.Count_And_Get (
3456: p_encoded => FND_API.G_FALSE,
3457: p_count => l_msg_count,
3458: p_data => l_msg_data
3459: );
3460: Handle_Error(

Line 3476: p_encoded => FND_API.G_FALSE,

3472: IF OZF_UNEXP_ERROR THEN
3473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3474: END IF;
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => l_msg_count,
3478: p_data => l_msg_data
3479: );
3480: Handle_Error(

Line 3609: WHEN FND_API.G_EXC_ERROR THEN

3605: );
3606:
3607:
3608: EXCEPTION
3609: WHEN FND_API.G_EXC_ERROR THEN
3610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3611: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3612: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3613: FND_MSG_PUB.Add;

Line 3616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3612: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3613: FND_MSG_PUB.Add;
3614: END IF;
3615: RAISE;
3616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3618: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3619: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3620: FND_MSG_PUB.Add;

Line 3745: WHEN FND_API.G_EXC_ERROR THEN

3741: );
3742:
3743:
3744: EXCEPTION
3745: WHEN FND_API.G_EXC_ERROR THEN
3746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3747: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3748: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3749: FND_MSG_PUB.Add;

Line 3752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3748: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3749: FND_MSG_PUB.Add;
3750: END IF;
3751: RAISE;
3752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3754: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3755: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3756: FND_MSG_PUB.Add;