eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_ASSETS_PUB dependencies on FND_MSG_PUB

Line 339: FND_MSG_PUB.initialize;

335:
336:
337: -- Initialize the message table if requested.
338: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
339: FND_MSG_PUB.initialize;
340: END IF;
341:
342:
343: -- Set API return status to success

Line 363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

359:
360: -- pm_product_code is mandatory
361: IF p_pm_product_code IS NULL OR p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
362:
363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
364: pa_interface_utils_pub.map_new_amg_msg
365: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
366: ,p_msg_attribute => 'CHANGE'
367: ,p_resize_flag => 'N'

Line 1805: FND_MSG_PUB.Count_And_Get

1801: ROLLBACK TO add_project_asset_pub;
1802:
1803: p_return_status := FND_API.G_RET_STS_ERROR;
1804:
1805: FND_MSG_PUB.Count_And_Get
1806: ( p_count => p_msg_count ,
1807: p_data => p_msg_data );
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1814: FND_MSG_PUB.Count_And_Get

1810: ROLLBACK TO add_project_asset_pub;
1811:
1812: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1813:
1814: FND_MSG_PUB.Count_And_Get
1815: ( p_count => p_msg_count ,
1816: p_data => p_msg_data );
1817:
1818: WHEN OTHERS THEN

Line 1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1819: ROLLBACK TO add_project_asset_pub;
1820:
1821: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1822:
1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1824: FND_MSG_PUB.add_exc_msg
1825: ( p_pkg_name => G_PKG_NAME
1826: , p_procedure_name => l_api_name );
1827:

Line 1824: FND_MSG_PUB.add_exc_msg

1820:
1821: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1822:
1823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1824: FND_MSG_PUB.add_exc_msg
1825: ( p_pkg_name => G_PKG_NAME
1826: , p_procedure_name => l_api_name );
1827:
1828: END IF;

Line 1830: FND_MSG_PUB.Count_And_Get

1826: , p_procedure_name => l_api_name );
1827:
1828: END IF;
1829:
1830: FND_MSG_PUB.Count_And_Get
1831: ( p_count => p_msg_count ,
1832: p_data => p_msg_data );
1833:
1834: END add_project_asset;

Line 2086: FND_MSG_PUB.initialize;

2082:
2083:
2084: -- Initialize the message table if requested.
2085: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2086: FND_MSG_PUB.initialize;
2087: END IF;
2088:
2089:
2090: -- Set API return status to success

Line 2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2093:
2094: -- pm_product_code is mandatory
2095: IF p_pm_product_code IS NULL OR p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2096:
2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2098: pa_interface_utils_pub.map_new_amg_msg
2099: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
2100: ,p_msg_attribute => 'CHANGE'
2101: ,p_resize_flag => 'N'

Line 2743: FND_MSG_PUB.Count_And_Get

2739: ROLLBACK TO add_asset_assignment_pub;
2740:
2741: p_return_status := FND_API.G_RET_STS_ERROR;
2742:
2743: FND_MSG_PUB.Count_And_Get
2744: ( p_count => p_msg_count ,
2745: p_data => p_msg_data );
2746:
2747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2752: FND_MSG_PUB.Count_And_Get

2748: ROLLBACK TO add_asset_assignment_pub;
2749:
2750: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2751:
2752: FND_MSG_PUB.Count_And_Get
2753: ( p_count => p_msg_count ,
2754: p_data => p_msg_data );
2755:
2756: WHEN OTHERS THEN

Line 2761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2757: ROLLBACK TO add_asset_assignment_pub;
2758:
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:
2761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2762: FND_MSG_PUB.add_exc_msg
2763: ( p_pkg_name => G_PKG_NAME
2764: , p_procedure_name => l_api_name );
2765:

Line 2762: FND_MSG_PUB.add_exc_msg

2758:
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:
2761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2762: FND_MSG_PUB.add_exc_msg
2763: ( p_pkg_name => G_PKG_NAME
2764: , p_procedure_name => l_api_name );
2765:
2766: END IF;

Line 2768: FND_MSG_PUB.Count_And_Get

2764: , p_procedure_name => l_api_name );
2765:
2766: END IF;
2767:
2768: FND_MSG_PUB.Count_And_Get
2769: ( p_count => p_msg_count ,
2770: p_data => p_msg_data );
2771:
2772: END add_asset_assignment;

Line 3197: FND_MSG_PUB.initialize;

3193:
3194:
3195: -- Initialize the message table if requested.
3196: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
3197: FND_MSG_PUB.initialize;
3198: END IF;
3199:
3200:
3201: -- Set API return status to success

Line 3208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3204:
3205: -- pm_product_code is mandatory
3206: IF p_pm_product_code IS NULL OR p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3207:
3208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3209: pa_interface_utils_pub.map_new_amg_msg
3210: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
3211: ,p_msg_attribute => 'CHANGE'
3212: ,p_resize_flag => 'N'

Line 5490: FND_MSG_PUB.Count_And_Get

5486: ROLLBACK TO update_project_asset_pub;
5487:
5488: p_return_status := FND_API.G_RET_STS_ERROR;
5489:
5490: FND_MSG_PUB.Count_And_Get
5491: ( p_count => p_msg_count ,
5492: p_data => p_msg_data );
5493:
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5499: FND_MSG_PUB.Count_And_Get

5495: ROLLBACK TO update_project_asset_pub;
5496:
5497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5498:
5499: FND_MSG_PUB.Count_And_Get
5500: ( p_count => p_msg_count ,
5501: p_data => p_msg_data );
5502:
5503:

Line 5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5505: ROLLBACK TO update_project_asset_pub;
5506:
5507: p_return_status := FND_API.G_RET_STS_ERROR;
5508:
5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);

Line 5514: FND_MSG_PUB.ADD;

5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5515: END IF;
5516:
5517: FND_MSG_PUB.Count_And_Get
5518: ( p_count => p_msg_count ,

Line 5517: FND_MSG_PUB.Count_And_Get

5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5515: END IF;
5516:
5517: FND_MSG_PUB.Count_And_Get
5518: ( p_count => p_msg_count ,
5519: p_data => p_msg_data );
5520:
5521:

Line 5527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5523: ROLLBACK TO update_project_asset_pub;
5524:
5525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5526:
5527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5528: FND_MSG_PUB.add_exc_msg
5529: ( p_pkg_name => G_PKG_NAME
5530: , p_procedure_name => l_api_name );
5531:

Line 5528: FND_MSG_PUB.add_exc_msg

5524:
5525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5526:
5527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5528: FND_MSG_PUB.add_exc_msg
5529: ( p_pkg_name => G_PKG_NAME
5530: , p_procedure_name => l_api_name );
5531:
5532: END IF;

Line 5534: FND_MSG_PUB.Count_And_Get

5530: , p_procedure_name => l_api_name );
5531:
5532: END IF;
5533:
5534: FND_MSG_PUB.Count_And_Get
5535: ( p_count => p_msg_count ,
5536: p_data => p_msg_data );
5537:
5538: END update_project_asset;

Line 5616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5612: OPEN l_project_id_csr;
5613: FETCH l_project_id_csr INTO l_dummy;
5614:
5615: IF l_project_id_csr%NOTFOUND THEN
5616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5617: pa_interface_utils_pub.map_new_amg_msg
5618: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
5619: ,p_msg_attribute => 'CHANGE'
5620: ,p_resize_flag => 'N'

Line 5635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5631: END IF;
5632:
5633: CLOSE l_project_id_csr;
5634: ELSE --p_pa_project_id has not been specified
5635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5636:
5637: pa_interface_utils_pub.map_new_amg_msg
5638: ( p_old_message_code => 'PA_PROJECT_ID_MISSING'
5639: ,p_msg_attribute => 'CHANGE'

Line 5666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5662: OPEN l_project_asset_id_csr;
5663: FETCH l_project_asset_id_csr INTO l_dummy;
5664:
5665: IF l_project_asset_id_csr%NOTFOUND THEN
5666: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5667: pa_interface_utils_pub.map_new_amg_msg
5668: ( p_old_message_code => 'PA_PROJ_ASSET_ID_INVALID'
5669: ,p_msg_attribute => 'CHANGE'
5670: ,p_resize_flag => 'N'

Line 5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5691: FETCH l_asset_csr INTO l_asset_rec;
5692: IF l_asset_csr%NOTFOUND THEN
5693: CLOSE l_asset_csr;
5694:
5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5696: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
5697: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Asset Reference');
5698: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_asset_reference);
5699: FND_MSG_PUB.add;

Line 5699: FND_MSG_PUB.add;

5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5696: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
5697: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Asset Reference');
5698: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_asset_reference);
5699: FND_MSG_PUB.add;
5700:
5701: RAISE FND_API.G_EXC_ERROR;
5702: END IF;
5703: ELSE

Line 5709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5705: CLOSE l_asset_csr;
5706: END IF;
5707:
5708: ELSE --Neither Project Asset ID nor PM Asset Reference Specified
5709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5710: pa_interface_utils_pub.map_new_amg_msg
5711: ( p_old_message_code => 'PA_ASSET_REF_ID_MISSING'
5712: ,p_msg_attribute => 'CHANGE'
5713: ,p_resize_flag => 'N'

Line 5744: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5740: /* dbms_output.put_line('handling an OTHERS exception'); */
5741:
5742: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5743:
5744: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5745: FND_MSG_PUB.add_exc_msg
5746: ( p_pkg_name => G_PKG_NAME
5747: , p_procedure_name => l_api_name );
5748:

Line 5745: FND_MSG_PUB.add_exc_msg

5741:
5742: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5743:
5744: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5745: FND_MSG_PUB.add_exc_msg
5746: ( p_pkg_name => G_PKG_NAME
5747: , p_procedure_name => l_api_name );
5748:
5749: END IF;

Line 5868: FND_MSG_PUB.initialize;

5864:
5865:
5866: -- Initialize the message table if requested.
5867: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
5868: FND_MSG_PUB.initialize;
5869: END IF;
5870:
5871:
5872: -- Set API return status to success

Line 5919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5915: WHEN OTHERS THEN
5916: ROLLBACK TO load_asset_assignment_pub;
5917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5918:
5919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5920:
5921: FND_MSG_PUB.add_exc_msg
5922: ( p_pkg_name => G_PKG_NAME
5923: , p_procedure_name => l_api_name );

Line 5921: FND_MSG_PUB.add_exc_msg

5917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5918:
5919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5920:
5921: FND_MSG_PUB.add_exc_msg
5922: ( p_pkg_name => G_PKG_NAME
5923: , p_procedure_name => l_api_name );
5924: END IF;
5925:

Line 6017: FND_MSG_PUB.initialize;

6013:
6014:
6015: -- Initialize the message table if requested.
6016: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
6017: FND_MSG_PUB.initialize;
6018: END IF;
6019:
6020:
6021: -- Set API return status to success

Line 6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6083: WHEN OTHERS THEN
6084: ROLLBACK TO load_project_asset_pub;
6085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6086:
6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6088:
6089: FND_MSG_PUB.add_exc_msg
6090: ( p_pkg_name => G_PKG_NAME
6091: , p_procedure_name => l_api_name );

Line 6089: FND_MSG_PUB.add_exc_msg

6085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6086:
6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6088:
6089: FND_MSG_PUB.add_exc_msg
6090: ( p_pkg_name => G_PKG_NAME
6091: , p_procedure_name => l_api_name );
6092: END IF;
6093:

Line 6198: FND_MSG_PUB.initialize;

6194:
6195:
6196: -- Initialize the message table if requested.
6197: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
6198: FND_MSG_PUB.initialize;
6199: END IF;
6200:
6201:
6202: -- Set API return status to success

Line 6276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6272: IF l_amg_asset_csr%NOTFOUND THEN
6273:
6274: CLOSE l_amg_asset_csr;
6275: --Project Asset ID specified is not valid for Project
6276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6277: pa_interface_utils_pub.map_new_amg_msg
6278: ( p_old_message_code => 'PA_PROJ_ASSET_ID_INVALID'
6279: ,p_msg_attribute => 'CHANGE'
6280: ,p_resize_flag => 'N'

Line 6496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6492: OPEN l_amg_task_csr( l_project_id, l_task_id );
6493: FETCH l_amg_task_csr INTO l_amg_pa_task_number;
6494: IF l_amg_task_csr%NOTFOUND THEN
6495: --Task is not valid for Project specified
6496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6497: pa_interface_utils_pub.map_new_amg_msg
6498: (p_old_message_code => 'PA_TASK_ID_INVALID'
6499: ,p_msg_attribute => 'CHANGE'
6500: ,p_resize_flag => 'N'

Line 6547: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6543: IF l_amg_asset_csr%NOTFOUND THEN
6544:
6545: CLOSE l_amg_asset_csr;
6546: --Project Asset ID specified is not valid for Project
6547: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6548: pa_interface_utils_pub.map_new_amg_msg
6549: ( p_old_message_code => 'PA_PROJ_ASSET_ID_INVALID'
6550: ,p_msg_attribute => 'CHANGE'
6551: ,p_resize_flag => 'N'

Line 6648: FND_MSG_PUB.Count_And_Get

6644: WHEN FND_API.G_EXC_ERROR THEN
6645: ROLLBACK TO execute_add_project_asset_pub;
6646: p_return_status := FND_API.G_RET_STS_ERROR;
6647:
6648: FND_MSG_PUB.Count_And_Get
6649: ( p_count => p_msg_count ,
6650: p_data => p_msg_data );
6651:
6652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6656: FND_MSG_PUB.Count_And_Get

6652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6653: ROLLBACK TO execute_add_project_asset_pub;
6654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6655:
6656: FND_MSG_PUB.Count_And_Get
6657: ( p_count => p_msg_count ,
6658: p_data => p_msg_data );
6659:
6660: WHEN OTHERS THEN

Line 6664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6660: WHEN OTHERS THEN
6661: ROLLBACK TO execute_add_project_asset_pub;
6662: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6663:
6664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6665: FND_MSG_PUB.add_exc_msg
6666: ( p_pkg_name => G_PKG_NAME
6667: , p_procedure_name => l_api_name );
6668: END IF;

Line 6665: FND_MSG_PUB.add_exc_msg

6661: ROLLBACK TO execute_add_project_asset_pub;
6662: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6663:
6664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6665: FND_MSG_PUB.add_exc_msg
6666: ( p_pkg_name => G_PKG_NAME
6667: , p_procedure_name => l_api_name );
6668: END IF;
6669:

Line 6670: FND_MSG_PUB.Count_And_Get

6666: ( p_pkg_name => G_PKG_NAME
6667: , p_procedure_name => l_api_name );
6668: END IF;
6669:
6670: FND_MSG_PUB.Count_And_Get
6671: ( p_count => p_msg_count ,
6672: p_data => p_msg_data );
6673:
6674: END execute_add_project_asset;

Line 6772: FND_MSG_PUB.initialize;

6768:
6769:
6770: -- Initialize the message table if requested.
6771: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
6772: FND_MSG_PUB.initialize;
6773: END IF;
6774:
6775:
6776: -- Set API return status to success

Line 6783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6779:
6780: -- pm_product_code is mandatory
6781: IF p_pm_product_code IS NULL OR p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
6782:
6783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6784: pa_interface_utils_pub.map_new_amg_msg
6785: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
6786: ,p_msg_attribute => 'CHANGE'
6787: ,p_resize_flag => 'N'

Line 6955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6951: IF ((p_pa_project_asset_id IS NULL OR p_pa_project_asset_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6952: AND (p_pm_asset_reference IS NULL OR p_pm_asset_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN
6953:
6954: --Cannot determine asset to delete
6955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6956: pa_interface_utils_pub.map_new_amg_msg
6957: (p_old_message_code => 'PA_DELETE_ASSET_FAILED_AS'
6958: ,p_msg_attribute => 'CHANGE'
6959: ,p_resize_flag => 'N'

Line 7003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

6999:
7000: IF v_asset_can_be_deleted = 0 THEN
7001:
7002: --Cannot delete asset, since asset lines exist
7003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7004: pa_interface_utils_pub.map_new_amg_msg
7005: (p_old_message_code => 'PA_ASSET_CANNOT_DELETE_AS'
7006: ,p_msg_attribute => 'CHANGE'
7007: ,p_resize_flag => 'N'

Line 7055: FND_MSG_PUB.Count_And_Get

7051: ROLLBACK TO delete_project_asset_pub;
7052:
7053: p_return_status := FND_API.G_RET_STS_ERROR;
7054:
7055: FND_MSG_PUB.Count_And_Get
7056: ( p_count => p_msg_count ,
7057: p_data => p_msg_data );
7058:
7059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7064: FND_MSG_PUB.Count_And_Get

7060: ROLLBACK TO delete_project_asset_pub;
7061:
7062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7063:
7064: FND_MSG_PUB.Count_And_Get
7065: ( p_count => p_msg_count ,
7066: p_data => p_msg_data );
7067:
7068: WHEN OTHERS THEN

Line 7073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7069: ROLLBACK TO delete_project_asset_pub;
7070:
7071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072:
7073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7074: FND_MSG_PUB.add_exc_msg
7075: ( p_pkg_name => G_PKG_NAME
7076: , p_procedure_name => l_api_name );
7077:

Line 7074: FND_MSG_PUB.add_exc_msg

7070:
7071: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7072:
7073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7074: FND_MSG_PUB.add_exc_msg
7075: ( p_pkg_name => G_PKG_NAME
7076: , p_procedure_name => l_api_name );
7077:
7078: END IF;

Line 7080: FND_MSG_PUB.Count_And_Get

7076: , p_procedure_name => l_api_name );
7077:
7078: END IF;
7079:
7080: FND_MSG_PUB.Count_And_Get
7081: ( p_count => p_msg_count ,
7082: p_data => p_msg_data );
7083:
7084: END delete_project_asset;

Line 7180: FND_MSG_PUB.initialize;

7176:
7177:
7178: -- Initialize the message table if requested.
7179: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
7180: FND_MSG_PUB.initialize;
7181: END IF;
7182:
7183:
7184: -- Set API return status to success

Line 7191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7187:
7188: -- pm_product_code is mandatory
7189: IF p_pm_product_code IS NULL OR p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
7190:
7191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7192: pa_interface_utils_pub.map_new_amg_msg
7193: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
7194: ,p_msg_attribute => 'CHANGE'
7195: ,p_resize_flag => 'N'

Line 7415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

7411: IF existing_assignment_cur%NOTFOUND THEN
7412:
7413: CLOSE existing_assignment_cur;
7414: --No matching assignment currently exists
7415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7416: pa_interface_utils_pub.map_new_amg_msg
7417: (p_old_message_code => 'PA_DELETE_AS_ASSIGN_FAILED'
7418: ,p_msg_attribute => 'CHANGE'
7419: ,p_resize_flag => 'N'

Line 7457: FND_MSG_PUB.Count_And_Get

7453: ROLLBACK TO delete_asset_assignment_pub;
7454:
7455: p_return_status := FND_API.G_RET_STS_ERROR;
7456:
7457: FND_MSG_PUB.Count_And_Get
7458: ( p_count => p_msg_count ,
7459: p_data => p_msg_data );
7460:
7461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7466: FND_MSG_PUB.Count_And_Get

7462: ROLLBACK TO delete_asset_assignment_pub;
7463:
7464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7465:
7466: FND_MSG_PUB.Count_And_Get
7467: ( p_count => p_msg_count ,
7468: p_data => p_msg_data );
7469:
7470: WHEN OTHERS THEN

Line 7475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7471: ROLLBACK TO delete_asset_assignment_pub;
7472:
7473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7474:
7475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7476: FND_MSG_PUB.add_exc_msg
7477: ( p_pkg_name => G_PKG_NAME
7478: , p_procedure_name => l_api_name );
7479:

Line 7476: FND_MSG_PUB.add_exc_msg

7472:
7473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7474:
7475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7476: FND_MSG_PUB.add_exc_msg
7477: ( p_pkg_name => G_PKG_NAME
7478: , p_procedure_name => l_api_name );
7479:
7480: END IF;

Line 7482: FND_MSG_PUB.Count_And_Get

7478: , p_procedure_name => l_api_name );
7479:
7480: END IF;
7481:
7482: FND_MSG_PUB.Count_And_Get
7483: ( p_count => p_msg_count ,
7484: p_data => p_msg_data );
7485:
7486: END delete_asset_assignment;