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 459: FND_MSG_PUB.initialize;

455: END IF;
456:
457: -- Initialize message list if requested
458: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: -- Initialize API status to success
463: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 910: FND_MSG_PUB.Count_And_Get

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

Line 918: FND_MSG_PUB.Count_And_Get

914: EXCEPTION
915: WHEN OKL_API.G_EXCEPTION_ERROR THEN
916: ROLLBACK TO additional_tai_attr;
917: x_return_status := OKL_API.G_RET_STS_ERROR;
918: FND_MSG_PUB.Count_And_Get
919: (p_count => x_msg_count,
920: p_data => x_msg_data);
921:
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 925: FND_MSG_PUB.Count_And_Get

921:
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
923: ROLLBACK TO additional_tai_attr;
924: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data);
928:
929: WHEN OTHERS THEN

Line 938: FND_MSG_PUB.Count_And_Get

934: p_token1 => G_SQLCODE_TOKEN,
935: p_token1_value => SQLCODE,
936: p_token2 => G_SQLERRM_TOKEN,
937: p_token2_value => SQLERRM);
938: FND_MSG_PUB.Count_And_Get
939: (p_count => x_msg_count,
940: p_data => x_msg_data);
941:
942: end additional_tai_attr;

Line 993: FND_MSG_PUB.initialize;

989: END IF;
990:
991: -- Initialize message list if requested
992: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995:
996: -- Initialize API status to success
997: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1017: FND_MSG_PUB.Count_And_Get

1013:
1014: /*** End API body ******************************************************/
1015:
1016: -- Get message count and if count is 1, get message info
1017: FND_MSG_PUB.Count_And_Get
1018: (p_count => x_msg_count,
1019: p_data => x_msg_data);
1020:
1021: EXCEPTION

Line 1025: FND_MSG_PUB.Count_And_Get

1021: EXCEPTION
1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1023: ROLLBACK TO additional_til_attr;
1024: x_return_status := OKL_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get
1026: (p_count => x_msg_count,
1027: p_data => x_msg_data);
1028:
1029: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1032: FND_MSG_PUB.Count_And_Get

1028:
1029: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1030: ROLLBACK TO additional_til_attr;
1031: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1032: FND_MSG_PUB.Count_And_Get
1033: (p_count => x_msg_count,
1034: p_data => x_msg_data);
1035:
1036: WHEN OTHERS THEN

Line 1045: FND_MSG_PUB.Count_And_Get

1041: p_token1 => G_SQLCODE_TOKEN,
1042: p_token1_value => SQLCODE,
1043: p_token2 => G_SQLERRM_TOKEN,
1044: p_token2_value => SQLERRM);
1045: FND_MSG_PUB.Count_And_Get
1046: (p_count => x_msg_count,
1047: p_data => x_msg_data);
1048:
1049: end additional_til_attr;

Line 1138: FND_MSG_PUB.initialize;

1134: END IF;
1135:
1136: -- Initialize message list if requested
1137: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1138: FND_MSG_PUB.initialize;
1139: END IF;
1140:
1141: -- Initialize API status to success
1142: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1205: FND_MSG_PUB.Count_And_Get

1201: --TIL
1202: /*** End API body ******************************************************/
1203:
1204: -- Get message count and if count is 1, get message info
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: EXCEPTION

Line 1213: FND_MSG_PUB.Count_And_Get

1209: EXCEPTION
1210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1211: ROLLBACK TO additional_tld_attr;
1212: x_return_status := OKL_API.G_RET_STS_ERROR;
1213: FND_MSG_PUB.Count_And_Get
1214: (p_count => x_msg_count,
1215: p_data => x_msg_data);
1216:
1217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1220: FND_MSG_PUB.Count_And_Get

1216:
1217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1218: ROLLBACK TO additional_tld_attr;
1219: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1220: FND_MSG_PUB.Count_And_Get
1221: (p_count => x_msg_count,
1222: p_data => x_msg_data);
1223:
1224: WHEN OTHERS THEN

Line 1233: FND_MSG_PUB.Count_And_Get

1229: p_token1 => G_SQLCODE_TOKEN,
1230: p_token1_value => SQLCODE,
1231: p_token2 => G_SQLERRM_TOKEN,
1232: p_token2_value => SQLERRM);
1233: FND_MSG_PUB.Count_And_Get
1234: (p_count => x_msg_count,
1235: p_data => x_msg_data);
1236:
1237: end additional_tld_attr;

Line 1963: FND_MSG_PUB.initialize;

1959: END IF;
1960:
1961: -- Initialize message list if requested
1962: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1963: FND_MSG_PUB.initialize;
1964: END IF;
1965:
1966: -- Initialize API status to success
1967: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2361: FND_MSG_PUB.Count_And_Get

2357:
2358: /*** End API body ******************************************************/
2359:
2360: -- Get message count and if count is 1, get message info
2361: FND_MSG_PUB.Count_And_Get
2362: (p_count => x_msg_count,
2363: p_data => x_msg_data);
2364:
2365: EXCEPTION

Line 2369: FND_MSG_PUB.Count_And_Get

2365: EXCEPTION
2366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2367: ROLLBACK TO create_non_sel_billing_trx;
2368: x_return_status := OKL_API.G_RET_STS_ERROR;
2369: FND_MSG_PUB.Count_And_Get
2370: (p_count => x_msg_count,
2371: p_data => x_msg_data);
2372:
2373: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2376: FND_MSG_PUB.Count_And_Get

2372:
2373: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2374: ROLLBACK TO create_non_sel_billing_trx;
2375: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2376: FND_MSG_PUB.Count_And_Get
2377: (p_count => x_msg_count,
2378: p_data => x_msg_data);
2379:
2380: WHEN OTHERS THEN

Line 2390: FND_MSG_PUB.Count_And_Get

2386: p_token1 => G_SQLCODE_TOKEN,
2387: p_token1_value => SQLCODE,
2388: p_token2 => G_SQLERRM_TOKEN,
2389: p_token2_value => SQLERRM);
2390: FND_MSG_PUB.Count_And_Get
2391: (p_count => x_msg_count,
2392: p_data => x_msg_data);
2393: end create_non_sel_billing_trx;
2394:

Line 2528: FND_MSG_PUB.initialize;

2524: END IF;
2525:
2526: -- Initialize message list if requested
2527: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Initialize API status to success
2532: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2896: FND_MSG_PUB.Count_And_Get

2892:
2893: /*** End API body ******************************************************/
2894:
2895: -- Get message count and if count is 1, get message info
2896: FND_MSG_PUB.Count_And_Get
2897: (p_count => x_msg_count,
2898: p_data => x_msg_data);
2899:
2900: EXCEPTION

Line 2904: FND_MSG_PUB.Count_And_Get

2900: EXCEPTION
2901: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2902: ROLLBACK TO create_sel_billing_trx;
2903: x_return_status := OKL_API.G_RET_STS_ERROR;
2904: FND_MSG_PUB.Count_And_Get
2905: (p_count => x_msg_count,
2906: p_data => x_msg_data);
2907:
2908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2911: FND_MSG_PUB.Count_And_Get

2907:
2908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2909: ROLLBACK TO create_sel_billing_trx;
2910: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2911: FND_MSG_PUB.Count_And_Get
2912: (p_count => x_msg_count,
2913: p_data => x_msg_data);
2914:
2915: WHEN OTHERS THEN

Line 2924: FND_MSG_PUB.Count_And_Get

2920: p_token1 => G_SQLCODE_TOKEN,
2921: p_token1_value => SQLCODE,
2922: p_token2 => G_SQLERRM_TOKEN,
2923: p_token2_value => SQLERRM);
2924: FND_MSG_PUB.Count_And_Get
2925: (p_count => x_msg_count,
2926: p_data => x_msg_data);
2927: end create_sel_billing_trx;
2928:

Line 3129: FND_MSG_PUB.initialize;

3125: END IF;
3126:
3127: -- Initialize message list if requested
3128: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3129: FND_MSG_PUB.initialize;
3130: END IF;
3131:
3132: -- Initialize API status to success
3133: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3215: FND_MSG_PUB.Count_And_Get

3211:
3212: /*** End API body ******************************************************/
3213:
3214: -- Get message count and if count is 1, get message info
3215: FND_MSG_PUB.Count_And_Get
3216: (p_count => x_msg_count,
3217: p_data => x_msg_data);
3218:
3219: END IF; -- End of IF (l_bankruptcy_flag = 'N') added as part of Bug# 14119181

Line 3225: FND_MSG_PUB.Count_And_Get

3221: EXCEPTION
3222: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3223: ROLLBACK TO CREATE_BILLING_TRX;
3224: x_return_status := OKL_API.G_RET_STS_ERROR;
3225: FND_MSG_PUB.Count_And_Get
3226: (p_count => x_msg_count,
3227: p_data => x_msg_data);
3228:
3229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3232: FND_MSG_PUB.Count_And_Get

3228:
3229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3230: ROLLBACK TO CREATE_BILLING_TRX;
3231: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3232: FND_MSG_PUB.Count_And_Get
3233: (p_count => x_msg_count,
3234: p_data => x_msg_data);
3235:
3236: WHEN OTHERS THEN

Line 3245: FND_MSG_PUB.Count_And_Get

3241: p_token1 => G_SQLCODE_TOKEN,
3242: p_token1_value => SQLCODE,
3243: p_token2 => G_SQLERRM_TOKEN,
3244: p_token2_value => SQLERRM);
3245: FND_MSG_PUB.Count_And_Get
3246: (p_count => x_msg_count,
3247: p_data => x_msg_data);
3248:
3249: end CREATE_BILLING_TRX;

Line 3336: FND_MSG_PUB.initialize;

3332: END IF;
3333:
3334: -- Initialize message list if requested
3335: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3336: FND_MSG_PUB.initialize;
3337: END IF;
3338:
3339: -- Initialize API status to success
3340: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3379: FND_MSG_PUB.Count_And_Get

3375:
3376: /*** End API body ******************************************************/
3377:
3378: -- Get message count and if count is 1, get message info
3379: FND_MSG_PUB.Count_And_Get
3380: (p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: EXCEPTION

Line 3387: FND_MSG_PUB.Count_And_Get

3383: EXCEPTION
3384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3385: ROLLBACK TO Get_Invoice_format;
3386: x_return_status := OKL_API.G_RET_STS_ERROR;
3387: FND_MSG_PUB.Count_And_Get
3388: (p_count => x_msg_count,
3389: p_data => x_msg_data);
3390:
3391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3394: FND_MSG_PUB.Count_And_Get

3390:
3391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3392: ROLLBACK TO Get_Invoice_format;
3393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3394: FND_MSG_PUB.Count_And_Get
3395: (p_count => x_msg_count,
3396: p_data => x_msg_data);
3397:
3398: WHEN OTHERS THEN

Line 3407: FND_MSG_PUB.Count_And_Get

3403: p_token1 => G_SQLCODE_TOKEN,
3404: p_token1_value => SQLCODE,
3405: p_token2 => G_SQLERRM_TOKEN,
3406: p_token2_value => SQLERRM);
3407: FND_MSG_PUB.Count_And_Get
3408: (p_count => x_msg_count,
3409: p_data => x_msg_data);
3410:
3411: end Get_Invoice_format;

Line 3786: FND_MSG_PUB.Count_And_Get

3782: END IF;
3783:
3784:
3785: -- Get message count and if count is 1, get message info
3786: FND_MSG_PUB.Count_And_Get
3787: (p_count => x_msg_count,
3788: p_data => x_msg_data);
3789:
3790: EXCEPTION

Line 3794: FND_MSG_PUB.Count_And_Get

3790: EXCEPTION
3791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3792: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3793: x_return_status := OKL_API.G_RET_STS_ERROR;
3794: FND_MSG_PUB.Count_And_Get
3795: (p_count => x_msg_count,
3796: p_data => x_msg_data);
3797:
3798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3801: FND_MSG_PUB.Count_And_Get

3797:
3798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3799: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3800: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3801: FND_MSG_PUB.Count_And_Get
3802: (p_count => x_msg_count,
3803: p_data => x_msg_data);
3804:
3805: WHEN OTHERS THEN

Line 3814: FND_MSG_PUB.Count_And_Get

3810: p_token1 => G_SQLCODE_TOKEN,
3811: p_token1_value => SQLCODE,
3812: p_token2 => G_SQLERRM_TOKEN,
3813: p_token2_value => SQLERRM);
3814: FND_MSG_PUB.Count_And_Get
3815: (p_count => x_msg_count,
3816: p_data => x_msg_data);
3817:
3818:

Line 3995: FND_MSG_PUB.Count_And_Get

3991:
3992:
3993:
3994: -- Get message count and if count is 1, get message info
3995: FND_MSG_PUB.Count_And_Get
3996: (p_count => x_msg_count,
3997: p_data => x_msg_data);
3998:
3999: EXCEPTION

Line 4003: FND_MSG_PUB.Count_And_Get

3999: EXCEPTION
4000: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4001: ROLLBACK TO DELETE_MANUAL_INVOICE;
4002: x_return_status := OKL_API.G_RET_STS_ERROR;
4003: FND_MSG_PUB.Count_And_Get
4004: (p_count => x_msg_count,
4005: p_data => x_msg_data);
4006:
4007: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4010: FND_MSG_PUB.Count_And_Get

4006:
4007: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4008: ROLLBACK TO DELETE_MANUAL_INVOICE;
4009: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4010: FND_MSG_PUB.Count_And_Get
4011: (p_count => x_msg_count,
4012: p_data => x_msg_data);
4013:
4014: WHEN OTHERS THEN

Line 4023: FND_MSG_PUB.Count_And_Get

4019: p_token1 => G_SQLCODE_TOKEN,
4020: p_token1_value => SQLCODE,
4021: p_token2 => G_SQLERRM_TOKEN,
4022: p_token2_value => SQLERRM);
4023: FND_MSG_PUB.Count_And_Get
4024: (p_count => x_msg_count,
4025: p_data => x_msg_data);
4026:
4027: