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_AUTOPAY_PVT dependencies on FND_MSG_PUB

Line 27: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

23: G_CLAIM_STATUS CONSTANT VARCHAR2(30) := 'OZF_CLAIM_STATUS';
24: G_OPEN_STATUS CONSTANT VARCHAR2(30) := 'OPEN';
25: G_CLOSED_STATUS CONSTANT VARCHAR2(30) := 'CLOSED';
26:
27: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
28: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
29:
30: ---------------------------------------------------------------------
31: -- Definitions of some packagewise cursors.

Line 28: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

24: G_OPEN_STATUS CONSTANT VARCHAR2(30) := 'OPEN';
25: G_CLOSED_STATUS CONSTANT VARCHAR2(30) := 'CLOSED';
26:
27: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
28: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
29:
30: ---------------------------------------------------------------------
31: -- Definitions of some packagewise cursors.
32: ---------------------------------------------------------------------

Line 120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

116: -- Initialize API return status to sucess
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: IF p_customer_info.claim_currency is null THEN
120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
121: OPEN csr_cust_name(l_cust_account_id);
122: FETCH csr_cust_name INTO l_cust_name_num;
123: CLOSE csr_cust_name;
124:

Line 127: FND_MSG_PUB.ADD;

123: CLOSE csr_cust_name;
124:
125: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CURRENCY_MISS');
126: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
127: FND_MSG_PUB.ADD;
128: END IF;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: END IF;
131:

Line 133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: END IF;
131:
132: IF p_customer_info.payment_method is null THEN
133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
134: OPEN csr_cust_name(l_cust_account_id);
135: FETCH csr_cust_name INTO l_cust_name_num;
136: CLOSE csr_cust_name;
137:

Line 140: FND_MSG_PUB.ADD;

136: CLOSE csr_cust_name;
137:
138: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PYMTHD_MISS');
139: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
140: FND_MSG_PUB.ADD;
141: END IF;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END IF;
144:

Line 148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

144:
145: IF p_customer_info.payment_method = 'CHECK' THEN
146: IF p_customer_info.vendor_id is NULL OR
147: p_customer_info.vendor_site_id is NULL THEN
148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
149: OPEN csr_cust_name(l_cust_account_id);
150: FETCH csr_cust_name INTO l_cust_name_num;
151: CLOSE csr_cust_name;
152:

Line 155: FND_MSG_PUB.ADD;

151: CLOSE csr_cust_name;
152:
153: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_VENDOR_MISS');
154: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
155: FND_MSG_PUB.ADD;
156: END IF;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: END IF;
159: ELSIF p_customer_info.payment_method = 'CREDIT_MEMO' THEN

Line 161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: END IF;
159: ELSIF p_customer_info.payment_method = 'CREDIT_MEMO' THEN
160: IF p_customer_info.site_use_id is NULL THEN
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: OPEN csr_cust_name(l_cust_account_id);
163: FETCH csr_cust_name INTO l_cust_name_num;
164: CLOSE csr_cust_name;
165:

Line 168: FND_MSG_PUB.ADD;

164: CLOSE csr_cust_name;
165:
166: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_SITEID_MISS');
167: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
168: FND_MSG_PUB.ADD;
169: END IF;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: END IF;
172: END IF;

Line 176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

172: END IF;
173:
174: /*
175: IF p_customer_info.org_id is null THEN
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
177: OPEN csr_cust_name(l_cust_account_id);
178: FETCH csr_cust_name INTO l_cust_name_num;
179: CLOSE csr_cust_name;
180:

Line 183: FND_MSG_PUB.add;

179: CLOSE csr_cust_name;
180:
181: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_ORG_ID_MISS');
182: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
183: FND_MSG_PUB.add;
184: END IF;FND_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: END IF;
187: */

Line 184: END IF;FND_MSG_PUB.ADD;

180:
181: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_ORG_ID_MISS');
182: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
183: FND_MSG_PUB.add;
184: END IF;FND_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: END IF;
187: */
188:

Line 192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
193: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');
194: FND_MSG_PUB.add;
195: END IF;
196: END validate_customer_info;

Line 194: FND_MSG_PUB.add;

190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
193: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');
194: FND_MSG_PUB.add;
195: END IF;
196: END validate_customer_info;
197:
198:

Line 241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

237: -- l_return_date := add_months(p_last_date, p_period*6);
238: ELSIF p_type = G_ANNUAL THEN
239: l_return_date := add_months(p_last_date, p_period*12);
240: ELSE
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
242: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_AUPD_MISS');
243: FND_MSG_PUB.add;
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;

Line 243: FND_MSG_PUB.add;

239: l_return_date := add_months(p_last_date, p_period*12);
240: ELSE
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
242: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_AUPD_MISS');
243: FND_MSG_PUB.add;
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: x_pay_date := l_return_date;

Line 366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

362: IF p_autopay_periodicity is NULL OR
363: p_autopay_periodicity_type is NULL THEN
364: -- write to a log file
365: -- skip this customer
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: OPEN csr_cust_name(p_customer_info.cust_account_id);
368: FETCH csr_cust_name INTO l_cust_name_num;
369: CLOSE csr_cust_name;
370:

Line 373: FND_MSG_PUB.ADD;

369: CLOSE csr_cust_name;
370:
371: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PERIOD_MISS');
372: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
373: FND_MSG_PUB.ADD;
374: END IF;
375: RAISE FND_API.g_exc_unexpected_error;
376: --goto end_loop;
377: END IF;

Line 396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

392: x_pay_date => l_last_pay_date,
393: x_return_status => l_return_status
394: );
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: OPEN csr_cust_name(p_customer_info.cust_account_id);
398: FETCH csr_cust_name INTO l_cust_name_num;
399: CLOSE csr_cust_name;
400:

Line 403: FND_MSG_PUB.ADD;

399: CLOSE csr_cust_name;
400:
401: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PAY_DATE_MISS');
402: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
403: FND_MSG_PUB.ADD;
404: END IF;
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407: END IF;

Line 514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

510: END IF;
511: END IF;
512:
513: ELSE
514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
515: OPEN csr_cust_name(p_customer_info.cust_account_id);
516: FETCH csr_cust_name INTO l_cust_name_num;
517: CLOSE csr_cust_name;
518:

Line 521: FND_MSG_PUB.ADD;

517: CLOSE csr_cust_name;
518:
519: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CUST_INELIG');
520: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
521: FND_MSG_PUB.ADD;
522: END IF;
523: RAISE FND_API.g_exc_unexpected_error;
524: END IF;
525: ELSE

Line 526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

522: END IF;
523: RAISE FND_API.g_exc_unexpected_error;
524: END IF;
525: ELSE
526: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: OPEN csr_cust_name(p_customer_info.cust_account_id);
528: FETCH csr_cust_name INTO l_cust_name_num;
529: CLOSE csr_cust_name;
530:

Line 533: FND_MSG_PUB.ADD;

529: CLOSE csr_cust_name;
530:
531: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_AMT_SMALL');
532: FND_MESSAGE.Set_Token('ID', l_cust_name_num);
533: FND_MSG_PUB.ADD;
534: END IF;
535: RAISE FND_API.g_exc_unexpected_error;
536: END IF;
537:

Line 625: FND_MSG_PUB.Add;

621: -- Debug Message
622: IF OZF_DEBUG_LOW_ON THEN
623: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
624: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
625: FND_MSG_PUB.Add;
626: END IF;
627:
628: -- get autopay_flag, reason_code_id
629: OPEN sys_parameter_info_csr;

Line 639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

635: CLOSE sys_parameter_info_csr;
636:
637: -- check reason_code and claim_type from sys_parameters.
638: IF l_auto_reason_code_id is NULL THEN
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_unexpected_error;

Line 641: FND_MSG_PUB.add;

637: -- check reason_code and claim_type from sys_parameters.
638: IF l_auto_reason_code_id is NULL THEN
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_unexpected_error;
644: END IF;
645:

Line 647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

643: RAISE FND_API.g_exc_unexpected_error;
644: END IF;
645:
646: IF l_auto_claim_type_id is NULL THEN
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
648: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
649: FND_MSG_PUB.add;
650: END IF;
651: RAISE FND_API.g_exc_unexpected_error;

Line 649: FND_MSG_PUB.add;

645:
646: IF l_auto_claim_type_id is NULL THEN
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
648: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
649: FND_MSG_PUB.add;
650: END IF;
651: RAISE FND_API.g_exc_unexpected_error;
652: END IF;
653:

Line 706: FND_MSG_PUB.Add;

702: -- Debug Message
703: IF OZF_DEBUG_LOW_ON THEN
704: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
705: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
706: FND_MSG_PUB.Add;
707: END IF;
708:
709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN

Line 712: FND_MSG_PUB.count_and_get (

708:
709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN
711: ROLLBACK TO BDOffer;
712: FND_MSG_PUB.count_and_get (
713: p_encoded => FND_API.g_false
714: ,p_count => l_msg_count
715: ,p_data => l_msg_data
716: );

Line 719: FND_MSG_PUB.count_and_get (

715: ,p_data => l_msg_data
716: );
717: WHEN FND_API.g_exc_unexpected_error THEN
718: ROLLBACK TO BDOffer;
719: FND_MSG_PUB.count_and_get (
720: p_encoded => FND_API.g_false
721: ,p_count => l_msg_count
722: ,p_data => l_msg_data
723: );

Line 726: FND_MSG_PUB.count_and_get (

722: ,p_data => l_msg_data
723: );
724: WHEN OTHERS THEN
725: ROLLBACK TO BDOffer;
726: FND_MSG_PUB.count_and_get (
727: p_encoded => FND_API.g_false
728: ,p_count => l_msg_count
729: ,p_data => l_msg_data
730: );

Line 934: FND_MSG_PUB.Add;

930: -- Debug Message
931: IF OZF_DEBUG_LOW_ON THEN
932: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
933: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
934: FND_MSG_PUB.Add;
935: END IF;
936:
937: --Multiorg Changes
938: MO_GLOBAL.init('OZF');

Line 1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1072: CLOSE sys_parameter_info_csr;
1073:
1074: -- check reason_code and claim_type from sys_parameters.
1075: IF l_auto_reason_code_id is NULL THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
1078: FND_MSG_PUB.add;
1079: END IF;
1080: RAISE FND_API.g_exc_unexpected_error;

Line 1078: FND_MSG_PUB.add;

1074: -- check reason_code and claim_type from sys_parameters.
1075: IF l_auto_reason_code_id is NULL THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_CD_MISSING');
1078: FND_MSG_PUB.add;
1079: END IF;
1080: RAISE FND_API.g_exc_unexpected_error;
1081: END IF;
1082:

Line 1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1080: RAISE FND_API.g_exc_unexpected_error;
1081: END IF;
1082:
1083: IF l_auto_claim_type_id is NULL THEN
1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1085: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
1086: FND_MSG_PUB.add;
1087: END IF;
1088: RAISE FND_API.g_exc_unexpected_error;

Line 1086: FND_MSG_PUB.add;

1082:
1083: IF l_auto_claim_type_id is NULL THEN
1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1085: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CLAIM_TYPE_MISSING');
1086: FND_MSG_PUB.add;
1087: END IF;
1088: RAISE FND_API.g_exc_unexpected_error;
1089: END IF;
1090:

Line 1173: FND_MSG_PUB.initialize;

1169: FND_DSQL.do_binds;
1170:
1171: l_ignore := DBMS_SQL.execute(l_emp_csr);
1172: LOOP
1173: FND_MSG_PUB.initialize;
1174:
1175: IF DBMS_SQL.fetch_rows(l_emp_csr) > 0 THEN
1176: DBMS_SQL.column_value(l_emp_csr, 1, l_offer_pay_method);
1177: DBMS_SQL.column_value(l_emp_csr, 2, l_amount);

Line 1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

1378: OZF_UTILITY_PVT.write_conc_log;
1379: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1380: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO AUTOPAY_CUST;
1386: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');

Line 1391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));

1387: OZF_UTILITY_PVT.write_conc_log;
1388: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1389: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Status : Auto Pay Failed. ');
1391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.count_msg, FND_API.g_false));
1392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1393:
1394: WHEN OTHERS THEN
1395: ROLLBACK TO AUTOPAY_CUST;

Line 1400: FND_MSG_PUB.Add;

1396: FND_FILE.PUT_LINE(FND_FILE.LOG, '===> Failed.');
1397: IF OZF_DEBUG_LOW_ON THEN
1398: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1399: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1400: FND_MSG_PUB.Add;
1401: END IF;
1402: OZF_UTILITY_PVT.write_conc_log;
1403: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End ---*/');
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 1428: FND_MSG_PUB.Add;

1424: -- Debug Message
1425: IF OZF_DEBUG_LOW_ON THEN
1426: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1427: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
1428: FND_MSG_PUB.Add;
1429: END IF;
1430:
1431: -- Write all messages to a log
1432: OZF_UTILITY_PVT.Write_Conc_Log;

Line 1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');

1442:
1443: OZF_UTILITY_PVT.Write_Conc_Log;
1444: ERRBUF := l_msg_data;
1445: RETCODE := 2;
1446: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1447: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1449:
1450: WHEN FND_API.g_exc_unexpected_error THEN

Line 1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: ( Warning:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');

1452:
1453: OZF_UTILITY_PVT.Write_Conc_Log;
1454: ERRBUF := l_msg_data;
1455: RETCODE := 1; -- show status as warning if claim type/reason is missing, Fix for 5158782
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: ( Warning:' || FND_MSG_PUB.get(1, FND_API.g_false)||')');
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
1459:
1460: WHEN OTHERS THEN