APPS.OZF_SETTLEMENT_DOC_PVT dependencies on FND_MSG_PUB

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

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Settlement_Doc_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvcsdb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9:
10: TYPE g_payment_method_tbl IS TABLE OF VARCHAR2(30)
11: INDEX BY BINARY_INTEGER;

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Settlement_Doc_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvcsdb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9:
10: TYPE g_payment_method_tbl IS TABLE OF VARCHAR2(30)
11: INDEX BY BINARY_INTEGER;
12:

Line 118: FND_MSG_PUB.initialize;

114: END IF;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean(p_init_msg_list) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: x_return_status := FND_API.g_ret_sts_success;
122:

Line 189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

185:
186: WHEN OTHERS THEN
187: ROLLBACK TO Get_Settlement_Trx_Type;
188: x_return_status := FND_API.g_ret_sts_unexp_error ;
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
190: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
191: END IF;
192:
193: END Get_Settlement_Trx_Type;

Line 190: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

186: WHEN OTHERS THEN
187: ROLLBACK TO Get_Settlement_Trx_Type;
188: x_return_status := FND_API.g_ret_sts_unexp_error ;
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
190: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
191: END IF;
192:
193: END Get_Settlement_Trx_Type;
194:

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

485: l_counter := l_counter + 1;
486: END LOOP;
487: CLOSE csr_invoice_credit;
488: ELSE
489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
490: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
491: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
492: FND_MSG_PUB.add;
493: END IF;

Line 492: FND_MSG_PUB.add;

488: ELSE
489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
490: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
491: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
492: FND_MSG_PUB.add;
493: END IF;
494: RAISE FND_API.g_exc_error;
495: END IF;
496: ELSE

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

493: END IF;
494: RAISE FND_API.g_exc_error;
495: END IF;
496: ELSE
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
498: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
499: FND_MSG_PUB.add;
500: END IF;
501: RAISE FND_API.g_exc_error;

Line 499: FND_MSG_PUB.add;

495: END IF;
496: ELSE
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
498: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
499: FND_MSG_PUB.add;
500: END IF;
501: RAISE FND_API.g_exc_error;
502: END IF;
503:

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

536: l_settlement_doc_tbl(1).payment_method := 'CREDIT_MEMO';
537: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
538:
539: ELSE
540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
541: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
542: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
543: FND_MSG_PUB.add;
544: END IF;

Line 543: FND_MSG_PUB.add;

539: ELSE
540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
541: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
542: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
543: FND_MSG_PUB.add;
544: END IF;
545: RAISE FND_API.g_exc_error;
546: END IF;
547: ELSE

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

544: END IF;
545: RAISE FND_API.g_exc_error;
546: END IF;
547: ELSE
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
549: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
550: FND_MSG_PUB.add;
551: END IF;
552: RAISE FND_API.g_exc_error;

Line 550: FND_MSG_PUB.add;

546: END IF;
547: ELSE
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
549: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
550: FND_MSG_PUB.add;
551: END IF;
552: RAISE FND_API.g_exc_error;
553: END IF;
554:

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

579: l_settlement_doc_tbl(1).payment_method := 'ON_ACCT_CREDIT';
580: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
581:
582: ELSE
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
585: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
586: FND_MSG_PUB.add;
587: END IF;

Line 586: FND_MSG_PUB.add;

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

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

587: END IF;
588: RAISE FND_API.g_exc_error;
589: END IF;
590: ELSE
591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
592: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
593: FND_MSG_PUB.add;
594: END IF;
595: RAISE FND_API.g_exc_error;

Line 593: FND_MSG_PUB.add;

589: END IF;
590: ELSE
591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
592: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
593: FND_MSG_PUB.add;
594: END IF;
595: RAISE FND_API.g_exc_error;
596: END IF;
597:

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

615: l_settlement_doc_tbl(1).status_code := 'CLOSED';
616: --l_settlement_doc_tbl(1).settlement_amount := 10; --Need to pass the claim amount
617:
618: ELSE
619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
620: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
621: FND_MSG_PUB.add;
622: END IF;
623: RAISE FND_API.g_exc_error;

Line 621: FND_MSG_PUB.add;

617:
618: ELSE
619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
620: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
621: FND_MSG_PUB.add;
622: END IF;
623: RAISE FND_API.g_exc_error;
624: END IF;
625:

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

644: l_settlement_doc_tbl(1).payment_method := 'CHARGEBACK';
645: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
646:
647: ELSE
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
650: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
651: FND_MSG_PUB.add;
652: END IF;

Line 651: FND_MSG_PUB.add;

647: ELSE
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
650: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
651: FND_MSG_PUB.add;
652: END IF;
653: RAISE FND_API.g_exc_error;
654: END IF;
655: ELSE

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

652: END IF;
653: RAISE FND_API.g_exc_error;
654: END IF;
655: ELSE
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
657: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
658: FND_MSG_PUB.add;
659: END IF;
660: RAISE FND_API.g_exc_error;

Line 658: FND_MSG_PUB.add;

654: END IF;
655: ELSE
656: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
657: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
658: FND_MSG_PUB.add;
659: END IF;
660: RAISE FND_API.g_exc_error;
661: END IF;
662:

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

683: l_settlement_doc_tbl(1).payment_method := 'ADJUSTMENT';
684: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
685:
686: ELSE
687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
688: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
689: FND_MESSAGE.set_token('ID', 'p_adjust_id');
690: FND_MSG_PUB.add;
691: END IF;

Line 690: FND_MSG_PUB.add;

686: ELSE
687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
688: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
689: FND_MESSAGE.set_token('ID', 'p_adjust_id');
690: FND_MSG_PUB.add;
691: END IF;
692: RAISE FND_API.g_exc_error;
693: END IF;
694: ELSIF p_deduction_type IN ('RECEIPT_OPM', 'RECEIPT_DED') THEN

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

708: l_settlement_doc_tbl(1).payment_method := 'WRITE_OFF';
709: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
710:
711: ELSE
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
714: FND_MESSAGE.set_token('ID', 'p_adjust_id');
715: FND_MSG_PUB.add;
716: END IF;

Line 715: FND_MSG_PUB.add;

711: ELSE
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
714: FND_MESSAGE.set_token('ID', 'p_adjust_id');
715: FND_MSG_PUB.add;
716: END IF;
717: RAISE FND_API.g_exc_error;
718: END IF;
719: ELSE

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

716: END IF;
717: RAISE FND_API.g_exc_error;
718: END IF;
719: ELSE
720: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
721: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
722: FND_MSG_PUB.add;
723: END IF;
724: RAISE FND_API.g_exc_error;

Line 722: FND_MSG_PUB.add;

718: END IF;
719: ELSE
720: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
721: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
722: FND_MSG_PUB.add;
723: END IF;
724: RAISE FND_API.g_exc_error;
725: END IF;
726:

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

759: l_settlement_doc_tbl(1).payment_method := 'DEBIT_MEMO';
760: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
761:
762: ELSE
763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
764: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
765: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
766: FND_MSG_PUB.add;
767: END IF;

Line 766: FND_MSG_PUB.add;

762: ELSE
763: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
764: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_ID_MISSING');
765: FND_MESSAGE.set_token('ID', 'p_customer_trx_id');
766: FND_MSG_PUB.add;
767: END IF;
768: RAISE FND_API.g_exc_error;
769: END IF;
770:

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

781: l_settlement_doc_tbl(1).claim_id := p_claim_id;
782: l_settlement_doc_tbl(1).payment_method := 'DEBIT_MEMO';
783: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
784: ELSE
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
787: FND_MSG_PUB.add;
788: END IF;
789: RAISE FND_API.g_exc_error;

Line 787: FND_MSG_PUB.add;

783: l_settlement_doc_tbl(1).settlement_date := SYSDATE;
784: ELSE
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('OZF', 'OZF_SETL_UPDPAY_DETL_ERR');
787: FND_MSG_PUB.add;
788: END IF;
789: RAISE FND_API.g_exc_error;
790: END IF;
791:

Line 903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

899: x_return_status := FND_API.g_ret_sts_unexp_error ;
900:
901: WHEN OTHERS THEN
902: x_return_status := FND_API.g_ret_sts_unexp_error ;
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
904: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
905: END IF;
906:
907: END Update_Payment_Detail;

Line 904: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

900:
901: WHEN OTHERS THEN
902: x_return_status := FND_API.g_ret_sts_unexp_error ;
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
904: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
905: END IF;
906:
907: END Update_Payment_Detail;
908:

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

1065: , acctd_amount_remaining = l_acctd_amount_remaining
1066: WHERE claim_id = p_claim_rec.claim_id;
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: IF OZF_DEBUG_LOW_ON THEN

Line 1071: FND_MSG_PUB.add;

1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1070: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
1071: FND_MSG_PUB.add;
1072: END IF;
1073: IF OZF_DEBUG_LOW_ON THEN
1074: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1075: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1076: FND_MSG_PUB.Add;

1072: END IF;
1073: IF OZF_DEBUG_LOW_ON THEN
1074: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1075: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1076: FND_MSG_PUB.Add;
1077: END IF;
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END;
1080:

Line 1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1090: x_return_status := FND_API.g_ret_sts_unexp_error ;
1091:
1092: WHEN OTHERS THEN
1093: x_return_status := FND_API.g_ret_sts_unexp_error ;
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1096: END IF;
1097:
1098: END Update_Claim_Tax_Amount;

Line 1095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1091:
1092: WHEN OTHERS THEN
1093: x_return_status := FND_API.g_ret_sts_unexp_error ;
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1096: END IF;
1097:
1098: END Update_Claim_Tax_Amount;
1099:

Line 1141: FND_MSG_PUB.Add;

1137: WHEN OTHERS THEN
1138: IF OZF_DEBUG_LOW_ON THEN
1139: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1140: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1141: FND_MSG_PUB.Add;
1142: END IF;
1143: RAISE FND_API.g_exc_unexpected_error;
1144: END;
1145:

Line 1158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1154: x_return_status := FND_API.g_ret_sts_unexp_error ;
1155:
1156: WHEN OTHERS THEN
1157: x_return_status := FND_API.g_ret_sts_unexp_error ;
1158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1159: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1160: END IF;
1161:
1162: END Update_Claim_Line_Status;

Line 1159: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1155:
1156: WHEN OTHERS THEN
1157: x_return_status := FND_API.g_ret_sts_unexp_error ;
1158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1159: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1160: END IF;
1161:
1162: END Update_Claim_Line_Status;
1163:

Line 1385: FND_MSG_PUB.Count_And_Get(

1381:
1382: EXCEPTION
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(
1386: p_encoded => FND_API.g_false,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );

Line 1393: FND_MSG_PUB.Count_And_Get(

1389: );
1390:
1391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1393: FND_MSG_PUB.Count_And_Get(
1394: p_encoded => FND_API.g_false,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );

Line 1401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1397: );
1398:
1399: WHEN OTHERS THEN
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1403: END IF;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_encoded => FND_API.g_false,

Line 1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1398:
1399: WHEN OTHERS THEN
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1403: END IF;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_encoded => FND_API.g_false,
1406: p_count => x_msg_count,

Line 1404: FND_MSG_PUB.Count_And_Get(

1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1403: END IF;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_encoded => FND_API.g_false,
1406: p_count => x_msg_count,
1407: p_data => x_msg_data
1408: );

Line 1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1589: CLOSE csr_debit_settlement;
1590: END IF;
1591:
1592: x_return_status := FND_API.g_ret_sts_unexp_error;
1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1594: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1595: END IF;
1596:
1597: END Get_AP_Rec;

Line 1594: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1590: END IF;
1591:
1592: x_return_status := FND_API.g_ret_sts_unexp_error;
1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1594: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1595: END IF;
1596:
1597: END Get_AP_Rec;
1598:

Line 1778: FND_MSG_PUB.Add;

1774: x_return_status := FND_API.g_ret_sts_unexp_error;
1775: IF OZF_DEBUG_LOW_ON THEN
1776: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1777: FND_MESSAGE.Set_Token('TEXT','Get_AR_Rec : Error');
1778: FND_MSG_PUB.Add;
1779: END IF;
1780:
1781: END Get_AR_Rec;
1782:

Line 1844: FND_MSG_PUB.Add;

1840: x_return_status := FND_API.g_ret_sts_unexp_error;
1841: IF OZF_DEBUG_LOW_ON THEN
1842: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1843: FND_MESSAGE.Set_Token('TEXT','Get_RMA_Setl_Doc_Tbl : Error');
1844: FND_MSG_PUB.Add;
1845: END IF;
1846:
1847: END Get_RMA_Setl_Doc_Tbl;
1848:

Line 2095: FND_MSG_PUB.initialize;

2091: END IF;
2092:
2093: -- Initialize message list if p_init_msg_list is set to TRUE.
2094: IF FND_API.to_Boolean(p_init_msg_list) THEN
2095: FND_MSG_PUB.initialize;
2096: END IF;
2097:
2098: x_return_status := FND_API.g_ret_sts_success;
2099:

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

2132: , last_updated_by = NVL(FND_GLOBAL.user_id,-1) -- hbandi added this line of code for resolving the Bug # 9793391 .
2133: WHERE claim_id = p_claim_id;
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2137: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
2138: FND_MSG_PUB.add;
2139: END IF;
2140: IF OZF_DEBUG_LOW_ON THEN

Line 2138: FND_MSG_PUB.add;

2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2137: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_UPD_CLAM_ERR');
2138: FND_MSG_PUB.add;
2139: END IF;
2140: IF OZF_DEBUG_LOW_ON THEN
2141: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2142: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 2143: FND_MSG_PUB.Add;

2139: END IF;
2140: IF OZF_DEBUG_LOW_ON THEN
2141: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2142: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2143: FND_MSG_PUB.Add;
2144: END IF;
2145: RAISE FND_API.g_exc_unexpected_error;
2146: END;
2147:

Line 2514: FND_MSG_PUB.Count_And_Get(

2510: IF FND_API.to_boolean(p_commit) THEN
2511: COMMIT;
2512: END IF;
2513:
2514: FND_MSG_PUB.Count_And_Get(
2515: p_count => x_msg_count,
2516: p_data => x_msg_data
2517: );
2518:

Line 2527: FND_MSG_PUB.Count_And_Get(

2523: EXCEPTION
2524: WHEN FND_API.G_EXC_ERROR THEN
2525: ROLLBACK TO Update_Claim_From_Settlement;
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527: FND_MSG_PUB.Count_And_Get(
2528: p_encoded => FND_API.g_false,
2529: p_count => x_msg_count,
2530: p_data => x_msg_data
2531: );

Line 2536: FND_MSG_PUB.Count_And_Get(

2532:
2533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2534: ROLLBACK TO Update_Claim_From_Settlement;
2535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2536: FND_MSG_PUB.Count_And_Get(
2537: p_encoded => FND_API.g_false,
2538: p_count => x_msg_count,
2539: p_data => x_msg_data
2540: );

Line 2545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2541:
2542: WHEN OTHERS THEN
2543: ROLLBACK TO Update_Claim_From_Settlement;
2544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2547: END IF;
2548: FND_MSG_PUB.Count_And_Get(
2549: p_encoded => FND_API.g_false,

Line 2546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

2542: WHEN OTHERS THEN
2543: ROLLBACK TO Update_Claim_From_Settlement;
2544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2547: END IF;
2548: FND_MSG_PUB.Count_And_Get(
2549: p_encoded => FND_API.g_false,
2550: p_count => x_msg_count,

Line 2548: FND_MSG_PUB.Count_And_Get(

2544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2547: END IF;
2548: FND_MSG_PUB.Count_And_Get(
2549: p_encoded => FND_API.g_false,
2550: p_count => x_msg_count,
2551: p_data => x_msg_data
2552: );

Line 2659: FND_MSG_PUB.Add;

2655: WHEN OTHERS THEN
2656: IF OZF_DEBUG_LOW_ON THEN
2657: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2658: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2659: FND_MSG_PUB.Add;
2660: END IF;
2661: x_return_status := FND_API.g_ret_sts_unexp_error;
2662:
2663: END Split_Claim_Settlement;

Line 2820: FND_MSG_PUB.Add;

2816: WHEN OTHERS THEN
2817: IF OZF_DEBUG_LOW_ON THEN
2818: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2819: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
2820: FND_MSG_PUB.Add;
2821: END IF;
2822: x_return_status := FND_API.g_ret_sts_unexp_error;
2823:
2824: END Create_Write_Off;

Line 3202: FND_MSG_PUB.Add;

3198: WHEN OTHERS THEN
3199: IF OZF_DEBUG_LOW_ON THEN
3200: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3201: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
3202: FND_MSG_PUB.Add;
3203: END IF;
3204: x_return_status := FND_API.g_ret_sts_unexp_error;
3205:
3206: END Process_RMA_settlement;

Line 3400: FND_MSG_PUB.initialize;

3396: END IF;
3397:
3398: -- Initialize message list if p_init_msg_list is set to TRUE.
3399: IF FND_API.to_Boolean(p_init_msg_list) THEN
3400: FND_MSG_PUB.initialize;
3401: END IF;
3402:
3403: x_return_status := FND_API.g_ret_sts_success;
3404:

Line 3478: FND_MSG_PUB.initialize;

3474: DBMS_SQL.close_cursor(l_claim_csr_id);
3475:
3476: IF l_claim_rma_fetch.count > 0 THEN
3477: FOR i IN 1..l_claim_rma_fetch.count LOOP
3478: FND_MSG_PUB.initialize;
3479: BEGIN
3480: SAVEPOINT RMA_CR_FETCH;
3481:
3482: BEGIN

Line 3687: FND_MSG_PUB.initialize;

3683: DBMS_SQL.close_cursor(l_claim_csr_id);
3684:
3685: IF l_claim_rma_setl.count > 0 THEN
3686: FOR i IN 1..l_claim_rma_setl.count LOOP
3687: FND_MSG_PUB.initialize;
3688: BEGIN
3689: SAVEPOINT RMA_SETL;
3690:
3691: IF l_claim_rma_setl(i).claim_id IS NOT NULL AND

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

3756: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3757: OZF_UTILITY_PVT.write_conc_log;
3758: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3760: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3762: l_failed_claims := l_failed_claims + 1;
3763:
3764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3767: --OZF_UTILITY_PVT.debug_message(l_claim_rma_setl(i).claim_number||' --> Failed.');
3768: OZF_UTILITY_PVT.write_conc_log;
3769: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_rma_setl(i).claim_number||' --------------*/');
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
3771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
3772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3773: l_failed_claims := l_failed_claims + 1;
3774:
3775: WHEN OTHERS THEN

Line 3807: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3803: EXCEPTION
3804: WHEN OTHERS THEN
3805: ROLLBACK TO Get_RMA_Settlement;
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3808: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3809: END IF;
3810: FND_MSG_PUB.Count_And_Get(
3811: p_encoded => FND_API.g_false,

Line 3808: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

3804: WHEN OTHERS THEN
3805: ROLLBACK TO Get_RMA_Settlement;
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3808: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3809: END IF;
3810: FND_MSG_PUB.Count_And_Get(
3811: p_encoded => FND_API.g_false,
3812: p_count => x_msg_count,

Line 3810: FND_MSG_PUB.Count_And_Get(

3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3808: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3809: END IF;
3810: FND_MSG_PUB.Count_And_Get(
3811: p_encoded => FND_API.g_false,
3812: p_count => x_msg_count,
3813: p_data => x_msg_data
3814: );

Line 3923: FND_MSG_PUB.initialize;

3919: END IF;
3920:
3921: -- Initialize message list if p_init_msg_list is set to TRUE.
3922: IF FND_API.to_Boolean(p_init_msg_list) THEN
3923: FND_MSG_PUB.initialize;
3924: END IF;
3925:
3926: x_return_status := FND_API.g_ret_sts_success;
3927:

Line 4001: FND_MSG_PUB.initialize;

3997:
3998:
3999: IF l_claim_id_ver.count > 0 THEN
4000: FOR i IN 1..l_claim_id_ver.count LOOP
4001: FND_MSG_PUB.initialize;
4002: l_inv_bal_error := FALSE;
4003: l_deduction_type := NULL;
4004: BEGIN
4005: SAVEPOINT AR_SETTLEMENT;

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

4401: OZF_UTILITY_PVT.write_conc_log;
4402: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4407:
4408: l_failed_claims := l_failed_claims + 1;
4409:

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

4413: OZF_UTILITY_PVT.write_conc_log;
4414: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------- '||l_claim_id_ver(i).claim_number||' ----------------');
4415:
4416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4417: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4419:
4420: l_failed_claims := l_failed_claims + 1;
4421:

Line 4464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4460: EXCEPTION
4461: WHEN OTHERS THEN
4462: ROLLBACK TO Get_Receivable_Settlement;
4463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4465: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4466: END IF;
4467: FND_MSG_PUB.Count_And_Get(
4468: p_encoded => FND_API.g_false,

Line 4465: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

4461: WHEN OTHERS THEN
4462: ROLLBACK TO Get_Receivable_Settlement;
4463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4465: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4466: END IF;
4467: FND_MSG_PUB.Count_And_Get(
4468: p_encoded => FND_API.g_false,
4469: p_count => x_msg_count,

Line 4467: FND_MSG_PUB.Count_And_Get(

4463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4465: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4466: END IF;
4467: FND_MSG_PUB.Count_And_Get(
4468: p_encoded => FND_API.g_false,
4469: p_count => x_msg_count,
4470: p_data => x_msg_data
4471: );

Line 4596: FND_MSG_PUB.initialize;

4592: END IF;
4593:
4594: -- Initialize message list if p_init_msg_list is set to TRUE.
4595: IF FND_API.to_Boolean(p_init_msg_list) THEN
4596: FND_MSG_PUB.initialize;
4597: END IF;
4598:
4599: x_return_status := FND_API.g_ret_sts_success;
4600:

Line 4682: FND_MSG_PUB.initialize;

4678: FOR i IN 1..l_claim_id_ver.count LOOP
4679:
4680: BEGIN
4681: SAVEPOINT AP_SETTLEMENT;
4682: FND_MSG_PUB.initialize;
4683:
4684: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4685: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Claim Number : ' || l_claim_id_ver(i).claim_number);
4686:

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

4975: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4976: OZF_UTILITY_PVT.write_conc_log;
4977: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4978: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4981: l_failed_claims := l_failed_claims + 1;
4982:
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4985: FND_FILE.PUT_LINE(FND_FILE.LOG, l_claim_id_ver(i).claim_number||' --> Failed.');
4986: OZF_UTILITY_PVT.write_conc_log;
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*-------------- '||l_claim_id_ver(i).claim_number||' --------------*/');
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Status : Failed.');
4989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
4990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4991: l_failed_claims := l_failed_claims + 1;
4992:
4993: WHEN OTHERS THEN

Line 5011: FND_MSG_PUB.Count_And_Get(

5007: IF FND_API.to_boolean(p_commit) THEN
5008: COMMIT;
5009: END IF;
5010:
5011: FND_MSG_PUB.Count_And_Get(
5012: p_count => x_msg_count,
5013: p_data => x_msg_data
5014: );
5015:

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

5024: WHEN FND_API.G_EXC_ERROR THEN
5025: ROLLBACK TO Get_Payable_Settlement;
5026: x_return_status := FND_API.g_ret_sts_error;
5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5030: FND_MSG_PUB.Count_And_Get(
5031: p_encoded => FND_API.g_false,
5032: p_count => x_msg_count,

Line 5030: FND_MSG_PUB.Count_And_Get(

5026: x_return_status := FND_API.g_ret_sts_error;
5027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5029: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5030: FND_MSG_PUB.Count_And_Get(
5031: p_encoded => FND_API.g_false,
5032: p_count => x_msg_count,
5033: p_data => x_msg_data
5034: );

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

5036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5037: ROLLBACK TO Get_Payable_Settlement;
5038: x_return_status := FND_API.g_ret_sts_unexp_error;
5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5042: FND_MSG_PUB.Count_And_Get(
5043: p_encoded => FND_API.g_false,
5044: p_count => x_msg_count,

Line 5042: FND_MSG_PUB.Count_And_Get(

5038: x_return_status := FND_API.g_ret_sts_unexp_error;
5039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg, FND_API.g_false));
5041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5042: FND_MSG_PUB.Count_And_Get(
5043: p_encoded => FND_API.g_false,
5044: p_count => x_msg_count,
5045: p_data => x_msg_data
5046: );

Line 5051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5047:
5048: WHEN OTHERS THEN
5049: ROLLBACK TO Get_Payable_Settlement;
5050: x_return_status := FND_API.g_ret_sts_unexp_error;
5051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);

Line 5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5048: WHEN OTHERS THEN
5049: ROLLBACK TO Get_Payable_Settlement;
5050: x_return_status := FND_API.g_ret_sts_unexp_error;
5051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5052: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
5056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 5057: FND_MSG_PUB.Count_And_Get(

5053: END IF;
5054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Fetching for Account Payable Settlement Failed.');
5055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : ' || SQLCODE || ' : ' || SQLERRM);
5056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
5057: FND_MSG_PUB.Count_And_Get(
5058: p_encoded => FND_API.g_false,
5059: p_count => x_msg_count,
5060: p_data => x_msg_data
5061: );

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

5216: x_msg_count => l_msg_count,
5217: x_msg_data => l_msg_data
5218: );
5219: IF l_return_status = FND_API.g_ret_sts_error THEN
5220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5221: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
5222: FND_MSG_PUB.add;
5223: END IF;
5224: RAISE FND_API.g_exc_error;

Line 5222: FND_MSG_PUB.add;

5218: );
5219: IF l_return_status = FND_API.g_ret_sts_error THEN
5220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5221: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
5222: FND_MSG_PUB.add;
5223: END IF;
5224: RAISE FND_API.g_exc_error;
5225: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5226: RAISE FND_API.g_exc_unexpected_error;

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

5250: x_msg_count => l_msg_count,
5251: x_msg_data => l_msg_data
5252: );
5253: IF l_return_status = FND_API.g_ret_sts_error THEN
5254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5255: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AP_FETCH_ERR');
5256: FND_MSG_PUB.add;
5257: END IF;
5258: RAISE FND_API.g_exc_error;

Line 5256: FND_MSG_PUB.add;

5252: );
5253: IF l_return_status = FND_API.g_ret_sts_error THEN
5254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5255: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AP_FETCH_ERR');
5256: FND_MSG_PUB.add;
5257: END IF;
5258: RAISE FND_API.g_exc_error;
5259: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5260: RAISE FND_API.g_exc_unexpected_error;

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

5283: x_msg_count => l_msg_count,
5284: x_msg_data => l_msg_data
5285: );
5286: IF l_return_status = FND_API.g_ret_sts_error THEN
5287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5288: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
5289: FND_MSG_PUB.add;
5290: END IF;
5291: RAISE FND_API.g_exc_error;

Line 5289: FND_MSG_PUB.add;

5285: );
5286: IF l_return_status = FND_API.g_ret_sts_error THEN
5287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5288: FND_MESSAGE.set_name('OZF', 'OZF_SETL_DOC_AR_FETCH_ERR');
5289: FND_MSG_PUB.add;
5290: END IF;
5291: RAISE FND_API.g_exc_error;
5292: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5293: RAISE FND_API.g_exc_unexpected_error;

Line 5421: FND_MSG_PUB.initialize;

5417: OZF_Utility_PVT.debug_message(l_full_name||': start');
5418: END IF;
5419:
5420: IF FND_API.to_boolean(p_init_msg_list) THEN
5421: FND_MSG_PUB.initialize;
5422: END IF;
5423:
5424: IF NOT FND_API.compatible_api_call(
5425: l_api_version,

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

5571: p_wo_rec_trx_id => l_settlement_doc_rec.wo_rec_trx_id
5572: );
5573: EXCEPTION
5574: WHEN OTHERS THEN
5575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5576: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5577: FND_MESSAGE.Set_Token('TEXT',SQLERRM);
5578: FND_MSG_PUB.add;
5579: END IF;

Line 5578: FND_MSG_PUB.add;

5574: WHEN OTHERS THEN
5575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5576: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5577: FND_MESSAGE.Set_Token('TEXT',SQLERRM);
5578: FND_MSG_PUB.add;
5579: END IF;
5580: RAISE FND_API.g_exc_error;
5581: END;
5582:

Line 5591: FND_MSG_PUB.count_and_get(

5587: IF FND_API.to_boolean(p_commit) THEN
5588: COMMIT;
5589: END IF;
5590:
5591: FND_MSG_PUB.count_and_get(
5592: p_encoded => FND_API.g_false,
5593: p_count => x_msg_count,
5594: p_data => x_msg_data
5595: );

Line 5605: FND_MSG_PUB.Count_And_Get (

5601: EXCEPTION
5602: WHEN FND_API.g_exc_error THEN
5603: ROLLBACK TO Create_Settlement_Doc;
5604: x_return_status := FND_API.g_ret_sts_error;
5605: FND_MSG_PUB.Count_And_Get (
5606: p_encoded => FND_API.g_false,
5607: p_count => x_msg_count,
5608: p_data => x_msg_data
5609: );

Line 5614: FND_MSG_PUB.Count_And_Get (

5610:
5611: WHEN FND_API.g_exc_unexpected_error THEN
5612: ROLLBACK TO Create_Settlement_Doc;
5613: x_return_status := FND_API.g_ret_sts_unexp_error;
5614: FND_MSG_PUB.Count_And_Get (
5615: p_encoded => FND_API.g_false,
5616: p_count => x_msg_count,
5617: p_data => x_msg_data
5618: );

Line 5623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5619:
5620: WHEN OTHERS THEN
5621: ROLLBACK TO Create_Settlement_Doc;
5622: x_return_status := FND_API.g_ret_sts_unexp_error;
5623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5624: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get (
5627: p_encoded => FND_API.g_false,

Line 5624: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5620: WHEN OTHERS THEN
5621: ROLLBACK TO Create_Settlement_Doc;
5622: x_return_status := FND_API.g_ret_sts_unexp_error;
5623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5624: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get (
5627: p_encoded => FND_API.g_false,
5628: p_count => x_msg_count,

Line 5626: FND_MSG_PUB.Count_And_Get (

5622: x_return_status := FND_API.g_ret_sts_unexp_error;
5623: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5624: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5625: END IF;
5626: FND_MSG_PUB.Count_And_Get (
5627: p_encoded => FND_API.g_false,
5628: p_count => x_msg_count,
5629: p_data => x_msg_data
5630: );

Line 5710: FND_MSG_PUB.initialize;

5706: OZF_Utility_PVT.debug_message(l_full_name||': start');
5707: END IF;
5708:
5709: IF FND_API.to_boolean(p_init_msg_list) THEN
5710: FND_MSG_PUB.initialize;
5711: END IF;
5712:
5713: IF NOT FND_API.compatible_api_call(
5714: l_api_version,

Line 5733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN

5729: ----------------------- validate ----------------------
5730: -- Varify object_version_number
5731: IF p_settlement_doc_rec.object_version_number is NULL or
5732: p_settlement_doc_rec.object_version_number = FND_API.G_MISS_NUM THEN
5733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5734: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
5735: FND_MSG_PUB.ADD;
5736: END IF;
5737: RAISE FND_API.G_EXC_ERROR;

Line 5735: FND_MSG_PUB.ADD;

5731: IF p_settlement_doc_rec.object_version_number is NULL or
5732: p_settlement_doc_rec.object_version_number = FND_API.G_MISS_NUM THEN
5733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5734: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
5735: FND_MSG_PUB.ADD;
5736: END IF;
5737: RAISE FND_API.G_EXC_ERROR;
5738: END IF;
5739:

Line 5745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN

5741: FETCH csr_settle_obj_ver INTO l_object_version_number;
5742: CLOSE csr_settle_obj_ver;
5743:
5744: IF l_object_version_number <> p_settlement_doc_rec.object_version_number THEN
5745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5746: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
5747: FND_MSG_PUB.ADD;
5748: END IF;
5749: RAISE FND_API.G_EXC_ERROR;

Line 5747: FND_MSG_PUB.ADD;

5743:
5744: IF l_object_version_number <> p_settlement_doc_rec.object_version_number THEN
5745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error) THEN
5746: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
5747: FND_MSG_PUB.ADD;
5748: END IF;
5749: RAISE FND_API.G_EXC_ERROR;
5750: END IF;
5751:

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

5875: p_wo_rec_trx_id => l_complete_doc_rec.wo_rec_trx_id
5876: );
5877: EXCEPTION
5878: WHEN OTHERS THEN
5879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5880: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
5881: FND_MSG_PUB.add;
5882: END IF;
5883: RAISE FND_API.g_exc_error;

Line 5881: FND_MSG_PUB.add;

5877: EXCEPTION
5878: WHEN OTHERS THEN
5879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5880: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
5881: FND_MSG_PUB.add;
5882: END IF;
5883: RAISE FND_API.g_exc_error;
5884: END;
5885:

Line 5937: FND_MSG_PUB.count_and_get(

5933: IF FND_API.to_boolean(p_commit) THEN
5934: COMMIT;
5935: END IF;
5936:
5937: FND_MSG_PUB.count_and_get(
5938: p_encoded => FND_API.g_false,
5939: p_count => x_msg_count,
5940: p_data => x_msg_data
5941: );

Line 5951: FND_MSG_PUB.Count_And_Get (

5947: EXCEPTION
5948: WHEN FND_API.g_exc_error THEN
5949: ROLLBACK TO Update_Settlement_Doc;
5950: x_return_status := FND_API.g_ret_sts_error;
5951: FND_MSG_PUB.Count_And_Get (
5952: p_encoded => FND_API.g_false,
5953: p_count => x_msg_count,
5954: p_data => x_msg_data
5955: );

Line 5960: FND_MSG_PUB.Count_And_Get (

5956:
5957: WHEN FND_API.g_exc_unexpected_error THEN
5958: ROLLBACK TO Update_Settlement_Doc;
5959: x_return_status := FND_API.g_ret_sts_unexp_error;
5960: FND_MSG_PUB.Count_And_Get (
5961: p_encoded => FND_API.g_false,
5962: p_count => x_msg_count,
5963: p_data => x_msg_data
5964: );

Line 5969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5965:
5966: WHEN OTHERS THEN
5967: ROLLBACK TO Update_Settlement_Doc;
5968: x_return_status := FND_API.g_ret_sts_unexp_error;
5969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5970: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5971: END IF;
5972: FND_MSG_PUB.Count_And_Get (
5973: p_encoded => FND_API.g_false,

Line 5970: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5966: WHEN OTHERS THEN
5967: ROLLBACK TO Update_Settlement_Doc;
5968: x_return_status := FND_API.g_ret_sts_unexp_error;
5969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5970: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5971: END IF;
5972: FND_MSG_PUB.Count_And_Get (
5973: p_encoded => FND_API.g_false,
5974: p_count => x_msg_count,

Line 5972: FND_MSG_PUB.Count_And_Get (

5968: x_return_status := FND_API.g_ret_sts_unexp_error;
5969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5970: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5971: END IF;
5972: FND_MSG_PUB.Count_And_Get (
5973: p_encoded => FND_API.g_false,
5974: p_count => x_msg_count,
5975: p_data => x_msg_data
5976: );

Line 6021: FND_MSG_PUB.initialize;

6017: OZF_Utility_PVT.debug_message(l_full_name||': start');
6018: END IF;
6019:
6020: IF FND_API.to_boolean(p_init_msg_list) THEN
6021: FND_MSG_PUB.initialize;
6022: END IF;
6023:
6024: IF NOT FND_API.compatible_api_call(
6025: l_api_version,

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

6048: p_settlement_doc_id => p_settlement_doc_id
6049: );
6050: EXCEPTION
6051: WHEN OTHERS THEN
6052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6053: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6054: FND_MSG_PUB.add;
6055: END IF;
6056: RAISE FND_API.g_exc_error;

Line 6054: FND_MSG_PUB.add;

6050: EXCEPTION
6051: WHEN OTHERS THEN
6052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6053: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6054: FND_MSG_PUB.add;
6055: END IF;
6056: RAISE FND_API.g_exc_error;
6057: END;
6058: ELSE

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

6055: END IF;
6056: RAISE FND_API.g_exc_error;
6057: END;
6058: ELSE
6059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6060: FND_MESSAGE.set_name('OZF', 'OZF_REC_VERSION_CHANGED');
6061: FND_MSG_PUB.add;
6062: END IF;
6063: RAISE FND_API.g_exc_error;

Line 6061: FND_MSG_PUB.add;

6057: END;
6058: ELSE
6059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6060: FND_MESSAGE.set_name('OZF', 'OZF_REC_VERSION_CHANGED');
6061: FND_MSG_PUB.add;
6062: END IF;
6063: RAISE FND_API.g_exc_error;
6064: END IF;
6065:

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

6068: WHERE settlement_doc_id = p_settlement_doc_id
6069: AND object_version_number = p_object_version_number;
6070:
6071: IF (SQL%NOTFOUND) THEN
6072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6073: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6074: FND_MSG_PUB.add;
6075: END IF;
6076: RAISE FND_API.g_exc_error;

Line 6074: FND_MSG_PUB.add;

6070:
6071: IF (SQL%NOTFOUND) THEN
6072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6073: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6074: FND_MSG_PUB.add;
6075: END IF;
6076: RAISE FND_API.g_exc_error;
6077: END IF;
6078: */

Line 6084: FND_MSG_PUB.count_and_get(

6080: IF FND_API.to_boolean(p_commit) THEN
6081: COMMIT;
6082: END IF;
6083:
6084: FND_MSG_PUB.count_and_get(
6085: p_encoded => FND_API.g_false,
6086: p_count => x_msg_count,
6087: p_data => x_msg_data
6088: );

Line 6098: FND_MSG_PUB.Count_And_Get (

6094: EXCEPTION
6095: WHEN FND_API.g_exc_error THEN
6096: ROLLBACK TO Delete_Settlement_Doc;
6097: x_return_status := FND_API.g_ret_sts_error;
6098: FND_MSG_PUB.Count_And_Get (
6099: p_encoded => FND_API.g_false,
6100: p_count => x_msg_count,
6101: p_data => x_msg_data
6102: );

Line 6107: FND_MSG_PUB.Count_And_Get (

6103:
6104: WHEN FND_API.g_exc_unexpected_error THEN
6105: ROLLBACK TO Delete_Settlement_Doc;
6106: x_return_status := FND_API.g_ret_sts_unexp_error;
6107: FND_MSG_PUB.Count_And_Get (
6108: p_encoded => FND_API.g_false,
6109: p_count => x_msg_count,
6110: p_data => x_msg_data
6111: );

Line 6116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6112:
6113: WHEN OTHERS THEN
6114: ROLLBACK TO Delete_Settlement_Doc;
6115: x_return_status := FND_API.g_ret_sts_unexp_error;
6116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6118: END IF;
6119: FND_MSG_PUB.Count_And_Get (
6120: p_encoded => FND_API.g_false,

Line 6117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

6113: WHEN OTHERS THEN
6114: ROLLBACK TO Delete_Settlement_Doc;
6115: x_return_status := FND_API.g_ret_sts_unexp_error;
6116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6118: END IF;
6119: FND_MSG_PUB.Count_And_Get (
6120: p_encoded => FND_API.g_false,
6121: p_count => x_msg_count,

Line 6119: FND_MSG_PUB.Count_And_Get (

6115: x_return_status := FND_API.g_ret_sts_unexp_error;
6116: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6117: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6118: END IF;
6119: FND_MSG_PUB.Count_And_Get (
6120: p_encoded => FND_API.g_false,
6121: p_count => x_msg_count,
6122: p_data => x_msg_data
6123: );

Line 6168: FND_MSG_PUB.initialize;

6164: OZF_Utility_PVT.debug_message(l_full_name||': start');
6165: END IF;
6166:
6167: IF FND_API.to_boolean(p_init_msg_list) THEN
6168: FND_MSG_PUB.initialize;
6169: END IF;
6170:
6171: IF NOT FND_API.compatible_api_call(
6172: l_api_version,

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

6187: OPEN c_Settlement_Doc;
6188: FETCH c_Settlement_Doc INTO l_settlement_doc_id;
6189: IF (c_Settlement_Doc%NOTFOUND) THEN
6190: CLOSE c_Settlement_Doc;
6191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6192: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6193: FND_MSG_PUB.add;
6194: END IF;
6195: RAISE FND_API.g_exc_error;

Line 6193: FND_MSG_PUB.add;

6189: IF (c_Settlement_Doc%NOTFOUND) THEN
6190: CLOSE c_Settlement_Doc;
6191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6192: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6193: FND_MSG_PUB.add;
6194: END IF;
6195: RAISE FND_API.g_exc_error;
6196: END IF;
6197: CLOSE c_Settlement_Doc;

Line 6200: FND_MSG_PUB.count_and_get(

6196: END IF;
6197: CLOSE c_Settlement_Doc;
6198:
6199: -------------------- finish --------------------------
6200: FND_MSG_PUB.count_and_get(
6201: p_encoded => FND_API.g_false,
6202: p_count => x_msg_count,
6203: p_data => x_msg_data
6204: );

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

6209:
6210: EXCEPTION
6211: WHEN OZF_Utility_PVT.resource_locked THEN
6212: x_return_status := FND_API.g_ret_sts_error;
6213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6214: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
6215: FND_MSG_PUB.add;
6216: END IF;
6217: FND_MSG_PUB.count_and_get(

Line 6215: FND_MSG_PUB.add;

6211: WHEN OZF_Utility_PVT.resource_locked THEN
6212: x_return_status := FND_API.g_ret_sts_error;
6213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6214: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
6215: FND_MSG_PUB.add;
6216: END IF;
6217: FND_MSG_PUB.count_and_get(
6218: p_encoded => FND_API.g_false,
6219: p_count => x_msg_count,

Line 6217: FND_MSG_PUB.count_and_get(

6213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6214: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
6215: FND_MSG_PUB.add;
6216: END IF;
6217: FND_MSG_PUB.count_and_get(
6218: p_encoded => FND_API.g_false,
6219: p_count => x_msg_count,
6220: p_data => x_msg_data
6221: );

Line 6225: FND_MSG_PUB.count_and_get(

6221: );
6222:
6223: WHEN FND_API.g_exc_error THEN
6224: x_return_status := FND_API.g_ret_sts_error;
6225: FND_MSG_PUB.count_and_get(
6226: p_encoded => FND_API.g_false,
6227: p_count => x_msg_count,
6228: p_data => x_msg_data
6229: );

Line 6233: FND_MSG_PUB.count_and_get(

6229: );
6230:
6231: WHEN FND_API.g_exc_unexpected_error THEN
6232: x_return_status := FND_API.g_ret_sts_unexp_error ;
6233: FND_MSG_PUB.count_and_get(
6234: p_encoded => FND_API.g_false,
6235: p_count => x_msg_count,
6236: p_data => x_msg_data
6237: );

Line 6241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6237: );
6238:
6239: WHEN OTHERS THEN
6240: x_return_status := FND_API.g_ret_sts_unexp_error ;
6241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6242: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6243: END IF;
6244: FND_MSG_PUB.count_and_get(
6245: p_encoded => FND_API.g_false,

Line 6242: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6238:
6239: WHEN OTHERS THEN
6240: x_return_status := FND_API.g_ret_sts_unexp_error ;
6241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6242: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6243: END IF;
6244: FND_MSG_PUB.count_and_get(
6245: p_encoded => FND_API.g_false,
6246: p_count => x_msg_count,

Line 6244: FND_MSG_PUB.count_and_get(

6240: x_return_status := FND_API.g_ret_sts_unexp_error ;
6241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6242: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6243: END IF;
6244: FND_MSG_PUB.count_and_get(
6245: p_encoded => FND_API.g_false,
6246: p_count => x_msg_count,
6247: p_data => x_msg_data
6248: );

Line 6919: FND_MSG_PUB.initialize;

6915: OZF_Utility_PVT.debug_message(l_full_name||': start');
6916: END IF;
6917:
6918: IF FND_API.to_boolean(p_init_msg_list) THEN
6919: FND_MSG_PUB.initialize;
6920: END IF;
6921:
6922: IF NOT FND_API.compatible_api_call(
6923: l_api_version,

Line 6962: FND_MSG_PUB.count_and_get(

6958: END IF;
6959: END IF;
6960:
6961: -------------------- finish --------------------------
6962: FND_MSG_PUB.count_and_get(
6963: p_encoded => FND_API.g_false,
6964: p_count => x_msg_count,
6965: p_data => x_msg_data
6966: );

Line 6975: FND_MSG_PUB.count_and_get(

6971:
6972: EXCEPTION
6973: WHEN FND_API.g_exc_error THEN
6974: x_return_status := FND_API.g_ret_sts_error;
6975: FND_MSG_PUB.count_and_get(
6976: p_encoded => FND_API.g_false,
6977: p_count => x_msg_count,
6978: p_data => x_msg_data
6979: );

Line 6983: FND_MSG_PUB.count_and_get(

6979: );
6980:
6981: WHEN FND_API.g_exc_unexpected_error THEN
6982: x_return_status := FND_API.g_ret_sts_unexp_error ;
6983: FND_MSG_PUB.count_and_get(
6984: p_encoded => FND_API.g_false,
6985: p_count => x_msg_count,
6986: p_data => x_msg_data
6987: );

Line 6991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6987: );
6988:
6989: WHEN OTHERS THEN
6990: x_return_status := FND_API.g_ret_sts_unexp_error;
6991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6993: END IF;
6994: FND_MSG_PUB.count_and_get(
6995: p_encoded => FND_API.g_false,

Line 6992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6988:
6989: WHEN OTHERS THEN
6990: x_return_status := FND_API.g_ret_sts_unexp_error;
6991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6993: END IF;
6994: FND_MSG_PUB.count_and_get(
6995: p_encoded => FND_API.g_false,
6996: p_count => x_msg_count,

Line 6994: FND_MSG_PUB.count_and_get(

6990: x_return_status := FND_API.g_ret_sts_unexp_error;
6991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6992: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6993: END IF;
6994: FND_MSG_PUB.count_and_get(
6995: p_encoded => FND_API.g_false,
6996: p_count => x_msg_count,
6997: p_data => x_msg_data
6998: );

Line 7066: FND_MSG_PUB.Add;

7062: -- Debug Message
7063: IF OZF_DEBUG_LOW_ON THEN
7064: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7065: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
7066: FND_MSG_PUB.Add;
7067: END IF;
7068:
7069: --Initialize message list if p_init_msg_list is TRUE.
7070: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 7071: FND_MSG_PUB.initialize;

7067: END IF;
7068:
7069: --Initialize message list if p_init_msg_list is TRUE.
7070: IF FND_API.To_Boolean (p_init_msg_list) THEN
7071: FND_MSG_PUB.initialize;
7072: END IF;
7073:
7074: -- Initialize API return status to sucess
7075: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7111: FND_MSG_PUB.Add;

7107: -- Debug Message
7108: IF OZF_DEBUG_LOW_ON THEN
7109: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7110: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7111: FND_MSG_PUB.Add;
7112: END IF;
7113: --Standard call to get message count and if count=1, get the message
7114: FND_MSG_PUB.Count_And_Get (
7115: p_encoded => FND_API.G_FALSE,

Line 7114: FND_MSG_PUB.Count_And_Get (

7110: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7111: FND_MSG_PUB.Add;
7112: END IF;
7113: --Standard call to get message count and if count=1, get the message
7114: FND_MSG_PUB.Count_And_Get (
7115: p_encoded => FND_API.G_FALSE,
7116: p_count => x_msg_count,
7117: p_data => x_msg_data
7118: );

Line 7124: FND_MSG_PUB.Count_And_Get (

7120: WHEN FND_API.G_EXC_ERROR THEN
7121: ROLLBACK TO Create_Settlement_Doc_Tbl;
7122: x_return_status := FND_API.G_RET_STS_ERROR;
7123: -- Standard call to get message count and if count=1, get the message
7124: FND_MSG_PUB.Count_And_Get (
7125: p_encoded => FND_API.G_FALSE,
7126: p_count => x_msg_count,
7127: p_data => x_msg_data
7128: );

Line 7133: FND_MSG_PUB.Count_And_Get (

7129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7130: ROLLBACK TO Create_Settlement_Doc_Tbl;
7131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7132: -- Standard call to get message count and if count=1, get the message
7133: FND_MSG_PUB.Count_And_Get (
7134: p_encoded => FND_API.G_FALSE,
7135: p_count => x_msg_count,
7136: p_data => x_msg_data
7137: );

Line 7142: FND_MSG_PUB.Count_And_Get (

7138: WHEN OTHERS THEN
7139: ROLLBACK TO Create_Settlement_Doc_Tbl;
7140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7141: -- Standard call to get message count and if count=1, get the message
7142: FND_MSG_PUB.Count_And_Get (
7143: p_encoded => FND_API.G_FALSE,
7144: p_count => x_msg_count,
7145: p_data => x_msg_data );
7146:

Line 7184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7181: END IF;
7182:
7183: -- Debug Message
7184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7185: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7186: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
7187: FND_MSG_PUB.Add;
7188: END IF;

Line 7187: FND_MSG_PUB.Add;

7183: -- Debug Message
7184: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7185: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7186: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
7187: FND_MSG_PUB.Add;
7188: END IF;
7189:
7190: --Initialize message list if p_init_msg_list is TRUE.
7191: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 7192: FND_MSG_PUB.initialize;

7188: END IF;
7189:
7190: --Initialize message list if p_init_msg_list is TRUE.
7191: IF FND_API.To_Boolean (p_init_msg_list) THEN
7192: FND_MSG_PUB.initialize;
7193: END IF;
7194:
7195: -- Initialize API return status to sucess
7196: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

7219: END IF;
7220: END LOOP;
7221:
7222: -- Debug Message
7223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7224: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7225: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7226: FND_MSG_PUB.Add;
7227: END IF;

Line 7226: FND_MSG_PUB.Add;

7222: -- Debug Message
7223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7224: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7225: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7226: FND_MSG_PUB.Add;
7227: END IF;
7228: --Standard call to get message count and if count=1, get the message
7229: FND_MSG_PUB.Count_And_Get (
7230: p_encoded => FND_API.G_FALSE,

Line 7229: FND_MSG_PUB.Count_And_Get (

7225: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7226: FND_MSG_PUB.Add;
7227: END IF;
7228: --Standard call to get message count and if count=1, get the message
7229: FND_MSG_PUB.Count_And_Get (
7230: p_encoded => FND_API.G_FALSE,
7231: p_count => x_msg_count,
7232: p_data => x_msg_data
7233: );

Line 7239: FND_MSG_PUB.Count_And_Get (

7235: WHEN FND_API.G_EXC_ERROR THEN
7236: ROLLBACK TO Update_Settlement_Doc_Tbl;
7237: x_return_status := FND_API.G_RET_STS_ERROR;
7238: -- Standard call to get message count and if count=1, get the message
7239: FND_MSG_PUB.Count_And_Get (
7240: p_encoded => FND_API.G_FALSE,
7241: p_count => x_msg_count,
7242: p_data => x_msg_data
7243: );

Line 7248: FND_MSG_PUB.Count_And_Get (

7244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7245: ROLLBACK TO Update_Settlement_Doc_Tbl;
7246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7247: -- Standard call to get message count and if count=1, get the message
7248: FND_MSG_PUB.Count_And_Get (
7249: p_encoded => FND_API.G_FALSE,
7250: p_count => x_msg_count,
7251: p_data => x_msg_data
7252: );

Line 7257: FND_MSG_PUB.Count_And_Get (

7253: WHEN OTHERS THEN
7254: ROLLBACK TO Update_Settlement_Doc_Tbl;
7255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7256: -- Standard call to get message count and if count=1, get the message
7257: FND_MSG_PUB.Count_And_Get (
7258: p_encoded => FND_API.G_FALSE,
7259: p_count => x_msg_count,
7260: p_data => x_msg_data
7261: );