DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_PVT dependencies on FND_MSG_PUB

Line 300: FND_MSG_PUB.initialize;

296: END IF;
297:
298: -- Initialize message list if requested
299: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
300: FND_MSG_PUB.initialize;
301: END IF;
302:
303: -- Initialize API status to success
304: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 855: FND_MSG_PUB.Count_And_Get

851:
852: /*** End API body ******************************************************/
853:
854: -- Get message count and if count is 1, get message info
855: FND_MSG_PUB.Count_And_Get
856: (p_count => x_msg_count,
857: p_data => x_msg_data);
858:
859: EXCEPTION

Line 863: FND_MSG_PUB.Count_And_Get

859: EXCEPTION
860: WHEN OKL_API.G_EXCEPTION_ERROR THEN
861: ROLLBACK TO generate_journal_entries_PVT;
862: x_return_status := OKL_API.G_RET_STS_ERROR;
863: FND_MSG_PUB.Count_And_Get
864: (p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 870: FND_MSG_PUB.Count_And_Get

866:
867: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: ROLLBACK TO generate_journal_entries_PVT;
869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
870: FND_MSG_PUB.Count_And_Get
871: (p_count => x_msg_count,
872: p_data => x_msg_data);
873:
874: WHEN OTHERS THEN

Line 883: FND_MSG_PUB.Count_And_Get

879: p_token1 => G_SQLCODE_TOKEN,
880: p_token1_value => SQLCODE,
881: p_token2 => G_SQLERRM_TOKEN,
882: p_token2_value => SQLERRM);
883: FND_MSG_PUB.Count_And_Get
884: (p_count => x_msg_count,
885: p_data => x_msg_data);
886:
887: END generate_journal_entries;

Line 1610: FND_MSG_PUB.initialize;

1606: END IF;
1607:
1608: -- Initialize message list if requested
1609: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1610: FND_MSG_PUB.initialize;
1611: END IF;
1612:
1613: -- Initialize API status to success
1614: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1949: FND_MSG_PUB.Count_And_Get

1945:
1946: /*** End API body ******************************************************/
1947:
1948: -- Get message count and if count is 1, get message info
1949: FND_MSG_PUB.Count_And_Get
1950: (p_count => x_msg_count,
1951: p_data => x_msg_data);
1952:
1953: EXCEPTION

Line 1957: FND_MSG_PUB.Count_And_Get

1953: EXCEPTION
1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955: ROLLBACK TO create_sec_agreement_PVT;
1956: x_return_status := OKL_API.G_RET_STS_ERROR;
1957: FND_MSG_PUB.Count_And_Get
1958: (p_count => x_msg_count,
1959: p_data => x_msg_data);
1960:
1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1964: FND_MSG_PUB.Count_And_Get

1960:
1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1962: ROLLBACK TO create_sec_agreement_PVT;
1963: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1964: FND_MSG_PUB.Count_And_Get
1965: (p_count => x_msg_count,
1966: p_data => x_msg_data);
1967:
1968: WHEN OTHERS THEN

Line 1977: FND_MSG_PUB.Count_And_Get

1973: p_token1 => G_SQLCODE_TOKEN,
1974: p_token1_value => SQLCODE,
1975: p_token2 => G_SQLERRM_TOKEN,
1976: p_token2_value => SQLERRM);
1977: FND_MSG_PUB.Count_And_Get
1978: (p_count => x_msg_count,
1979: p_data => x_msg_data);
1980: END;
1981:

Line 2078: FND_MSG_PUB.initialize;

2074: END IF;
2075:
2076: -- Initialize message list if requested
2077: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2078: FND_MSG_PUB.initialize;
2079: END IF;
2080:
2081: -- Initialize API status to success
2082: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2439: FND_MSG_PUB.Count_And_Get

2435:
2436: /*** End API body ******************************************************/
2437:
2438: -- Get message count and if count is 1, get message info
2439: FND_MSG_PUB.Count_And_Get
2440: (p_count => x_msg_count,
2441: p_data => x_msg_data);
2442:
2443: EXCEPTION

Line 2448: FND_MSG_PUB.Count_And_Get

2444: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2445: ROLLBACK TO update_sec_agreement_PVT;
2446: x_return_status := OKL_API.G_RET_STS_ERROR;
2447:
2448: FND_MSG_PUB.Count_And_Get
2449: (p_count => x_msg_count,
2450: p_data => x_msg_data);
2451:
2452: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2455: FND_MSG_PUB.Count_And_Get

2451:
2452: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2453: ROLLBACK TO update_sec_agreement_PVT;
2454: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2455: FND_MSG_PUB.Count_And_Get
2456: (p_count => x_msg_count,
2457: p_data => x_msg_data);
2458:
2459: WHEN OTHERS THEN

Line 2468: FND_MSG_PUB.Count_And_Get

2464: p_token1 => G_SQLCODE_TOKEN,
2465: p_token1_value => SQLCODE,
2466: p_token2 => G_SQLERRM_TOKEN,
2467: p_token2_value => SQLERRM);
2468: FND_MSG_PUB.Count_And_Get
2469: (p_count => x_msg_count,
2470: p_data => x_msg_data);
2471:
2472: END;

Line 2588: FND_MSG_PUB.initialize;

2584: END IF;
2585:
2586: -- Initialize message list if requested
2587: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2588: FND_MSG_PUB.initialize;
2589: END IF;
2590:
2591: -- Initialize API status to success
2592: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3068: FND_MSG_PUB.Count_And_Get

3064:
3065: /*** End API body ******************************************************/
3066:
3067: -- Get message count and if count is 1, get message info
3068: FND_MSG_PUB.Count_And_Get
3069: (p_count => x_msg_count,
3070: p_data => x_msg_data);
3071:
3072: EXCEPTION

Line 3076: FND_MSG_PUB.Count_And_Get

3072: EXCEPTION
3073: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3074: ROLLBACK TO activate_sec_agreement_PVT;
3075: x_return_status := OKL_API.G_RET_STS_ERROR;
3076: FND_MSG_PUB.Count_And_Get
3077: (p_count => x_msg_count,
3078: p_data => x_msg_data);
3079:
3080: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3083: FND_MSG_PUB.Count_And_Get

3079:
3080: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3081: ROLLBACK TO activate_sec_agreement_PVT;
3082: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3083: FND_MSG_PUB.Count_And_Get
3084: (p_count => x_msg_count,
3085: p_data => x_msg_data);
3086:
3087: WHEN OTHERS THEN

Line 3096: FND_MSG_PUB.Count_And_Get

3092: p_token1 => G_SQLCODE_TOKEN,
3093: p_token1_value => SQLCODE,
3094: p_token2 => G_SQLERRM_TOKEN,
3095: p_token2_value => SQLERRM);
3096: FND_MSG_PUB.Count_And_Get
3097: (p_count => x_msg_count,
3098: p_data => x_msg_data);
3099:
3100: END activate_sec_agreement;

Line 3172: FND_MSG_PUB.initialize;

3168: END IF;
3169:
3170: -- Initialize message list if requested
3171: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3172: FND_MSG_PUB.initialize;
3173: END IF;
3174:
3175: -- Initialize API status to success
3176: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3248: FND_MSG_PUB.Count_And_Get

3244:
3245: /*** End API body ******************************************************/
3246:
3247: -- Get message count and if count is 1, get message info
3248: FND_MSG_PUB.Count_And_Get
3249: (p_count => x_msg_count,
3250: p_data => x_msg_data);
3251:
3252: EXCEPTION

Line 3256: FND_MSG_PUB.Count_And_Get

3252: EXCEPTION
3253: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3254: ROLLBACK TO update_sec_agreement_sts_PVT;
3255: x_return_status := OKL_API.G_RET_STS_ERROR;
3256: FND_MSG_PUB.Count_And_Get
3257: (p_count => x_msg_count,
3258: p_data => x_msg_data);
3259:
3260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3263: FND_MSG_PUB.Count_And_Get

3259:
3260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3261: ROLLBACK TO update_sec_agreement_sts_PVT;
3262: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3263: FND_MSG_PUB.Count_And_Get
3264: (p_count => x_msg_count,
3265: p_data => x_msg_data);
3266:
3267: WHEN OTHERS THEN

Line 3276: FND_MSG_PUB.Count_And_Get

3272: p_token1 => G_SQLCODE_TOKEN,
3273: p_token1_value => SQLCODE,
3274: p_token2 => G_SQLERRM_TOKEN,
3275: p_token2_value => SQLERRM);
3276: FND_MSG_PUB.Count_And_Get
3277: (p_count => x_msg_count,
3278: p_data => x_msg_data);
3279:
3280: END update_sec_agreement_sts;

Line 3543: FND_MSG_PUB.initialize;

3539: END IF;
3540:
3541: -- Initialize message list if requested
3542: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3543: FND_MSG_PUB.initialize;
3544: END IF;
3545:
3546: -- Initialize API status to success
3547: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3983: FND_MSG_PUB.Count_And_Get

3979:
3980: /*** End API body ******************************************************/
3981:
3982: -- Get message count and if count is 1, get message info
3983: FND_MSG_PUB.Count_And_Get
3984: (p_count => x_msg_count,
3985: p_data => x_msg_data);
3986:
3987: EXCEPTION

Line 3991: FND_MSG_PUB.Count_And_Get

3987: EXCEPTION
3988: --For this User defined exception, do not rollback
3989: WHEN G_HALT_PROCESSING THEN
3990: x_return_status := OKL_API.G_RET_STS_ERROR;
3991: FND_MSG_PUB.Count_And_Get
3992: (p_count => x_msg_count,
3993: p_data => x_msg_data);
3994:
3995: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3998: FND_MSG_PUB.Count_And_Get

3994:
3995: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3996: ROLLBACK TO activate_add_request_pvt;
3997: x_return_status := OKL_API.G_RET_STS_ERROR;
3998: FND_MSG_PUB.Count_And_Get
3999: (p_count => x_msg_count,
4000: p_data => x_msg_data);
4001:
4002: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4005: FND_MSG_PUB.Count_And_Get

4001:
4002: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4003: ROLLBACK TO activate_add_request_pvt;
4004: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4005: FND_MSG_PUB.Count_And_Get
4006: (p_count => x_msg_count,
4007: p_data => x_msg_data);
4008: WHEN OTHERS THEN
4009: ROLLBACK TO activate_add_request_pvt;

Line 4017: FND_MSG_PUB.Count_And_Get

4013: p_token1 => G_SQLCODE_TOKEN,
4014: p_token1_value => SQLCODE,
4015: p_token2 => G_SQLERRM_TOKEN,
4016: p_token2_value => SQLERRM);
4017: FND_MSG_PUB.Count_And_Get
4018: (p_count => x_msg_count,
4019: p_data => x_msg_data);
4020:
4021:

Line 4074: FND_MSG_PUB.initialize;

4070: BEGIN
4071:
4072: -- initializing the message list
4073: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
4074: FND_MSG_PUB.initialize;
4075: END IF;
4076:
4077: l_return_status := OKL_API.G_RET_STS_SUCCESS;
4078: l_pool_id := p_pool_id;

Line 4207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4203: EXCEPTION
4204: --For this User defined exception, do not rollback
4205: WHEN G_HALT_PROCESSING THEN
4206: x_return_status := OKL_API.G_RET_STS_ERROR;
4207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4208: p_data => x_msg_data);
4209:
4210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4211: x_return_status := OKL_API.G_RET_STS_ERROR;