DBA Data[Home] [Help]

APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on FND_MSG_PUB

Line 1632: FND_MSG_PUB.initialize;

1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF FND_API.to_Boolean( p_init_msg_list )
1631: THEN
1632: FND_MSG_PUB.initialize;
1633: END IF;
1634:
1635: -- Initialize API return status to SUCCESS
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1826: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1822: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824: x_msg_count := 1;
1825: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1826: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1827: FND_MSG_PUB.Count_And_Get(
1828: p_encoded => FND_API.G_FALSE,
1829: p_count => x_msg_count,
1830: p_data => x_msg_data);

Line 1827: FND_MSG_PUB.Count_And_Get(

1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824: x_msg_count := 1;
1825: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1826: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1827: FND_MSG_PUB.Count_And_Get(
1828: p_encoded => FND_API.G_FALSE,
1829: p_count => x_msg_count,
1830: p_data => x_msg_data);
1831:

Line 1893: FND_MSG_PUB.initialize;

1889:
1890: -- Initialize message list if p_init_msg_list is set to TRUE.
1891: IF FND_API.to_Boolean( p_init_msg_list )
1892: THEN
1893: FND_MSG_PUB.initialize;
1894: END IF;
1895:
1896: -- Initialize API return status to SUCCESS
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2208: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2204: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: x_msg_count := 1;
2207: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2208: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2209: FND_MSG_PUB.Count_And_Get(
2210: p_encoded => FND_API.G_FALSE,
2211: p_count => x_msg_count,
2212: p_data => x_msg_data);

Line 2209: FND_MSG_PUB.Count_And_Get(

2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: x_msg_count := 1;
2207: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2208: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2209: FND_MSG_PUB.Count_And_Get(
2210: p_encoded => FND_API.G_FALSE,
2211: p_count => x_msg_count,
2212: p_data => x_msg_data);
2213:

Line 2253: FND_MSG_PUB.initialize;

2249:
2250: -- Initialize message list if p_init_msg_list is set to TRUE.
2251: IF FND_API.to_Boolean( p_init_msg_list )
2252: THEN
2253: FND_MSG_PUB.initialize;
2254: END IF;
2255:
2256: -- Initialize API return status to SUCCESS
2257: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2331: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2333: x_msg_count := 1;
2334: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2336: FND_MSG_PUB.Count_And_Get(
2337: p_encoded => FND_API.G_FALSE,
2338: p_count => x_msg_count,
2339: p_data => x_msg_data);

Line 2336: FND_MSG_PUB.Count_And_Get(

2332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2333: x_msg_count := 1;
2334: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2336: FND_MSG_PUB.Count_And_Get(
2337: p_encoded => FND_API.G_FALSE,
2338: p_count => x_msg_count,
2339: p_data => x_msg_data);
2340: RETURN;

Line 2377: FND_MSG_PUB.initialize;

2373:
2374: -- Initialize message list if p_init_msg_list is set to TRUE.
2375: IF FND_API.to_Boolean( p_init_msg_list )
2376: THEN
2377: FND_MSG_PUB.initialize;
2378: END IF;
2379:
2380: -- Initialize API return status to SUCCESS
2381: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2458: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2454: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2456: x_msg_count := 1;
2457: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2458: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2459: FND_MSG_PUB.Count_And_Get(
2460: p_encoded => FND_API.G_FALSE,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data);

Line 2459: FND_MSG_PUB.Count_And_Get(

2455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2456: x_msg_count := 1;
2457: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2458: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2459: FND_MSG_PUB.Count_And_Get(
2460: p_encoded => FND_API.G_FALSE,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data);
2463: RETURN;

Line 2541: FND_MSG_PUB.initialize;

2537:
2538: -- Initialize message list if p_init_msg_list is set to TRUE.
2539: IF FND_API.to_Boolean( p_init_msg_list )
2540: THEN
2541: FND_MSG_PUB.initialize;
2542: END IF;
2543:
2544: -- Initialize API return status to SUCCESS
2545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2669: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2671: x_msg_count := 1;
2672: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2674: FND_MSG_PUB.Count_And_Get(
2675: p_encoded => FND_API.G_FALSE,
2676: p_count => x_msg_count,
2677: p_data => x_msg_data);

Line 2674: FND_MSG_PUB.Count_And_Get(

2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2671: x_msg_count := 1;
2672: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
2673: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2674: FND_MSG_PUB.Count_And_Get(
2675: p_encoded => FND_API.G_FALSE,
2676: p_count => x_msg_count,
2677: p_data => x_msg_data);
2678: RETURN;

Line 2923: FND_MSG_PUB.initialize;

2919:
2920: -- Initialize message list if p_init_msg_list is set to TRUE.
2921: IF FND_API.to_Boolean( p_init_msg_list )
2922: THEN
2923: FND_MSG_PUB.initialize;
2924: END IF;
2925:
2926: -- Initialize API return status to SUCCESS
2927: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3006: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3002: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3004: x_msg_count := 1;
3005: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3006: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3007: FND_MSG_PUB.Count_And_Get(
3008: p_encoded => FND_API.G_FALSE,
3009: p_count => x_msg_count,
3010: p_data => x_msg_data);

Line 3007: FND_MSG_PUB.Count_And_Get(

3003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3004: x_msg_count := 1;
3005: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3006: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3007: FND_MSG_PUB.Count_And_Get(
3008: p_encoded => FND_API.G_FALSE,
3009: p_count => x_msg_count,
3010: p_data => x_msg_data);
3011: RETURN;

Line 3074: FND_MSG_PUB.initialize;

3070:
3071: -- Initialize message list if p_init_msg_list is set to TRUE.
3072: IF FND_API.to_Boolean( p_init_msg_list )
3073: THEN
3074: FND_MSG_PUB.initialize;
3075: END IF;
3076:
3077: -- Initialize API return status to SUCCESS
3078: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3256: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
3257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3258: x_msg_count := 1;
3259: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3261: FND_MSG_PUB.Count_And_Get(
3262: p_encoded => FND_API.G_FALSE,
3263: p_count => x_msg_count,
3264: p_data => x_msg_data);

Line 3261: FND_MSG_PUB.Count_And_Get(

3257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3258: x_msg_count := 1;
3259: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3261: FND_MSG_PUB.Count_And_Get(
3262: p_encoded => FND_API.G_FALSE,
3263: p_count => x_msg_count,
3264: p_data => x_msg_data);
3265: RETURN;

Line 3474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3470: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: x_msg_count := 1;
3473: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data);

Line 3475: FND_MSG_PUB.Count_And_Get(

3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: x_msg_count := 1;
3473: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3474: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data);
3479: RETURN;

Line 3528: FND_MSG_PUB.initialize;

3524:
3525: -- Initialize message list if p_init_msg_list is set to TRUE.
3526: IF FND_API.to_Boolean( p_init_msg_list )
3527: THEN
3528: FND_MSG_PUB.initialize;
3529: END IF;
3530:
3531: -- Initialize API return status to SUCCESS
3532: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3569: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
3570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3571: x_msg_count := 1;
3572: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3574: FND_MSG_PUB.Count_And_Get(
3575: p_encoded => FND_API.G_FALSE,
3576: p_count => x_msg_count,
3577: p_data => x_msg_data);

Line 3574: FND_MSG_PUB.Count_And_Get(

3570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3571: x_msg_count := 1;
3572: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3574: FND_MSG_PUB.Count_And_Get(
3575: p_encoded => FND_API.G_FALSE,
3576: p_count => x_msg_count,
3577: p_data => x_msg_data);
3578: RETURN;

Line 3863: FND_MSG_PUB.initialize;

3859:
3860: -- Initialize message list if p_init_msg_list is set to TRUE.
3861: IF FND_API.to_Boolean( p_init_msg_list )
3862: THEN
3863: FND_MSG_PUB.initialize;
3864: END IF;
3865:
3866: -- Initialize API return status to SUCCESS
3867: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3980: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3982: x_msg_count := 1;
3983: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3985: FND_MSG_PUB.Count_And_Get(
3986: p_encoded => FND_API.G_FALSE,
3987: p_count => x_msg_count,
3988: p_data => x_msg_data);

Line 3985: FND_MSG_PUB.Count_And_Get(

3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3982: x_msg_count := 1;
3983: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
3984: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3985: FND_MSG_PUB.Count_And_Get(
3986: p_encoded => FND_API.G_FALSE,
3987: p_count => x_msg_count,
3988: p_data => x_msg_data);
3989: RETURN;

Line 4287: FND_MSG_PUB.initialize;

4283:
4284: -- Initialize message list if p_init_msg_list is set to TRUE.
4285: IF FND_API.to_Boolean( p_init_msg_list )
4286: THEN
4287: FND_MSG_PUB.initialize;
4288: END IF;
4289:
4290: -- Initialize API return status to SUCCESS
4291: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4501: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4497: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499: x_msg_count := 1;
4500: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4501: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4502: FND_MSG_PUB.Count_And_Get(
4503: p_encoded => FND_API.G_FALSE,
4504: p_count => x_msg_count,
4505: p_data => x_msg_data);

Line 4502: FND_MSG_PUB.Count_And_Get(

4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499: x_msg_count := 1;
4500: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4501: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4502: FND_MSG_PUB.Count_And_Get(
4503: p_encoded => FND_API.G_FALSE,
4504: p_count => x_msg_count,
4505: p_data => x_msg_data);
4506: RETURN;

Line 4562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4558: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4560: x_msg_count := 1;
4561: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4563: FND_MSG_PUB.Count_And_Get(
4564: p_encoded => FND_API.G_FALSE,
4565: p_count => x_msg_count,
4566: p_data => x_msg_data);

Line 4563: FND_MSG_PUB.Count_And_Get(

4559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4560: x_msg_count := 1;
4561: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4563: FND_MSG_PUB.Count_And_Get(
4564: p_encoded => FND_API.G_FALSE,
4565: p_count => x_msg_count,
4566: p_data => x_msg_data);
4567: RETURN;

Line 4682: FND_MSG_PUB.initialize;

4678:
4679: -- Initialize message list if p_init_msg_list is set to TRUE.
4680: IF FND_API.to_Boolean( p_init_msg_list )
4681: THEN
4682: FND_MSG_PUB.initialize;
4683: END IF;
4684:
4685: -- Initialize API return status to SUCCESS
4686: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4793: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4795: x_msg_count := 1;
4796: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4798: FND_MSG_PUB.Count_And_Get(
4799: p_encoded => FND_API.G_FALSE,
4800: p_count => x_msg_count,
4801: p_data => x_msg_data);

Line 4798: FND_MSG_PUB.Count_And_Get(

4794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4795: x_msg_count := 1;
4796: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4798: FND_MSG_PUB.Count_And_Get(
4799: p_encoded => FND_API.G_FALSE,
4800: p_count => x_msg_count,
4801: p_data => x_msg_data);
4802: RETURN;

Line 4850: FND_MSG_PUB.initialize;

4846:
4847: -- Initialize message list if p_init_msg_list is set to TRUE.
4848: IF FND_API.to_Boolean( p_init_msg_list )
4849: THEN
4850: FND_MSG_PUB.initialize;
4851: END IF;
4852:
4853: -- Initialize API return status to SUCCESS
4854: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4892: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4894: x_msg_count := 1;
4895: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4897: FND_MSG_PUB.Count_And_Get(
4898: p_encoded => FND_API.G_FALSE,
4899: p_count => x_msg_count,
4900: p_data => x_msg_data);

Line 4897: FND_MSG_PUB.Count_And_Get(

4893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4894: x_msg_count := 1;
4895: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
4896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4897: FND_MSG_PUB.Count_And_Get(
4898: p_encoded => FND_API.G_FALSE,
4899: p_count => x_msg_count,
4900: p_data => x_msg_data);
4901: RETURN;

Line 5020: FND_MSG_PUB.initialize;

5016:
5017: -- Initialize message list if p_init_msg_list is set to TRUE.
5018: IF FND_API.to_Boolean( p_init_msg_list )
5019: THEN
5020: FND_MSG_PUB.initialize;
5021: END IF;
5022:
5023: -- Initialize API return status to SUCCESS
5024: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5127: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5129: x_msg_count := 1;
5130: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5132: FND_MSG_PUB.Count_And_Get(
5133: p_encoded => FND_API.G_FALSE,
5134: p_count => x_msg_count,
5135: p_data => x_msg_data);

Line 5132: FND_MSG_PUB.Count_And_Get(

5128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5129: x_msg_count := 1;
5130: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5132: FND_MSG_PUB.Count_And_Get(
5133: p_encoded => FND_API.G_FALSE,
5134: p_count => x_msg_count,
5135: p_data => x_msg_data);
5136: RETURN;

Line 5188: FND_MSG_PUB.initialize;

5184:
5185: -- Initialize message list if p_init_msg_list is set to TRUE.
5186: IF FND_API.to_Boolean( p_init_msg_list )
5187: THEN
5188: FND_MSG_PUB.initialize;
5189: END IF;
5190:
5191: -- Initialize API return status to SUCCESS
5192: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5228: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5230: x_msg_count := 1;
5231: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5233: FND_MSG_PUB.Count_And_Get(
5234: p_encoded => FND_API.G_FALSE,
5235: p_count => x_msg_count,
5236: p_data => x_msg_data);

Line 5233: FND_MSG_PUB.Count_And_Get(

5229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5230: x_msg_count := 1;
5231: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5232: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5233: FND_MSG_PUB.Count_And_Get(
5234: p_encoded => FND_API.G_FALSE,
5235: p_count => x_msg_count,
5236: p_data => x_msg_data);
5237: RETURN;

Line 5359: FND_MSG_PUB.initialize;

5355:
5356: -- Initialize message list if p_init_msg_list is set to TRUE.
5357: IF FND_API.to_Boolean( p_init_msg_list )
5358: THEN
5359: FND_MSG_PUB.initialize;
5360: END IF;
5361:
5362: -- Initialize API return status to SUCCESS
5363: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5471: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5473: x_msg_count := 1;
5474: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5476: FND_MSG_PUB.Count_And_Get(
5477: p_encoded => FND_API.G_FALSE,
5478: p_count => x_msg_count,
5479: p_data => x_msg_data);

Line 5476: FND_MSG_PUB.Count_And_Get(

5472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5473: x_msg_count := 1;
5474: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5476: FND_MSG_PUB.Count_And_Get(
5477: p_encoded => FND_API.G_FALSE,
5478: p_count => x_msg_count,
5479: p_data => x_msg_data);
5480: RETURN;

Line 5548: FND_MSG_PUB.initialize;

5544:
5545: -- Initialize message list if p_init_msg_list is set to TRUE.
5546: IF FND_API.to_Boolean( p_init_msg_list )
5547: THEN
5548: FND_MSG_PUB.initialize;
5549: END IF;
5550:
5551: -- Initialize API return status to SUCCESS
5552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5631: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
5632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5633: x_msg_count := 1;
5634: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5636: FND_MSG_PUB.Count_And_Get(
5637: p_encoded => FND_API.G_FALSE,
5638: p_count => x_msg_count,
5639: p_data => x_msg_data);

Line 5636: FND_MSG_PUB.Count_And_Get(

5632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5633: x_msg_count := 1;
5634: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
5635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5636: FND_MSG_PUB.Count_And_Get(
5637: p_encoded => FND_API.G_FALSE,
5638: p_count => x_msg_count,
5639: p_data => x_msg_data);
5640: RETURN;

Line 5944: FND_MSG_PUB.initialize;

5940:
5941: -- Initialize message list if p_init_msg_list is set to TRUE.
5942: IF FND_API.to_Boolean( p_init_msg_list )
5943: THEN
5944: FND_MSG_PUB.initialize;
5945: END IF;
5946:
5947: -- Initialize API return status to SUCCESS
5948: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6202: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6204: x_msg_count := 1;
6205: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6207: FND_MSG_PUB.Count_And_Get(
6208: p_encoded => FND_API.G_FALSE,
6209: p_count => x_msg_count,
6210: p_data => x_msg_data);

Line 6207: FND_MSG_PUB.Count_And_Get(

6203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6204: x_msg_count := 1;
6205: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6207: FND_MSG_PUB.Count_And_Get(
6208: p_encoded => FND_API.G_FALSE,
6209: p_count => x_msg_count,
6210: p_data => x_msg_data);
6211: RETURN;

Line 6280: FND_MSG_PUB.initialize;

6276:
6277: -- Initialize message list if p_init_msg_list is set to TRUE.
6278: IF FND_API.to_Boolean( p_init_msg_list )
6279: THEN
6280: FND_MSG_PUB.initialize;
6281: END IF;
6282:
6283: -- Initialize API return status to SUCCESS
6284: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6400: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6396: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: x_msg_count := 1;
6399: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6400: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6401: FND_MSG_PUB.Count_And_Get(
6402: p_encoded => FND_API.G_FALSE,
6403: p_count => x_msg_count,
6404: p_data => x_msg_data);

Line 6401: FND_MSG_PUB.Count_And_Get(

6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: x_msg_count := 1;
6399: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6400: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6401: FND_MSG_PUB.Count_And_Get(
6402: p_encoded => FND_API.G_FALSE,
6403: p_count => x_msg_count,
6404: p_data => x_msg_data);
6405: RETURN;

Line 6506: FND_MSG_PUB.initialize;

6502:
6503: -- Initialize message list if p_init_msg_list is set to TRUE.
6504: IF FND_API.to_Boolean( p_init_msg_list )
6505: THEN
6506: FND_MSG_PUB.initialize;
6507: END IF;
6508:
6509: -- Initialize API return status to SUCCESS
6510: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6789: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6791: x_msg_count := 1;
6792: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6794: FND_MSG_PUB.Count_And_Get(
6795: p_encoded => FND_API.G_FALSE,
6796: p_count => x_msg_count,
6797: p_data => x_msg_data);

Line 6794: FND_MSG_PUB.Count_And_Get(

6790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6791: x_msg_count := 1;
6792: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6794: FND_MSG_PUB.Count_And_Get(
6795: p_encoded => FND_API.G_FALSE,
6796: p_count => x_msg_count,
6797: p_data => x_msg_data);
6798: RETURN;

Line 6854: FND_MSG_PUB.initialize;

6850:
6851: -- Initialize message list if p_init_msg_list is set to TRUE.
6852: IF FND_API.to_Boolean( p_init_msg_list )
6853: THEN
6854: FND_MSG_PUB.initialize;
6855: END IF;
6856:
6857: -- Initialize API return status to SUCCESS
6858: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6914: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6910: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
6911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6912: x_msg_count := 1;
6913: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6914: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6915: FND_MSG_PUB.Count_And_Get(
6916: p_encoded => FND_API.G_FALSE,
6917: p_count => x_msg_count,
6918: p_data => x_msg_data);

Line 6915: FND_MSG_PUB.Count_And_Get(

6911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6912: x_msg_count := 1;
6913: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
6914: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6915: FND_MSG_PUB.Count_And_Get(
6916: p_encoded => FND_API.G_FALSE,
6917: p_count => x_msg_count,
6918: p_data => x_msg_data);
6919: RETURN;

Line 7008: FND_MSG_PUB.initialize;

7004:
7005: -- Initialize message list if p_init_msg_list is set to TRUE.
7006: IF FND_API.to_Boolean( p_init_msg_list )
7007: THEN
7008: FND_MSG_PUB.initialize;
7009: END IF;
7010:
7011: -- Initialize API return status to SUCCESS
7012: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7131: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
7132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7133: x_msg_count := 1;
7134: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
7135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7136: FND_MSG_PUB.Count_And_Get(
7137: p_encoded => FND_API.G_FALSE,
7138: p_count => x_msg_count,
7139: p_data => x_msg_data);

Line 7136: FND_MSG_PUB.Count_And_Get(

7132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7133: x_msg_count := 1;
7134: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
7135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7136: FND_MSG_PUB.Count_And_Get(
7137: p_encoded => FND_API.G_FALSE,
7138: p_count => x_msg_count,
7139: p_data => x_msg_data);
7140: RETURN;

Line 7575: FND_MSG_PUB.initialize;

7571:
7572: -- Initialize message list if p_init_msg_list is set to TRUE.
7573: IF FND_API.to_Boolean( p_init_msg_list )
7574: THEN
7575: FND_MSG_PUB.initialize;
7576: END IF;
7577:
7578: -- Initialize API return status to SUCCESS
7579: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7976: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7972: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974: x_msg_count := 1;
7975: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
7976: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7977: FND_MSG_PUB.Count_And_Get(
7978: p_encoded => FND_API.G_FALSE,
7979: p_count => x_msg_count,
7980: p_data => x_msg_data);

Line 7977: FND_MSG_PUB.Count_And_Get(

7973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7974: x_msg_count := 1;
7975: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
7976: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7977: FND_MSG_PUB.Count_And_Get(
7978: p_encoded => FND_API.G_FALSE,
7979: p_count => x_msg_count,
7980: p_data => x_msg_data);
7981: RETURN;

Line 8127: FND_MSG_PUB.initialize;

8123:
8124: -- Initialize message list if p_init_msg_list is set to TRUE.
8125: IF FND_API.to_Boolean( p_init_msg_list )
8126: THEN
8127: FND_MSG_PUB.initialize;
8128: END IF;
8129:
8130: -- Initialize API return status to SUCCESS
8131: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

8594: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
8595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8596: x_msg_count := 1;
8597: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
8598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8599: FND_MSG_PUB.Count_And_Get(
8600: p_encoded => FND_API.G_FALSE,
8601: p_count => x_msg_count,
8602: p_data => x_msg_data);

Line 8599: FND_MSG_PUB.Count_And_Get(

8595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8596: x_msg_count := 1;
8597: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
8598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8599: FND_MSG_PUB.Count_And_Get(
8600: p_encoded => FND_API.G_FALSE,
8601: p_count => x_msg_count,
8602: p_data => x_msg_data);
8603: RAISE;

Line 8808: FND_MSG_PUB.initialize;

8804:
8805: -- Initialize message list if p_init_msg_list is set to TRUE.
8806: IF FND_API.to_Boolean( p_init_msg_list )
8807: THEN
8808: FND_MSG_PUB.initialize;
8809: END IF;
8810:
8811: -- Initialize API return status to SUCCESS
8812: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9599: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

9595: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
9596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9597: x_msg_count := 1;
9598: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
9599: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9600: FND_MSG_PUB.Count_And_Get(
9601: p_encoded => FND_API.G_FALSE,
9602: p_count => x_msg_count,
9603: p_data => x_msg_data);

Line 9600: FND_MSG_PUB.Count_And_Get(

9596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9597: x_msg_count := 1;
9598: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
9599: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9600: FND_MSG_PUB.Count_And_Get(
9601: p_encoded => FND_API.G_FALSE,
9602: p_count => x_msg_count,
9603: p_data => x_msg_data);
9604: RETURN;

Line 9735: FND_MSG_PUB.initialize;

9731:
9732: -- Initialize message list if p_init_msg_list is set to TRUE.
9733: IF FND_API.to_Boolean( p_init_msg_list )
9734: THEN
9735: FND_MSG_PUB.initialize;
9736: END IF;
9737:
9738: -- Initialize API return status to SUCCESS
9739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

9986: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
9987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9988: x_msg_count := 1;
9989: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
9990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9991: FND_MSG_PUB.Count_And_Get(
9992: p_encoded => FND_API.G_FALSE,
9993: p_count => x_msg_count,
9994: p_data => x_msg_data);

Line 9991: FND_MSG_PUB.Count_And_Get(

9987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9988: x_msg_count := 1;
9989: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
9990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9991: FND_MSG_PUB.Count_And_Get(
9992: p_encoded => FND_API.G_FALSE,
9993: p_count => x_msg_count,
9994: p_data => x_msg_data);
9995: RETURN;

Line 10112: FND_MSG_PUB.initialize;

10108:
10109: -- Initialize message list if p_init_msg_list is set to TRUE.
10110: IF FND_API.to_Boolean( p_init_msg_list )
10111: THEN
10112: FND_MSG_PUB.initialize;
10113: END IF;
10114:
10115: -- Initialize API return status to SUCCESS
10116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10196: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
10197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10198: x_msg_count := 1;
10199: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10201: FND_MSG_PUB.Count_And_Get(
10202: p_encoded => FND_API.G_FALSE,
10203: p_count => x_msg_count,
10204: p_data => x_msg_data);

Line 10201: FND_MSG_PUB.Count_And_Get(

10197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10198: x_msg_count := 1;
10199: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10201: FND_MSG_PUB.Count_And_Get(
10202: p_encoded => FND_API.G_FALSE,
10203: p_count => x_msg_count,
10204: p_data => x_msg_data);
10205: RETURN;

Line 10321: FND_MSG_PUB.initialize;

10317:
10318: -- Initialize message list if p_init_msg_list is set to TRUE.
10319: IF FND_API.to_Boolean( p_init_msg_list )
10320: THEN
10321: FND_MSG_PUB.initialize;
10322: END IF;
10323:
10324: -- Initialize API return status to SUCCESS
10325: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10407: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10403: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
10404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10405: x_msg_count := 1;
10406: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10407: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10408: FND_MSG_PUB.Count_And_Get(
10409: p_encoded => FND_API.G_FALSE,
10410: p_count => x_msg_count,
10411: p_data => x_msg_data);

Line 10408: FND_MSG_PUB.Count_And_Get(

10404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10405: x_msg_count := 1;
10406: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10407: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10408: FND_MSG_PUB.Count_And_Get(
10409: p_encoded => FND_API.G_FALSE,
10410: p_count => x_msg_count,
10411: p_data => x_msg_data);
10412: RETURN;

Line 10529: FND_MSG_PUB.initialize;

10525:
10526: -- Initialize message list if p_init_msg_list is set to TRUE.
10527: IF FND_API.to_Boolean( p_init_msg_list )
10528: THEN
10529: FND_MSG_PUB.initialize;
10530: END IF;
10531:
10532: -- Initialize API return status to SUCCESS
10533: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10614: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
10615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10616: x_msg_count := 1;
10617: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10619: FND_MSG_PUB.Count_And_Get(
10620: p_encoded => FND_API.G_FALSE,
10621: p_count => x_msg_count,
10622: p_data => x_msg_data);

Line 10619: FND_MSG_PUB.Count_And_Get(

10615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10616: x_msg_count := 1;
10617: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
10618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10619: FND_MSG_PUB.Count_And_Get(
10620: p_encoded => FND_API.G_FALSE,
10621: p_count => x_msg_count,
10622: p_data => x_msg_data);
10623: RETURN;