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;
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
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
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
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;
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;
1937:
1938: /*** End API body ******************************************************/
1939:
1940: -- Get message count and if count is 1, get message info
1941: FND_MSG_PUB.Count_And_Get
1942: (p_count => x_msg_count,
1943: p_data => x_msg_data);
1944:
1945: EXCEPTION
1945: EXCEPTION
1946: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1947: ROLLBACK TO create_sec_agreement_PVT;
1948: x_return_status := OKL_API.G_RET_STS_ERROR;
1949: FND_MSG_PUB.Count_And_Get
1950: (p_count => x_msg_count,
1951: p_data => x_msg_data);
1952:
1953: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1952:
1953: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1954: ROLLBACK TO create_sec_agreement_PVT;
1955: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1956: FND_MSG_PUB.Count_And_Get
1957: (p_count => x_msg_count,
1958: p_data => x_msg_data);
1959:
1960: WHEN OTHERS THEN
1965: p_token1 => G_SQLCODE_TOKEN,
1966: p_token1_value => SQLCODE,
1967: p_token2 => G_SQLERRM_TOKEN,
1968: p_token2_value => SQLERRM);
1969: FND_MSG_PUB.Count_And_Get
1970: (p_count => x_msg_count,
1971: p_data => x_msg_data);
1972: END;
1973:
2066: END IF;
2067:
2068: -- Initialize message list if requested
2069: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2070: FND_MSG_PUB.initialize;
2071: END IF;
2072:
2073: -- Initialize API status to success
2074: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2418:
2419: /*** End API body ******************************************************/
2420:
2421: -- Get message count and if count is 1, get message info
2422: FND_MSG_PUB.Count_And_Get
2423: (p_count => x_msg_count,
2424: p_data => x_msg_data);
2425:
2426: EXCEPTION
2427: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2428: ROLLBACK TO update_sec_agreement_PVT;
2429: x_return_status := OKL_API.G_RET_STS_ERROR;
2430:
2431: FND_MSG_PUB.Count_And_Get
2432: (p_count => x_msg_count,
2433: p_data => x_msg_data);
2434:
2435: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2434:
2435: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2436: ROLLBACK TO update_sec_agreement_PVT;
2437: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2438: FND_MSG_PUB.Count_And_Get
2439: (p_count => x_msg_count,
2440: p_data => x_msg_data);
2441:
2442: WHEN OTHERS THEN
2447: p_token1 => G_SQLCODE_TOKEN,
2448: p_token1_value => SQLCODE,
2449: p_token2 => G_SQLERRM_TOKEN,
2450: p_token2_value => SQLERRM);
2451: FND_MSG_PUB.Count_And_Get
2452: (p_count => x_msg_count,
2453: p_data => x_msg_data);
2454:
2455: END;
2567: END IF;
2568:
2569: -- Initialize message list if requested
2570: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2571: FND_MSG_PUB.initialize;
2572: END IF;
2573:
2574: -- Initialize API status to success
2575: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3047:
3048: /*** End API body ******************************************************/
3049:
3050: -- Get message count and if count is 1, get message info
3051: FND_MSG_PUB.Count_And_Get
3052: (p_count => x_msg_count,
3053: p_data => x_msg_data);
3054:
3055: EXCEPTION
3055: EXCEPTION
3056: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3057: ROLLBACK TO activate_sec_agreement_PVT;
3058: x_return_status := OKL_API.G_RET_STS_ERROR;
3059: FND_MSG_PUB.Count_And_Get
3060: (p_count => x_msg_count,
3061: p_data => x_msg_data);
3062:
3063: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3062:
3063: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3064: ROLLBACK TO activate_sec_agreement_PVT;
3065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3066: FND_MSG_PUB.Count_And_Get
3067: (p_count => x_msg_count,
3068: p_data => x_msg_data);
3069:
3070: WHEN OTHERS THEN
3075: p_token1 => G_SQLCODE_TOKEN,
3076: p_token1_value => SQLCODE,
3077: p_token2 => G_SQLERRM_TOKEN,
3078: p_token2_value => SQLERRM);
3079: FND_MSG_PUB.Count_And_Get
3080: (p_count => x_msg_count,
3081: p_data => x_msg_data);
3082:
3083: END activate_sec_agreement;
3151: END IF;
3152:
3153: -- Initialize message list if requested
3154: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3155: FND_MSG_PUB.initialize;
3156: END IF;
3157:
3158: -- Initialize API status to success
3159: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3227:
3228: /*** End API body ******************************************************/
3229:
3230: -- Get message count and if count is 1, get message info
3231: FND_MSG_PUB.Count_And_Get
3232: (p_count => x_msg_count,
3233: p_data => x_msg_data);
3234:
3235: EXCEPTION
3235: EXCEPTION
3236: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3237: ROLLBACK TO update_sec_agreement_sts_PVT;
3238: x_return_status := OKL_API.G_RET_STS_ERROR;
3239: FND_MSG_PUB.Count_And_Get
3240: (p_count => x_msg_count,
3241: p_data => x_msg_data);
3242:
3243: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3242:
3243: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3244: ROLLBACK TO update_sec_agreement_sts_PVT;
3245: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3246: FND_MSG_PUB.Count_And_Get
3247: (p_count => x_msg_count,
3248: p_data => x_msg_data);
3249:
3250: WHEN OTHERS THEN
3255: p_token1 => G_SQLCODE_TOKEN,
3256: p_token1_value => SQLCODE,
3257: p_token2 => G_SQLERRM_TOKEN,
3258: p_token2_value => SQLERRM);
3259: FND_MSG_PUB.Count_And_Get
3260: (p_count => x_msg_count,
3261: p_data => x_msg_data);
3262:
3263: END update_sec_agreement_sts;
3522: END IF;
3523:
3524: -- Initialize message list if requested
3525: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3526: FND_MSG_PUB.initialize;
3527: END IF;
3528:
3529: -- Initialize API status to success
3530: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3962:
3963: /*** End API body ******************************************************/
3964:
3965: -- Get message count and if count is 1, get message info
3966: FND_MSG_PUB.Count_And_Get
3967: (p_count => x_msg_count,
3968: p_data => x_msg_data);
3969:
3970: EXCEPTION
3970: EXCEPTION
3971: --For this User defined exception, do not rollback
3972: WHEN G_HALT_PROCESSING THEN
3973: x_return_status := OKL_API.G_RET_STS_ERROR;
3974: FND_MSG_PUB.Count_And_Get
3975: (p_count => x_msg_count,
3976: p_data => x_msg_data);
3977:
3978: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3977:
3978: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3979: ROLLBACK TO activate_add_request_pvt;
3980: x_return_status := OKL_API.G_RET_STS_ERROR;
3981: FND_MSG_PUB.Count_And_Get
3982: (p_count => x_msg_count,
3983: p_data => x_msg_data);
3984:
3985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3984:
3985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3986: ROLLBACK TO activate_add_request_pvt;
3987: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3988: FND_MSG_PUB.Count_And_Get
3989: (p_count => x_msg_count,
3990: p_data => x_msg_data);
3991: WHEN OTHERS THEN
3992: ROLLBACK TO activate_add_request_pvt;
3996: p_token1 => G_SQLCODE_TOKEN,
3997: p_token1_value => SQLCODE,
3998: p_token2 => G_SQLERRM_TOKEN,
3999: p_token2_value => SQLERRM);
4000: FND_MSG_PUB.Count_And_Get
4001: (p_count => x_msg_count,
4002: p_data => x_msg_data);
4003:
4004:
4175: EXCEPTION
4176: --For this User defined exception, do not rollback
4177: WHEN G_HALT_PROCESSING THEN
4178: x_return_status := OKL_API.G_RET_STS_ERROR;
4179: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count,
4180: p_data => l_msg_data);
4181:
4182: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4183: x_return_status := OKL_API.G_RET_STS_ERROR;