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_SETTLEMENT_DOC_PVT dependencies on FND_MESSAGE

Line 305: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

301: END LOOP;
302: CLOSE csr_invoice_credit;
303: ELSE
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
305: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
306: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
307: FND_MSG_PUB.add;
308: END IF;
309: RAISE FND_API.g_exc_error;

Line 306: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');

302: CLOSE csr_invoice_credit;
303: ELSE
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
305: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
306: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
307: FND_MSG_PUB.add;
308: END IF;
309: RAISE FND_API.g_exc_error;
310: END IF;

Line 313: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

309: RAISE FND_API.g_exc_error;
310: END IF;
311: ELSE
312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
313: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
314: FND_MSG_PUB.add;
315: END IF;
316: RAISE FND_API.g_exc_error;
317: END IF;

Line 356: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

352: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
353:
354: ELSE
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
356: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
357: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;

Line 357: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');

353:
354: ELSE
355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
356: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
357: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;
361: END IF;

Line 364: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

360: RAISE FND_API.g_exc_error;
361: END IF;
362: ELSE
363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
364: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
365: FND_MSG_PUB.add;
366: END IF;
367: RAISE FND_API.g_exc_error;
368: END IF;

Line 399: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

395: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
396:
397: ELSE
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
399: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
400: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
401: FND_MSG_PUB.add;
402: END IF;
403: RAISE FND_API.g_exc_error;

Line 400: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');

396:
397: ELSE
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
399: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
400: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
401: FND_MSG_PUB.add;
402: END IF;
403: RAISE FND_API.g_exc_error;
404: END IF;

Line 407: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

403: RAISE FND_API.g_exc_error;
404: END IF;
405: ELSE
406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
407: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
408: FND_MSG_PUB.add;
409: END IF;
410: RAISE FND_API.g_exc_error;
411: END IF;

Line 435: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

431: --l_settlement_doc_tbl(1).settlement_amount := 10; --Need to pass the claim amount
432:
433: ELSE
434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
435: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
436: FND_MSG_PUB.add;
437: END IF;
438: RAISE FND_API.g_exc_error;
439: END IF;

Line 464: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

460: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
461:
462: ELSE
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
464: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
465: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
466: FND_MSG_PUB.add;
467: END IF;
468: RAISE FND_API.g_exc_error;

Line 465: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');

461:
462: ELSE
463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
464: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
465: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
466: FND_MSG_PUB.add;
467: END IF;
468: RAISE FND_API.g_exc_error;
469: END IF;

Line 472: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

468: RAISE FND_API.g_exc_error;
469: END IF;
470: ELSE
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: END IF;

Line 502: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

498: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
499:
500: ELSE
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
502: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
503: FND_MESSAGE.set_token('ID', 'p_adjust_id');
504: FND_MSG_PUB.add;
505: END IF;
506: RAISE FND_API.g_exc_error;

Line 503: FND_MESSAGE.set_token('ID', 'p_adjust_id');

499:
500: ELSE
501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
502: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
503: FND_MESSAGE.set_token('ID', 'p_adjust_id');
504: FND_MSG_PUB.add;
505: END IF;
506: RAISE FND_API.g_exc_error;
507: END IF;

Line 527: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

523: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
524:
525: ELSE
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
527: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
528: FND_MESSAGE.set_token('ID', 'p_adjust_id');
529: FND_MSG_PUB.add;
530: END IF;
531: RAISE FND_API.g_exc_error;

Line 528: FND_MESSAGE.set_token('ID', 'p_adjust_id');

524:
525: ELSE
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
527: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
528: FND_MESSAGE.set_token('ID', 'p_adjust_id');
529: FND_MSG_PUB.add;
530: END IF;
531: RAISE FND_API.g_exc_error;
532: END IF;

Line 535: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

531: RAISE FND_API.g_exc_error;
532: END IF;
533: ELSE
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
535: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
536: FND_MSG_PUB.add;
537: END IF;
538: RAISE FND_API.g_exc_error;
539: END IF;

Line 578: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');

574: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
575:
576: ELSE
577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
578: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
579: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
580: FND_MSG_PUB.add;
581: END IF;
582: RAISE FND_API.g_exc_error;

Line 579: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');

575:
576: ELSE
577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
578: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
579: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
580: FND_MSG_PUB.add;
581: END IF;
582: RAISE FND_API.g_exc_error;
583: END IF;

Line 586: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');

582: RAISE FND_API.g_exc_error;
583: END IF;
584: ELSE
585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
586: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
587: FND_MSG_PUB.add;
588: END IF;
589: RAISE FND_API.g_exc_error;
590: END IF;

Line 835: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');

831: WHERE claim_id = p_claim_rec.claim_id;
832: EXCEPTION
833: WHEN OTHERS THEN
834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
835: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
836: FND_MSG_PUB.add;
837: END IF;
838: IF OZF_DEBUG_LOW_ON THEN
839: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 839: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

835: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
836: FND_MSG_PUB.add;
837: END IF;
838: IF OZF_DEBUG_LOW_ON THEN
839: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
840: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
841: FND_MSG_PUB.Add;
842: END IF;
843: RAISE FND_API.g_exc_unexpected_error;

Line 840: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

836: FND_MSG_PUB.add;
837: END IF;
838: IF OZF_DEBUG_LOW_ON THEN
839: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
840: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
841: FND_MSG_PUB.Add;
842: END IF;
843: RAISE FND_API.g_exc_unexpected_error;
844: END;

Line 904: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

900: WHERE claim_line_id = p_claim_line_id;
901: EXCEPTION
902: WHEN OTHERS THEN
903: IF OZF_DEBUG_LOW_ON THEN
904: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
905: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
906: FND_MSG_PUB.Add;
907: END IF;
908: RAISE FND_API.g_exc_unexpected_error;

Line 905: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

901: EXCEPTION
902: WHEN OTHERS THEN
903: IF OZF_DEBUG_LOW_ON THEN
904: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
905: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
906: FND_MSG_PUB.Add;
907: END IF;
908: RAISE FND_API.g_exc_unexpected_error;
909: END;

Line 1060: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_SUB');

1056: OPEN csr_customer_name(l_claim_rec.cust_account_id);
1057: FETCH csr_customer_name INTO l_customer_name;
1058: CLOSE csr_customer_name;
1059:
1060: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_SUB');
1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:

Line 1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);

1057: FETCH csr_customer_name INTO l_customer_name;
1058: CLOSE csr_customer_name;
1059:
1060: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_SUB');
1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');

Line 1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);

1058: CLOSE csr_customer_name;
1059:
1060: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_SUB');
1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);

Line 1063: l_notif_subject := substrb(fnd_message.get, 1, 400);

1059:
1060: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_SUB');
1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);

Line 1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');

1061: fnd_message.set_token('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);

Line 1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);

1062: fnd_message.set_token('CLAIM_NUMBER', l_claim_rec.claim_number);
1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);
1070: l_notif_body := substrb(fnd_message.get, 1, 4000);

Line 1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);

1063: l_notif_subject := substrb(fnd_message.get, 1, 400);
1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);
1070: l_notif_body := substrb(fnd_message.get, 1, 4000);
1071:

Line 1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);

1064:
1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);
1070: l_notif_body := substrb(fnd_message.get, 1, 4000);
1071:
1072:

Line 1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);

1065: fnd_message.set_name('OZF', 'OZF_NTF_STLMNTDOC_CANCEL_BODY');
1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);
1070: l_notif_body := substrb(fnd_message.get, 1, 4000);
1071:
1072:
1073: ozf_utility_pvt.send_wf_standalone_message(

Line 1070: l_notif_body := substrb(fnd_message.get, 1, 4000);

1066: fnd_message.set_token ('DOCUMENT_NUMBER', l_claim_rec.payment_reference_number);
1067: fnd_message.set_token('CLAIM_NUMBER',l_claim_rec.claim_number);
1068: fnd_message.set_token('CUSTOMER_NAME',l_customer_name);
1069: fnd_message.set_token('SETTLEMENT_METHOD_NAME',l_claim_rec.payment_method);
1070: l_notif_body := substrb(fnd_message.get, 1, 4000);
1071:
1072:
1073: ozf_utility_pvt.send_wf_standalone_message(
1074: p_subject => l_notif_subject

Line 1427: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: x_return_status := FND_API.g_ret_sts_unexp_error;
1426: IF OZF_DEBUG_LOW_ON THEN
1427: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1428: FND_MESSAGE.Set_Token('TEXT','Get_AR_Rec : Error');
1429: FND_MSG_PUB.Add;
1430: END IF;
1431:

Line 1428: FND_MESSAGE.Set_Token('TEXT','Get_AR_Rec : Error');

1424: WHEN OTHERS THEN
1425: x_return_status := FND_API.g_ret_sts_unexp_error;
1426: IF OZF_DEBUG_LOW_ON THEN
1427: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1428: FND_MESSAGE.Set_Token('TEXT','Get_AR_Rec : Error');
1429: FND_MSG_PUB.Add;
1430: END IF;
1431:
1432: END Get_AR_Rec;

Line 1493: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.g_ret_sts_unexp_error;
1492: IF OZF_DEBUG_LOW_ON THEN
1493: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1494: FND_MESSAGE.Set_Token('TEXT','Get_RMA_Setl_Doc_Tbl : Error');
1495: FND_MSG_PUB.Add;
1496: END IF;
1497:

Line 1494: FND_MESSAGE.Set_Token('TEXT','Get_RMA_Setl_Doc_Tbl : Error');

1490: WHEN OTHERS THEN
1491: x_return_status := FND_API.g_ret_sts_unexp_error;
1492: IF OZF_DEBUG_LOW_ON THEN
1493: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1494: FND_MESSAGE.Set_Token('TEXT','Get_RMA_Setl_Doc_Tbl : Error');
1495: FND_MSG_PUB.Add;
1496: END IF;
1497:
1498: END Get_RMA_Setl_Doc_Tbl;

Line 1759: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');

1755: WHERE claim_id = p_claim_id;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1759: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
1760: FND_MSG_PUB.add;
1761: END IF;
1762: IF OZF_DEBUG_LOW_ON THEN
1763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1759: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
1760: FND_MSG_PUB.add;
1761: END IF;
1762: IF OZF_DEBUG_LOW_ON THEN
1763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1764: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1765: FND_MSG_PUB.Add;
1766: END IF;
1767: RAISE FND_API.g_exc_unexpected_error;

Line 1764: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1760: FND_MSG_PUB.add;
1761: END IF;
1762: IF OZF_DEBUG_LOW_ON THEN
1763: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1764: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1765: FND_MSG_PUB.Add;
1766: END IF;
1767: RAISE FND_API.g_exc_unexpected_error;
1768: END;

Line 2185: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2183: WHEN OTHERS THEN
2184: IF OZF_DEBUG_LOW_ON THEN
2185: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2186: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2187: FND_MSG_PUB.Add;
2188: END IF;
2189: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2186: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

2182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2183: WHEN OTHERS THEN
2184: IF OZF_DEBUG_LOW_ON THEN
2185: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2186: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2187: FND_MSG_PUB.Add;
2188: END IF;
2189: x_return_status := FND_API.g_ret_sts_unexp_error;
2190:

Line 2346: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: WHEN OTHERS THEN
2345: IF OZF_DEBUG_LOW_ON THEN
2346: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2347: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2348: FND_MSG_PUB.Add;
2349: END IF;
2350: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2347: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: WHEN OTHERS THEN
2345: IF OZF_DEBUG_LOW_ON THEN
2346: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2347: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2348: FND_MSG_PUB.Add;
2349: END IF;
2350: x_return_status := FND_API.g_ret_sts_unexp_error;
2351:

Line 2728: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726: WHEN OTHERS THEN
2727: IF OZF_DEBUG_LOW_ON THEN
2728: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2729: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2730: FND_MSG_PUB.Add;
2731: END IF;
2732: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2729: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726: WHEN OTHERS THEN
2727: IF OZF_DEBUG_LOW_ON THEN
2728: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2729: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2730: FND_MSG_PUB.Add;
2731: END IF;
2732: x_return_status := FND_API.g_ret_sts_unexp_error;
2733:

Line 3015: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

3011: OPEN csr_claim_lock(l_claim_rma_fetch(i).claim_id);
3012: FETCH csr_claim_lock INTO l_claim_lock_rec;
3013: If (csr_claim_lock%NOTFOUND) then
3014: CLOSE csr_claim_lock;
3015: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
3016: APP_EXCEPTION.RAISE_EXCEPTION;
3017: END IF;
3018: CLOSE csr_claim_lock;
3019: EXCEPTION

Line 3227: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

3223: OPEN csr_claim_lock(l_claim_rma_setl(i).claim_id);
3224: FETCH csr_claim_lock INTO l_claim_lock_rec;
3225: If (csr_claim_lock%NOTFOUND) then
3226: CLOSE csr_claim_lock;
3227: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
3228: APP_EXCEPTION.RAISE_EXCEPTION;
3229: END IF;
3230: CLOSE csr_claim_lock;
3231: EXCEPTION

Line 3542: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

3538: OPEN csr_claim_lock(l_claim_id_ver(i).claim_id);
3539: FETCH csr_claim_lock INTO l_claim_lock_rec;
3540: If (csr_claim_lock%NOTFOUND) then
3541: CLOSE csr_claim_lock;
3542: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
3543: APP_EXCEPTION.RAISE_EXCEPTION;
3544: END IF;
3545: CLOSE csr_claim_lock;
3546: EXCEPTION

Line 4732: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');

4728: x_msg_data => l_msg_data
4729: );
4730: IF l_return_status = FND_API.g_ret_sts_error THEN
4731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4732: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
4733: FND_MSG_PUB.add;
4734: END IF;
4735: RAISE FND_API.g_exc_error;
4736: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4766: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AP_FETCH_ERR');

4762: x_msg_data => l_msg_data
4763: );
4764: IF l_return_status = FND_API.g_ret_sts_error THEN
4765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4766: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AP_FETCH_ERR');
4767: FND_MSG_PUB.add;
4768: END IF;
4769: RAISE FND_API.g_exc_error;
4770: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4799: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');

4795: x_msg_data => l_msg_data
4796: );
4797: IF l_return_status = FND_API.g_ret_sts_error THEN
4798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4799: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
4800: FND_MSG_PUB.add;
4801: END IF;
4802: RAISE FND_API.g_exc_error;
4803: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 5064: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

5060: );
5061: EXCEPTION
5062: WHEN OTHERS THEN
5063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5064: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5065: FND_MESSAGE.Set_Token('TEXT',SQLERRM);
5066: FND_MSG_PUB.add;
5067: END IF;
5068: RAISE FND_API.g_exc_error;

Line 5065: FND_MESSAGE.Set_Token('TEXT',SQLERRM);

5061: EXCEPTION
5062: WHEN OTHERS THEN
5063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5064: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5065: FND_MESSAGE.Set_Token('TEXT',SQLERRM);
5066: FND_MSG_PUB.add;
5067: END IF;
5068: RAISE FND_API.g_exc_error;
5069: END;

Line 5208: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');

5204: -- Varify object_version_number
5205: IF p_settlement_doc_rec.object_version_number is NULL or
5206: p_settlement_doc_rec.object_version_number = FND_API.G_MISS_NUM THEN
5207: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5208: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
5209: FND_MSG_PUB.ADD;
5210: END IF;
5211: RAISE FND_API.G_EXC_ERROR;
5212: END IF;

Line 5220: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');

5216: CLOSE csr_settle_obj_ver;
5217:
5218: IF l_object_version_number <> p_settlement_doc_rec.object_version_number THEN
5219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5220: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
5221: FND_MSG_PUB.ADD;
5222: END IF;
5223: RAISE FND_API.G_EXC_ERROR;
5224: END IF;

Line 5342: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');

5338: );
5339: EXCEPTION
5340: WHEN OTHERS THEN
5341: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5342: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
5343: FND_MSG_PUB.add;
5344: END IF;
5345: RAISE FND_API.g_exc_error;
5346: END;

Line 5515: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

5511: );
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5515: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
5516: FND_MSG_PUB.add;
5517: END IF;
5518: RAISE FND_API.g_exc_error;
5519: END;

Line 5522: FND_MESSAGE.set_name('OZF', 'OZF_REC_VERSION_CHANGED');

5518: RAISE FND_API.g_exc_error;
5519: END;
5520: ELSE
5521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5522: FND_MESSAGE.set_name('OZF', 'OZF_REC_VERSION_CHANGED');
5523: FND_MSG_PUB.add;
5524: END IF;
5525: RAISE FND_API.g_exc_error;
5526: END IF;

Line 5535: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

5531: AND object_version_number = p_object_version_number;
5532:
5533: IF (SQL%NOTFOUND) THEN
5534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5535: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
5536: FND_MSG_PUB.add;
5537: END IF;
5538: RAISE FND_API.g_exc_error;
5539: END IF;

Line 5654: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

5650: FETCH c_Settlement_Doc INTO l_settlement_doc_id;
5651: IF (c_Settlement_Doc%NOTFOUND) THEN
5652: CLOSE c_Settlement_Doc;
5653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5654: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
5655: FND_MSG_PUB.add;
5656: END IF;
5657: RAISE FND_API.g_exc_error;
5658: END IF;

Line 5676: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');

5672: EXCEPTION
5673: WHEN OZF_Utility_PVT.resource_locked THEN
5674: x_return_status := FND_API.g_ret_sts_error;
5675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5676: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
5677: FND_MSG_PUB.add;
5678: END IF;
5679: FND_MSG_PUB.count_and_get(
5680: p_encoded => FND_API.g_false,

Line 6526: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

6522: END IF;
6523:
6524: -- Debug Message
6525: IF OZF_DEBUG_LOW_ON THEN
6526: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6527: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
6528: FND_MSG_PUB.Add;
6529: END IF;
6530:

Line 6527: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

6523:
6524: -- Debug Message
6525: IF OZF_DEBUG_LOW_ON THEN
6526: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6527: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
6528: FND_MSG_PUB.Add;
6529: END IF;
6530:
6531: --Initialize message list if p_init_msg_list is TRUE.

Line 6571: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

6567: END LOOP;
6568:
6569: -- Debug Message
6570: IF OZF_DEBUG_LOW_ON THEN
6571: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6572: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6573: FND_MSG_PUB.Add;
6574: END IF;
6575: --Standard call to get message count and if count=1, get the message

Line 6572: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

6568:
6569: -- Debug Message
6570: IF OZF_DEBUG_LOW_ON THEN
6571: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6572: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6573: FND_MSG_PUB.Add;
6574: END IF;
6575: --Standard call to get message count and if count=1, get the message
6576: FND_MSG_PUB.Count_And_Get (

Line 6647: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

6643: END IF;
6644:
6645: -- Debug Message
6646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6647: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6648: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
6649: FND_MSG_PUB.Add;
6650: END IF;
6651:

Line 6648: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');

6644:
6645: -- Debug Message
6646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6647: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6648: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
6649: FND_MSG_PUB.Add;
6650: END IF;
6651:
6652: --Initialize message list if p_init_msg_list is TRUE.

Line 6686: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

6682: END LOOP;
6683:
6684: -- Debug Message
6685: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6686: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6687: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6688: FND_MSG_PUB.Add;
6689: END IF;
6690: --Standard call to get message count and if count=1, get the message

Line 6687: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

6683:
6684: -- Debug Message
6685: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6686: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6687: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6688: FND_MSG_PUB.Add;
6689: END IF;
6690: --Standard call to get message count and if count=1, get the message
6691: FND_MSG_PUB.Count_And_Get (