DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on FND_MSG_PUB

Line 195: FND_MSG_PUB.Count_And_Get

191: ---- End Added by Vpanwar --- Code for new accounting API uptake
192: /*** End API body ******************************************************/
193:
194: -- Get message count and if count is 1, get message info
195: FND_MSG_PUB.Count_And_Get
196: (p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: EXCEPTION

Line 203: FND_MSG_PUB.Count_And_Get

199: EXCEPTION
200: WHEN OKL_API.G_EXCEPTION_ERROR THEN
201: ROLLBACK TO CREATE_ACCOUNTING_DIST;
202: x_return_status := OKL_API.G_RET_STS_ERROR;
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data);
206:
207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 210: FND_MSG_PUB.Count_And_Get

206:
207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
208: ROLLBACK TO CREATE_ACCOUNTING_DIST;
209: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data);
213:
214: WHEN OTHERS THEN

Line 223: FND_MSG_PUB.Count_And_Get

219: p_token1 => G_SQLCODE_TOKEN,
220: p_token1_value => SQLCODE,
221: p_token2 => G_SQLERRM_TOKEN,
222: p_token2_value => SQLERRM);
223: FND_MSG_PUB.Count_And_Get
224: (p_count => x_msg_count,
225: p_data => x_msg_data);
226:
227: END create_accounting_dist;

Line 435: FND_MSG_PUB.initialize;

431: END IF;
432:
433: -- Initialize message list if requested
434: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- Initialize API status to success
439: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 807: FND_MSG_PUB.Count_And_Get

803:
804: /*** End API body ******************************************************/
805:
806: -- Get message count and if count is 1, get message info
807: FND_MSG_PUB.Count_And_Get
808: (p_count => x_msg_count,
809: p_data => x_msg_data);
810:
811: EXCEPTION

Line 815: FND_MSG_PUB.Count_And_Get

811: EXCEPTION
812: WHEN OKL_API.G_EXCEPTION_ERROR THEN
813: ROLLBACK TO additional_tai_attr;
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_And_Get
816: (p_count => x_msg_count,
817: p_data => x_msg_data);
818:
819: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 822: FND_MSG_PUB.Count_And_Get

818:
819: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
820: ROLLBACK TO additional_tai_attr;
821: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get
823: (p_count => x_msg_count,
824: p_data => x_msg_data);
825:
826: WHEN OTHERS THEN

Line 835: FND_MSG_PUB.Count_And_Get

831: p_token1 => G_SQLCODE_TOKEN,
832: p_token1_value => SQLCODE,
833: p_token2 => G_SQLERRM_TOKEN,
834: p_token2_value => SQLERRM);
835: FND_MSG_PUB.Count_And_Get
836: (p_count => x_msg_count,
837: p_data => x_msg_data);
838:
839: end additional_tai_attr;

Line 890: FND_MSG_PUB.initialize;

886: END IF;
887:
888: -- Initialize message list if requested
889: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: -- Initialize API status to success
894: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 914: FND_MSG_PUB.Count_And_Get

910:
911: /*** End API body ******************************************************/
912:
913: -- Get message count and if count is 1, get message info
914: FND_MSG_PUB.Count_And_Get
915: (p_count => x_msg_count,
916: p_data => x_msg_data);
917:
918: EXCEPTION

Line 922: FND_MSG_PUB.Count_And_Get

918: EXCEPTION
919: WHEN OKL_API.G_EXCEPTION_ERROR THEN
920: ROLLBACK TO additional_til_attr;
921: x_return_status := OKL_API.G_RET_STS_ERROR;
922: FND_MSG_PUB.Count_And_Get
923: (p_count => x_msg_count,
924: p_data => x_msg_data);
925:
926: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 929: FND_MSG_PUB.Count_And_Get

925:
926: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
927: ROLLBACK TO additional_til_attr;
928: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
929: FND_MSG_PUB.Count_And_Get
930: (p_count => x_msg_count,
931: p_data => x_msg_data);
932:
933: WHEN OTHERS THEN

Line 942: FND_MSG_PUB.Count_And_Get

938: p_token1 => G_SQLCODE_TOKEN,
939: p_token1_value => SQLCODE,
940: p_token2 => G_SQLERRM_TOKEN,
941: p_token2_value => SQLERRM);
942: FND_MSG_PUB.Count_And_Get
943: (p_count => x_msg_count,
944: p_data => x_msg_data);
945:
946: end additional_til_attr;

Line 1035: FND_MSG_PUB.initialize;

1031: END IF;
1032:
1033: -- Initialize message list if requested
1034: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1035: FND_MSG_PUB.initialize;
1036: END IF;
1037:
1038: -- Initialize API status to success
1039: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1102: FND_MSG_PUB.Count_And_Get

1098: --TIL
1099: /*** End API body ******************************************************/
1100:
1101: -- Get message count and if count is 1, get message info
1102: FND_MSG_PUB.Count_And_Get
1103: (p_count => x_msg_count,
1104: p_data => x_msg_data);
1105:
1106: EXCEPTION

Line 1110: FND_MSG_PUB.Count_And_Get

1106: EXCEPTION
1107: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1108: ROLLBACK TO additional_tld_attr;
1109: x_return_status := OKL_API.G_RET_STS_ERROR;
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count,
1112: p_data => x_msg_data);
1113:
1114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1117: FND_MSG_PUB.Count_And_Get

1113:
1114: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1115: ROLLBACK TO additional_tld_attr;
1116: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1117: FND_MSG_PUB.Count_And_Get
1118: (p_count => x_msg_count,
1119: p_data => x_msg_data);
1120:
1121: WHEN OTHERS THEN

Line 1130: FND_MSG_PUB.Count_And_Get

1126: p_token1 => G_SQLCODE_TOKEN,
1127: p_token1_value => SQLCODE,
1128: p_token2 => G_SQLERRM_TOKEN,
1129: p_token2_value => SQLERRM);
1130: FND_MSG_PUB.Count_And_Get
1131: (p_count => x_msg_count,
1132: p_data => x_msg_data);
1133:
1134: end additional_tld_attr;

Line 1804: FND_MSG_PUB.initialize;

1800: END IF;
1801:
1802: -- Initialize message list if requested
1803: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1804: FND_MSG_PUB.initialize;
1805: END IF;
1806:
1807: -- Initialize API status to success
1808: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2192: FND_MSG_PUB.Count_And_Get

2188:
2189: /*** End API body ******************************************************/
2190:
2191: -- Get message count and if count is 1, get message info
2192: FND_MSG_PUB.Count_And_Get
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data);
2195:
2196: EXCEPTION

Line 2200: FND_MSG_PUB.Count_And_Get

2196: EXCEPTION
2197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2198: ROLLBACK TO create_non_sel_billing_trx;
2199: x_return_status := OKL_API.G_RET_STS_ERROR;
2200: FND_MSG_PUB.Count_And_Get
2201: (p_count => x_msg_count,
2202: p_data => x_msg_data);
2203:
2204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2207: FND_MSG_PUB.Count_And_Get

2203:
2204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2205: ROLLBACK TO create_non_sel_billing_trx;
2206: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2207: FND_MSG_PUB.Count_And_Get
2208: (p_count => x_msg_count,
2209: p_data => x_msg_data);
2210:
2211: WHEN OTHERS THEN

Line 2221: FND_MSG_PUB.Count_And_Get

2217: p_token1 => G_SQLCODE_TOKEN,
2218: p_token1_value => SQLCODE,
2219: p_token2 => G_SQLERRM_TOKEN,
2220: p_token2_value => SQLERRM);
2221: FND_MSG_PUB.Count_And_Get
2222: (p_count => x_msg_count,
2223: p_data => x_msg_data);
2224: end create_non_sel_billing_trx;
2225:

Line 2359: FND_MSG_PUB.initialize;

2355: END IF;
2356:
2357: -- Initialize message list if requested
2358: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2359: FND_MSG_PUB.initialize;
2360: END IF;
2361:
2362: -- Initialize API status to success
2363: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2727: FND_MSG_PUB.Count_And_Get

2723:
2724: /*** End API body ******************************************************/
2725:
2726: -- Get message count and if count is 1, get message info
2727: FND_MSG_PUB.Count_And_Get
2728: (p_count => x_msg_count,
2729: p_data => x_msg_data);
2730:
2731: EXCEPTION

Line 2735: FND_MSG_PUB.Count_And_Get

2731: EXCEPTION
2732: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2733: ROLLBACK TO create_sel_billing_trx;
2734: x_return_status := OKL_API.G_RET_STS_ERROR;
2735: FND_MSG_PUB.Count_And_Get
2736: (p_count => x_msg_count,
2737: p_data => x_msg_data);
2738:
2739: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2742: FND_MSG_PUB.Count_And_Get

2738:
2739: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2740: ROLLBACK TO create_sel_billing_trx;
2741: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2742: FND_MSG_PUB.Count_And_Get
2743: (p_count => x_msg_count,
2744: p_data => x_msg_data);
2745:
2746: WHEN OTHERS THEN

Line 2755: FND_MSG_PUB.Count_And_Get

2751: p_token1 => G_SQLCODE_TOKEN,
2752: p_token1_value => SQLCODE,
2753: p_token2 => G_SQLERRM_TOKEN,
2754: p_token2_value => SQLERRM);
2755: FND_MSG_PUB.Count_And_Get
2756: (p_count => x_msg_count,
2757: p_data => x_msg_data);
2758: end create_sel_billing_trx;
2759:

Line 2900: FND_MSG_PUB.initialize;

2896: END IF;
2897:
2898: -- Initialize message list if requested
2899: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2900: FND_MSG_PUB.initialize;
2901: END IF;
2902:
2903: -- Initialize API status to success
2904: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2985: FND_MSG_PUB.Count_And_Get

2981:
2982: /*** End API body ******************************************************/
2983:
2984: -- Get message count and if count is 1, get message info
2985: FND_MSG_PUB.Count_And_Get
2986: (p_count => x_msg_count,
2987: p_data => x_msg_data);
2988:
2989: EXCEPTION

Line 2993: FND_MSG_PUB.Count_And_Get

2989: EXCEPTION
2990: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2991: ROLLBACK TO CREATE_BILLING_TRX;
2992: x_return_status := OKL_API.G_RET_STS_ERROR;
2993: FND_MSG_PUB.Count_And_Get
2994: (p_count => x_msg_count,
2995: p_data => x_msg_data);
2996:
2997: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3000: FND_MSG_PUB.Count_And_Get

2996:
2997: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2998: ROLLBACK TO CREATE_BILLING_TRX;
2999: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3000: FND_MSG_PUB.Count_And_Get
3001: (p_count => x_msg_count,
3002: p_data => x_msg_data);
3003:
3004: WHEN OTHERS THEN

Line 3013: FND_MSG_PUB.Count_And_Get

3009: p_token1 => G_SQLCODE_TOKEN,
3010: p_token1_value => SQLCODE,
3011: p_token2 => G_SQLERRM_TOKEN,
3012: p_token2_value => SQLERRM);
3013: FND_MSG_PUB.Count_And_Get
3014: (p_count => x_msg_count,
3015: p_data => x_msg_data);
3016:
3017: end CREATE_BILLING_TRX;

Line 3099: FND_MSG_PUB.initialize;

3095: END IF;
3096:
3097: -- Initialize message list if requested
3098: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3099: FND_MSG_PUB.initialize;
3100: END IF;
3101:
3102: -- Initialize API status to success
3103: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3134: FND_MSG_PUB.Count_And_Get

3130:
3131: /*** End API body ******************************************************/
3132:
3133: -- Get message count and if count is 1, get message info
3134: FND_MSG_PUB.Count_And_Get
3135: (p_count => x_msg_count,
3136: p_data => x_msg_data);
3137:
3138: EXCEPTION

Line 3142: FND_MSG_PUB.Count_And_Get

3138: EXCEPTION
3139: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3140: ROLLBACK TO Get_Invoice_format;
3141: x_return_status := OKL_API.G_RET_STS_ERROR;
3142: FND_MSG_PUB.Count_And_Get
3143: (p_count => x_msg_count,
3144: p_data => x_msg_data);
3145:
3146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3149: FND_MSG_PUB.Count_And_Get

3145:
3146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3147: ROLLBACK TO Get_Invoice_format;
3148: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3149: FND_MSG_PUB.Count_And_Get
3150: (p_count => x_msg_count,
3151: p_data => x_msg_data);
3152:
3153: WHEN OTHERS THEN

Line 3162: FND_MSG_PUB.Count_And_Get

3158: p_token1 => G_SQLCODE_TOKEN,
3159: p_token1_value => SQLCODE,
3160: p_token2 => G_SQLERRM_TOKEN,
3161: p_token2_value => SQLERRM);
3162: FND_MSG_PUB.Count_And_Get
3163: (p_count => x_msg_count,
3164: p_data => x_msg_data);
3165:
3166: end Get_Invoice_format;

Line 3541: FND_MSG_PUB.Count_And_Get

3537: END IF;
3538:
3539:
3540: -- Get message count and if count is 1, get message info
3541: FND_MSG_PUB.Count_And_Get
3542: (p_count => x_msg_count,
3543: p_data => x_msg_data);
3544:
3545: EXCEPTION

Line 3549: FND_MSG_PUB.Count_And_Get

3545: EXCEPTION
3546: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3547: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3548: x_return_status := OKL_API.G_RET_STS_ERROR;
3549: FND_MSG_PUB.Count_And_Get
3550: (p_count => x_msg_count,
3551: p_data => x_msg_data);
3552:
3553: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3556: FND_MSG_PUB.Count_And_Get

3552:
3553: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3554: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3555: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3556: FND_MSG_PUB.Count_And_Get
3557: (p_count => x_msg_count,
3558: p_data => x_msg_data);
3559:
3560: WHEN OTHERS THEN

Line 3569: FND_MSG_PUB.Count_And_Get

3565: p_token1 => G_SQLCODE_TOKEN,
3566: p_token1_value => SQLCODE,
3567: p_token2 => G_SQLERRM_TOKEN,
3568: p_token2_value => SQLERRM);
3569: FND_MSG_PUB.Count_And_Get
3570: (p_count => x_msg_count,
3571: p_data => x_msg_data);
3572:
3573:

Line 3750: FND_MSG_PUB.Count_And_Get

3746:
3747:
3748:
3749: -- Get message count and if count is 1, get message info
3750: FND_MSG_PUB.Count_And_Get
3751: (p_count => x_msg_count,
3752: p_data => x_msg_data);
3753:
3754: EXCEPTION

Line 3758: FND_MSG_PUB.Count_And_Get

3754: EXCEPTION
3755: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3756: ROLLBACK TO DELETE_MANUAL_INVOICE;
3757: x_return_status := OKL_API.G_RET_STS_ERROR;
3758: FND_MSG_PUB.Count_And_Get
3759: (p_count => x_msg_count,
3760: p_data => x_msg_data);
3761:
3762: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3765: FND_MSG_PUB.Count_And_Get

3761:
3762: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3763: ROLLBACK TO DELETE_MANUAL_INVOICE;
3764: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3765: FND_MSG_PUB.Count_And_Get
3766: (p_count => x_msg_count,
3767: p_data => x_msg_data);
3768:
3769: WHEN OTHERS THEN

Line 3778: FND_MSG_PUB.Count_And_Get

3774: p_token1 => G_SQLCODE_TOKEN,
3775: p_token1_value => SQLCODE,
3776: p_token2 => G_SQLERRM_TOKEN,
3777: p_token2_value => SQLERRM);
3778: FND_MSG_PUB.Count_And_Get
3779: (p_count => x_msg_count,
3780: p_data => x_msg_data);
3781:
3782: