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_STRUCTURE_UTILS dependencies on FND_MSG_PUB

Line 112: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

108:
109: -- 4537865 RESET OUT PARAMS
110: x_error_message_code := SQLERRM ;
111:
112: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
113: p_procedure_name => 'Check_Delete_Structure_Ver_Ok');
114: RAISE;
115: END Check_Delete_Structure_Ver_Ok;
116:

Line 320: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: -- 4537865 RESET OUT PARAMS
318: x_error_message_code := SQLERRM ;
319:
320: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
321: p_procedure_name => 'Check_Structure_Type_Exists');
322: RAISE;
323: END Check_Structure_Type_Exists;
324:

Line 695: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

691: -- 4537865 RESET OUT PARAMS
692: x_structure_version_name := NULL ;
693: x_error_message_code := SQLERRM ;
694:
695: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
696: p_procedure_name => 'Get_New_Struc_Ver_Name');
697: RAISE;
698: END;
699:

Line 1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

1385: p_min_sch_start_date := NULL ;
1386: p_rollup_last_update_date := NULL ;
1387: p_max_sch_finish_date := NULL ;
1388:
1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
1390: p_procedure_name => 'Get_Rollup_Dates',
1391: p_error_text => SUBSTRB(SQLERRM,1,240)
1392: );
1393: RAISE ;

Line 1453: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: p_structure_version_id := NULL;
1452:
1453: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
1454: p_procedure_name => 'Get_Workplan_Version',
1455: p_error_text => SUBSTRB(SQLERRM,1,240)
1456: );
1457: RAISE ;

Line 1518: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: p_structure_version_id := NULL;
1517:
1518: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
1519: p_procedure_name => 'Get_Financial_Version',
1520: p_error_text => SUBSTRB(SQLERRM,1,240)
1521: );
1522: RAISE ;

Line 1701: x_msg_count := FND_MSG_PUB.count_msg;

1697: CLOSE get_missing_tasks;
1698: END IF;
1699: CLOSE get_latest_pub_ver;
1700:
1701: x_msg_count := FND_MSG_PUB.count_msg;
1702: IF (x_msg_count > 0) THEN
1703: raise FND_API.G_EXC_ERROR;
1704: END IF;
1705:

Line 1716: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

1712: --4537865
1713: x_msg_count := 1;
1714: x_msg_data := SQLERRM ;
1715:
1716: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
1717: p_procedure_name => 'check_miss_transaction_tasks',
1718: p_error_text => x_msg_data); -- 4537865
1719: RAISE;
1720: END check_miss_transaction_tasks;

Line 1939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

1935: WHEN OTHERS THEN
1936: x_err_msg_code := SQLCODE;
1937: x_return_status := 'N'; -- Based on Usage of this API
1938:
1939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
1940: p_procedure_name => 'check_enable_wp_ok',
1941: p_error_text => SUBSTRB(SQLERRM,1,240)
1942: );
1943: RAISE ;

Line 2034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2030: WHEN OTHERS THEN
2031: x_err_msg_code := SQLCODE;
2032: x_return_status := 'N'; -- Based on Usage of this API
2033:
2034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2035: p_procedure_name => 'check_disable_wp_ok',
2036: p_error_text => SUBSTRB(SQLERRM,1,240)
2037: );
2038: RAISE ;

Line 2116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2112: WHEN OTHERS THEN
2113: x_err_msg_code := SQLCODE;
2114: x_return_status := 'N'; -- Based on Usage of this API
2115:
2116: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2117: p_procedure_name => 'check_sharing_on_ok',
2118: p_error_text => SUBSTRB(SQLERRM,1,240)
2119: );
2120: RAISE ;

Line 2176: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2172: WHEN OTHERS THEN
2173: x_err_msg_code := SQLCODE;
2174: x_return_status := 'N'; -- Based on Usage of this API
2175:
2176: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2177: p_procedure_name => 'check_sharing_off_ok',
2178: p_error_text => SUBSTRB(SQLERRM,1,240)
2179: );
2180: RAISE ;

Line 2341: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2337: WHEN OTHERS THEN
2338: x_err_msg_code := SQLCODE;
2339: x_return_status := 'N'; -- Based on Usage of this API
2340:
2341: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2342: p_procedure_name => 'check_versioning_on_ok',
2343: p_error_text => SUBSTRB(SQLERRM,1,240)
2344: );
2345: RAISE ;

Line 2392: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2388: WHEN OTHERS THEN
2389: x_err_msg_code := SQLCODE;
2390: x_return_status := 'N'; -- Based on Usage of this API
2391:
2392: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2393: p_procedure_name => 'check_versioning_off_ok',
2394: p_error_text => SUBSTRB(SQLERRM,1,240)
2395: );
2396: RAISE ;

Line 2934: x_msg_count := FND_MSG_PUB.count_msg;

2930: END IF;
2931: END LOOP;
2932: CLOSE c1;
2933:
2934: x_msg_count := FND_MSG_PUB.count_msg;
2935: IF (x_msg_count > 0) THEN
2936: raise FND_API.G_EXC_ERROR;
2937: END IF;
2938:

Line 2943: x_msg_count := FND_MSG_PUB.count_msg; -- 4537865

2939: x_return_status := FND_API.G_RET_STS_SUCCESS;
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: x_return_status := FND_API.G_RET_STS_ERROR;
2943: x_msg_count := FND_MSG_PUB.count_msg; -- 4537865
2944: x_msg_data := l_message_text ; -- 4537865
2945:
2946: WHEN OTHERS THEN
2947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

2946: WHEN OTHERS THEN
2947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2948: x_msg_count := 1; -- 4537865
2949: x_msg_data := SQLERRM ; -- 4537865
2950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
2951: p_procedure_name => 'Check_txn_on_summary_tasks',
2952: p_error_text => x_msg_data); -- 4537865
2953: RAISE;
2954: END Check_txn_on_summary_tasks;

Line 3043: x_msg_count := FND_MSG_PUB.count_msg;

3039: CLOSE c2;
3040: END LOOP;
3041: CLOSE c1;
3042:
3043: x_msg_count := FND_MSG_PUB.count_msg;
3044: IF (x_msg_count > 0) THEN
3045: raise FND_API.G_EXC_ERROR;
3046: END IF;
3047:

Line 3053: x_msg_count := FND_MSG_PUB.count_msg; -- 4537865

3049:
3050: EXCEPTION
3051: WHEN FND_API.G_EXC_ERROR THEN
3052: x_return_status := FND_API.G_RET_STS_ERROR;
3053: x_msg_count := FND_MSG_PUB.count_msg; -- 4537865
3054: x_msg_data := 'PA_PS_PUB_TK_STATS_ERR'; -- 4537865
3055:
3056: WHEN OTHERS THEN
3057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3060: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

3056: WHEN OTHERS THEN
3057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3058: x_msg_count := 1; -- 4537865
3059: x_msg_data := SQLERRM ; -- 4537865
3060: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
3061: p_procedure_name => 'Check_tasks_statuses_valid',
3062: p_error_text => x_msg_data ); -- 4537865
3063: RAISE;
3064: END check_tasks_statuses_valid;

Line 3617: l_msg_count := FND_MSG_PUB.count_msg;

3613:
3614: WHEN Invalid_Arg_Exc_WP THEN
3615:
3616: x_return_status := FND_API.G_RET_STS_ERROR;
3617: l_msg_count := FND_MSG_PUB.count_msg;
3618:
3619: -- 4537865 RESET OUT PARAMS
3620: x_request_id := NULL ;
3621: x_process_code := NULL ;

Line 3662: FND_MSG_PUB.add_exc_msg

3658: IF cur_request_details%ISOPEN THEN
3659: CLOSE cur_request_details;
3660: END IF;
3661:
3662: FND_MSG_PUB.add_exc_msg
3663: ( p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS'
3664: ,p_procedure_name => 'GET_CONC_REQUEST_DETAILS'
3665: ,p_error_text => x_msg_data);
3666:

Line 4481: Fnd_Msg_Pub.add_exc_msg

4477: x_message_type := NULL ;
4478: x_structure_version_id := NULL ;
4479: x_conc_request_id := NULL ;
4480:
4481: Fnd_Msg_Pub.add_exc_msg
4482: ( p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS'
4483: , p_procedure_name => 'GET_PROCESS_STATUS_MSG'
4484: , p_error_text => SUBSTRB(SQLERRM,1,240));
4485:

Line 4753: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

4749: x_message_name := NULL ;
4750: x_message_type := NULL ;
4751: x_structure_version_id := NULL ;
4752: x_conc_request_id := NULL ;
4753: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
4754: p_procedure_name => 'get_structure_msg',
4755: p_error_text => SUBSTRB(SQLERRM,1,240));
4756: RAISE;
4757: end get_structure_msg;

Line 4856: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

4852:
4853: when others then
4854: /* rollback to lock_unlock_wp_str; bug#6414944*/
4855: rollback; /*Bug# 6414944*/
4856: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
4857: p_procedure_name => 'lock_unlock_wp_str_autonomous',
4858: p_error_text => SUBSTRB(SQLERRM,1,240));
4859:
4860: end lock_unlock_wp_str_autonomous;

Line 4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',

4948: rollback to lock_unlock_wp_str2;
4949:
4950: when others then
4951: rollback to lock_unlock_wp_str2;
4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_UTILS',
4953: p_procedure_name => 'lock_unlock_wp_str',
4954: p_error_text => SUBSTRB(SQLERRM,1,240));
4955:
4956: end lock_unlock_wp_str;

Line 5071: FND_MSG_PUB.add;

5067: -- Commenting out the following as the messages are changed in the FD.
5068: -- Now as per the latest FD the above message doesnt need any tokens.
5069: -- FND_MESSAGE.set_token('VER_NAME',l_version_name);
5070: -- FND_MESSAGE.set_token('VER_NUMBER',l_version_number);
5071: FND_MSG_PUB.add;
5072:
5073: return 'N';
5074: END IF;
5075:

Line 5082: FND_MSG_PUB.add;

5078: -- Commenting out the following as the messages are changed in the FD.
5079: -- Now as per the latest FD the above message doesnt need any tokens.
5080: -- FND_MESSAGE.set_token('VER_NAME',l_version_name);
5081: -- FND_MESSAGE.set_token('VER_NUMBER',l_version_number);
5082: FND_MSG_PUB.add;
5083:
5084: return 'N';
5085: END IF;
5086:

Line 5095: FND_MSG_PUB.add;

5091: -- Commenting out the following as the messages are changed in the FD.
5092: -- Now as per the latest FD the above message doesnt need any tokens.
5093: -- FND_MESSAGE.set_token('VER_NAME',l_version_name);
5094: -- FND_MESSAGE.set_token('VER_NUMBER',l_version_number);
5095: FND_MSG_PUB.add;
5096: CLOSE link_exists_cur;
5097: return 'N';
5098: END IF;
5099: CLOSE link_exists_cur;

Line 5399: x_msg_count := FND_MSG_PUB.count_msg;

5395:
5396: EXCEPTION
5397: WHEN FND_API.G_EXC_ERROR THEN
5398: x_return_status := FND_API.G_RET_STS_ERROR;
5399: x_msg_count := FND_MSG_PUB.count_msg;
5400:
5401: IF x_msg_count > 0 THEN
5402: PA_INTERFACE_UTILS_PUB.get_messages (
5403: p_encoded => FND_API.G_FALSE

Line 5413: x_msg_count := FND_MSG_PUB.count_msg;

5409: END IF;
5410:
5411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5413: x_msg_count := FND_MSG_PUB.count_msg;
5414:
5415: IF x_msg_count > 0 THEN
5416: PA_INTERFACE_UTILS_PUB.get_messages (
5417: p_encoded => FND_API.G_FALSE

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

5425: WHEN OTHERS THEN
5426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5427: x_msg_count := 1;
5428: x_msg_data := SUBSTRB(SQLERRM, 1, 240);
5429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5430: FND_MSG_PUB.add_exc_msg (
5431: p_pkg_name => 'pa_project_structure_utils'
5432: ,p_procedure_name => 'check_exp_item_dates');
5433: END IF;

Line 5430: FND_MSG_PUB.add_exc_msg (

5426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5427: x_msg_count := 1;
5428: x_msg_data := SUBSTRB(SQLERRM, 1, 240);
5429: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5430: FND_MSG_PUB.add_exc_msg (
5431: p_pkg_name => 'pa_project_structure_utils'
5432: ,p_procedure_name => 'check_exp_item_dates');
5433: END IF;
5434: