DBA Data[Home] [Help]

APPS.OKL_TMPT_SET_PUB dependencies on OKL_TMPT_SET_PUB

Line 1: PACKAGE BODY OKL_TMPT_SET_PUB AS

1: PACKAGE BODY OKL_TMPT_SET_PUB AS
2: /* $Header: OKLPAESB.pls 115.10 2002/12/18 12:08:51 kjinger noship $ */
3:
4:
5: PROCEDURE create_tmpt_set(

Line 136: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

132: ,p_count => x_msg_count
133: ,p_data => x_msg_data);
134:
135: WHEN OTHERS THEN
136: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
137: -- store SQL error message on message stack for caller
138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
139: ,p_count => x_msg_count
140: ,p_data => x_msg_data);

Line 257: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

253: ,p_count => x_msg_count
254: ,p_data => x_msg_data);
255:
256: WHEN OTHERS THEN
257: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
258: -- store SQL error message on message stack for caller
259: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
260: ,p_count => x_msg_count
261: ,p_data => x_msg_data);

Line 398: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

394: ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396:
397: WHEN OTHERS THEN
398: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
399: -- store SQL error message on message stack for caller
400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
401: ,p_count => x_msg_count
402: ,p_data => x_msg_data);

Line 540: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538:
539: WHEN OTHERS THEN
540: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
541: -- store SQL error message on message stack for caller
542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
543: ,p_count => x_msg_count
544: ,p_data => x_msg_data);

Line 669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

665: ,p_count => x_msg_count
666: ,p_data => x_msg_data);
667:
668: WHEN OTHERS THEN
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
670: -- store SQL error message on message stack for caller
671: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
672: ,p_count => x_msg_count
673: ,p_data => x_msg_data);

Line 749: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');

745: ,p_count => x_msg_count
746: ,p_data => x_msg_data);
747:
748: WHEN OTHERS THEN
749: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');
750: -- store SQL error message on message stack for caller
751: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
752: ,p_count => x_msg_count
753: ,p_data => x_msg_data);

Line 854: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');

850: ,p_count => x_msg_count
851: ,p_data => x_msg_data);
852:
853: WHEN OTHERS THEN
854: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');
855: -- store SQL error message on message stack for caller
856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
857: ,p_count => x_msg_count
858: ,p_data => x_msg_data);

Line 973: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

969: ,p_count => x_msg_count
970: ,p_data => x_msg_data);
971:
972: WHEN OTHERS THEN
973: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
974: -- store SQL error message on message stack for caller
975: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
976: ,p_count => x_msg_count
977: ,p_data => x_msg_data);

Line 1112: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
1110:
1111: WHEN OTHERS THEN
1112: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
1113: -- store SQL error message on message stack for caller
1114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1115: ,p_count => x_msg_count
1116: ,p_data => x_msg_data);

Line 1234: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');

1230: ,p_count => x_msg_count
1231: ,p_data => x_msg_data);
1232:
1233: WHEN OTHERS THEN
1234: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
1235: -- store SQL error message on message stack for caller
1236: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1237: ,p_count => x_msg_count
1238: ,p_data => x_msg_data);

Line 1369: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');

1365: ,p_count => x_msg_count
1366: ,p_data => x_msg_data);
1367:
1368: WHEN OTHERS THEN
1369: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
1370: -- store SQL error message on message stack for caller
1371: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1372: ,p_count => x_msg_count
1373: ,p_data => x_msg_data);

Line 1484: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

1480: ,p_count => x_msg_count
1481: ,p_data => x_msg_data);
1482:
1483: WHEN OTHERS THEN
1484: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
1485: -- store SQL error message on message stack for caller
1486: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1487: ,p_count => x_msg_count
1488: ,p_data => x_msg_data);

Line 1617: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

1613: ,p_count => x_msg_count
1614: ,p_data => x_msg_data);
1615:
1616: WHEN OTHERS THEN
1617: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
1618: -- store SQL error message on message stack for caller
1619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1620: ,p_count => x_msg_count
1621: ,p_data => x_msg_data);

Line 1740: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');

1736: ,p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738:
1739: WHEN OTHERS THEN
1740: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');
1741: -- store SQL error message on message stack for caller
1742: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1743: ,p_count => x_msg_count
1744: ,p_data => x_msg_data);

Line 1885: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');

1881: ,p_count => x_msg_count
1882: ,p_data => x_msg_data);
1883:
1884: WHEN OTHERS THEN
1885: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');
1886: -- store SQL error message on message stack for caller
1887: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1888: ,p_count => x_msg_count
1889: ,p_data => x_msg_data);

Line 1960: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');

1956: ,p_count => x_msg_count
1957: ,p_data => x_msg_data);
1958:
1959: WHEN OTHERS THEN
1960: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');
1961: -- store SQL error message on message stack for caller
1962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1963: ,p_count => x_msg_count
1964: ,p_data => x_msg_data);

Line 2065: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');

2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);
2063:
2064: WHEN OTHERS THEN
2065: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');
2066: -- store SQL error message on message stack for caller
2067: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2068: ,p_count => x_msg_count
2069: ,p_data => x_msg_data);

Line 2182: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');

2178: ,p_count => x_msg_count
2179: ,p_data => x_msg_data);
2180:
2181: WHEN OTHERS THEN
2182: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
2183: -- store SQL error message on message stack for caller
2184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2185: ,p_count => x_msg_count
2186: ,p_data => x_msg_data);

Line 2322: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');

2318: ,p_count => x_msg_count
2319: ,p_data => x_msg_data);
2320:
2321: WHEN OTHERS THEN
2322: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
2323: -- store SQL error message on message stack for caller
2324: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2325: ,p_count => x_msg_count
2326: ,p_data => x_msg_data);

Line 2438: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');

2434: ,p_count => x_msg_count
2435: ,p_data => x_msg_data);
2436:
2437: WHEN OTHERS THEN
2438: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
2439: -- store SQL error message on message stack for caller
2440: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2441: ,p_count => x_msg_count
2442: ,p_data => x_msg_data);

Line 2576: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');

2572: ,p_count => x_msg_count
2573: ,p_data => x_msg_data);
2574:
2575: WHEN OTHERS THEN
2576: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
2577: -- store SQL error message on message stack for caller
2578: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2579: ,p_count => x_msg_count
2580: ,p_data => x_msg_data);

Line 2690: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');

2686: ,p_count => x_msg_count
2687: ,p_data => x_msg_data);
2688:
2689: WHEN OTHERS THEN
2690: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');
2691: -- store SQL error message on message stack for caller
2692: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2693: ,p_count => x_msg_count
2694: ,p_data => x_msg_data);

Line 2825: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');

2821: ,p_count => x_msg_count
2822: ,p_data => x_msg_data);
2823:
2824: WHEN OTHERS THEN
2825: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');
2826: -- store SQL error message on message stack for caller
2827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2828: ,p_count => x_msg_count
2829: ,p_data => x_msg_data);

Line 2947: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');

2943: ,p_count => x_msg_count
2944: ,p_data => x_msg_data);
2945:
2946: WHEN OTHERS THEN
2947: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');
2948: -- store SQL error message on message stack for caller
2949: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2950: ,p_count => x_msg_count
2951: ,p_data => x_msg_data);

Line 3091: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');

3087: ,p_count => x_msg_count
3088: ,p_data => x_msg_data);
3089:
3090: WHEN OTHERS THEN
3091: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');
3092: -- store SQL error message on message stack for caller
3093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3094: ,p_count => x_msg_count
3095: ,p_data => x_msg_data);

Line 3166: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');

3162: ,p_count => x_msg_count
3163: ,p_data => x_msg_data);
3164:
3165: WHEN OTHERS THEN
3166: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');
3167: -- store SQL error message on message stack for caller
3168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3169: ,p_count => x_msg_count
3170: ,p_data => x_msg_data);

Line 3272: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');

3268: ,p_count => x_msg_count
3269: ,p_data => x_msg_data);
3270:
3271: WHEN OTHERS THEN
3272: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');
3273: -- store SQL error message on message stack for caller
3274: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3275: ,p_count => x_msg_count
3276: ,p_data => x_msg_data);

Line 3388: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');

3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);
3386:
3387: WHEN OTHERS THEN
3388: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
3389: -- store SQL error message on message stack for caller
3390: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3391: ,p_count => x_msg_count
3392: ,p_data => x_msg_data);

Line 3528: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');

3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data);
3526:
3527: WHEN OTHERS THEN
3528: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
3529: -- store SQL error message on message stack for caller
3530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3531: ,p_count => x_msg_count
3532: ,p_data => x_msg_data);

Line 3643: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');

3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);
3641:
3642: WHEN OTHERS THEN
3643: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
3644: -- store SQL error message on message stack for caller
3645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3646: ,p_count => x_msg_count
3647: ,p_data => x_msg_data);

Line 3781: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');

3777: ,p_count => x_msg_count
3778: ,p_data => x_msg_data);
3779:
3780: WHEN OTHERS THEN
3781: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
3782: -- store SQL error message on message stack for caller
3783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3784: ,p_count => x_msg_count
3785: ,p_data => x_msg_data);

Line 3894: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');

3890: ,p_count => x_msg_count
3891: ,p_data => x_msg_data);
3892:
3893: WHEN OTHERS THEN
3894: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');
3895: -- store SQL error message on message stack for caller
3896: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3897: ,p_count => x_msg_count
3898: ,p_data => x_msg_data);

Line 4030: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');

4026: ,p_count => x_msg_count
4027: ,p_data => x_msg_data);
4028:
4029: WHEN OTHERS THEN
4030: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');
4031: -- store SQL error message on message stack for caller
4032: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4033: ,p_count => x_msg_count
4034: ,p_data => x_msg_data);

Line 4040: END OKL_TMPT_SET_PUB;

4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037:
4038: END validate_tmpt_lines;
4039:
4040: END OKL_TMPT_SET_PUB;
4041: