[Home] [Help]
276:
277: -- Now that we have checked all of the input parameters,
278: -- raise an error if any of the parameters was invalid.
279: IF l_parameters_valid_flag = 'N' THEN
280: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
281: END IF;
282:
283:
284: -- Step 1: Handle Deletion
306: P_CALLED_MODE => p_called_mode,
307: P_MODULE_NAME => l_module_name);
308: END IF;
309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
310: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
311: END IF;
312:
313: IF P_PA_DEBUG_MODE = 'Y' THEN
314: PA_DEBUG.RESET_CURR_FUNCTION;
391: p_module_name => l_module_name,
392: p_log_level => l_log_level );
393: END LOOP;
394: END IF; -- debug mode logic
395: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
396: END IF; -- duplicate record check
397:
398: -- 0.3. Raise an error if any records with null resource_assignment_id are found.
399: SELECT count(*)
412: p_log_level => l_log_level );
413: END IF;
414: --PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
415: -- p_msg_name => 'PA_RBC_RA_ID_NULL_ERR' );
416: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
417: END IF; -- IF l_null_record_count > 0 THEN
418:
419: -- 0.4. Whenever copy_flag <> 'Y', txn_currency_code should not be null.
420: -- Raise an error if any records with null resource_assignment_id are found.
435: p_log_level => l_log_level );
436: END IF;
437: --PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
438: -- p_msg_name => 'PA_RBC_TXN_CUR_NULL_ERR' );
439: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
440: END IF; -- IF l_null_record_count > 0 THEN
441: END IF; --IF p_copy_flag = 'Y' THEN
442:
443: END IF; -- additional Table Mode validation
470: P_CALLED_MODE => p_called_mode,
471: P_MODULE_NAME => l_module_name);
472: END IF;
473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
474: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
475: END IF;
476:
477: IF P_PA_DEBUG_MODE = 'Y' THEN
478: PA_DEBUG.RESET_CURR_FUNCTION;
508: P_CALLED_MODE => p_called_mode,
509: P_MODULE_NAME => l_module_name);
510: END IF;
511: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
512: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
513: END IF;
514:
515: -- Step 4: Handle Rollup of Amounts
516: ELSIF p_rollup_flag = 'Y' THEN
537: P_CALLED_MODE => p_called_mode,
538: P_MODULE_NAME => l_module_name);
539: END IF;
540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
542: END IF;
543:
544: END IF; -- p_rollup_flag = 'Y'
545:
548: PA_DEBUG.RESET_CURR_FUNCTION;
549: END IF;
550:
551: EXCEPTION
552: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
553:
554: l_msg_count := FND_MSG_PUB.count_msg;
555: IF l_msg_count = 1 THEN
556: PA_INTERFACE_UTILS_PUB.get_messages
836: IF P_PA_DEBUG_MODE = 'Y' THEN
837: PA_DEBUG.RESET_CURR_FUNCTION;
838: END IF;
839: EXCEPTION
840: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
841:
842: l_msg_count := FND_MSG_PUB.count_msg;
843: IF l_msg_count = 1 THEN
844: PA_INTERFACE_UTILS_PUB.get_messages
1088: P_CALLED_MODE => p_called_mode,
1089: P_MODULE_NAME => l_module_name,
1090: P_LOG_LEVEL => l_log_level );
1091: END IF;
1092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1093: END;
1094:
1095: -- Step 1: Select rates and amounts from the appropriate cursor.
1096:
1161: P_CALLED_MODE => p_called_mode,
1162: P_MODULE_NAME => l_module_name,
1163: P_LOG_LEVEL => l_log_level );
1164: END IF;
1165: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1166: ELSIF p_copy_mode = G_COPY_OVERRIDES THEN
1167: OPEN tbl_mode_copy_overrides_csr
1168: (p_src_version_id,
1169: p_fp_cols_rec.x_budget_version_id);
1307: P_MODULE_NAME => l_module_name,
1308: P_LOG_LEVEL => l_log_level );
1309: END IF;
1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1311: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1312: END IF;
1313:
1314: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
1315:
1434: IF P_PA_DEBUG_MODE = 'Y' THEN
1435: PA_DEBUG.RESET_CURR_FUNCTION;
1436: END IF;
1437: EXCEPTION
1438: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1439:
1440: l_msg_count := FND_MSG_PUB.count_msg;
1441: IF l_msg_count = 1 THEN
1442: PA_INTERFACE_UTILS_PUB.get_messages
1617: P_MODULE_NAME => l_module_name,
1618: P_LOG_LEVEL => l_log_level );
1619: END IF;
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1622: END IF;
1623:
1624: INSERT INTO pa_resource_asgn_curr
1625: ( RA_TXN_ID,
1657: IF P_PA_DEBUG_MODE = 'Y' THEN
1658: PA_DEBUG.RESET_CURR_FUNCTION;
1659: END IF;
1660: EXCEPTION
1661: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1662:
1663: l_msg_count := FND_MSG_PUB.count_msg;
1664: IF l_msg_count = 1 THEN
1665: PA_INTERFACE_UTILS_PUB.get_messages
2088: P_CALLED_MODE => p_called_mode,
2089: P_MODULE_NAME => l_module_name,
2090: P_LOG_LEVEL => l_log_level );
2091: END IF;
2092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2093: END;
2094:
2095:
2096: -- Step 1: Select rates and amounts from the appropriate cursor.
2274: P_MODULE_NAME => l_module_name,
2275: P_LOG_LEVEL => l_log_level );
2276: END IF;
2277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2278: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2279: END IF;
2280:
2281: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
2282:
2367: IF P_PA_DEBUG_MODE = 'Y' THEN
2368: PA_DEBUG.RESET_CURR_FUNCTION;
2369: END IF;
2370: EXCEPTION
2371: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2372:
2373: l_msg_count := FND_MSG_PUB.count_msg;
2374: IF l_msg_count = 1 THEN
2375: PA_INTERFACE_UTILS_PUB.get_messages