DBA Data[Home] [Help]

APPS.PA_RES_LIST_UPGRADE_PKG dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24:
25: BEGIN
26:
27: x_msg_count := 0;
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
30:
31: IF l_debug_mode = 'Y' THEN
32: pa_debug.set_curr_function( p_function => 'RES_LIST_PLAN_LIST_WHEN_NULL',

Line 54: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

50: x_return_status => x_return_status,
51: x_msg_count => x_msg_count,
52: x_msg_data => x_msg_data );
53:
54: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
55: IF l_debug_mode = 'Y' THEN
56: pa_debug.g_err_stage:='Error occured when processing the Resource List '||tbl_res_id_list_tbl(l_count);
57: pa_debug.write('Res_list_plan_list_when_null: ' || l_module_name,pa_debug.g_err_stage,5);
58: END IF;

Line 78: (p_encoded => FND_API.G_TRUE

74:
75: x_msg_count := FND_MSG_PUB.count_msg;
76: IF x_msg_count = 1 THEN
77: PA_INTERFACE_UTILS_PUB.get_messages
78: (p_encoded => FND_API.G_TRUE
79: ,p_msg_index => 1
80: ,p_msg_count => x_msg_count
81: ,p_msg_data => x_msg_data
82: ,p_data => l_data

Line 92: x_return_status := FND_API.G_RET_STS_ERROR;

88: ELSE
89:
90: x_msg_count := x_msg_count;
91: END IF;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: IF l_debug_mode = 'Y' THEN
94: pa_debug.reset_curr_function;
95: END IF;
96:

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96:
97:
98: WHEN OTHERS THEN
99:
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: x_msg_count := 1;
102: x_msg_data := SQLERRM;
103: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RES_LIST_UPGRADE_PKG'
104: ,p_procedure_name => 'RES_LIST_PLAN_LIST_WHEN_NULL');

Line 325: IF FND_API.TO_BOOLEAN( p_init_msg_list )

321: -- Bug 3802762, 30-JUN-2004, jwhite ------------------------------------
322: -- Added if/then test for p_init_msg_list
323:
324:
325: IF FND_API.TO_BOOLEAN( p_init_msg_list )
326: THEN
327:
328: FND_MSG_PUB.initialize;
329:

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331:
332: -- End Bug 3802762 -----------------------------------------------------
333:
334: x_msg_count := 0;
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: pa_debug.init_err_stack('PA_RES_LIST_UPGRADE_PKG.RES_LIST_TO_PLAN_RES_LIST');
337: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
338: l_debug_mode := NVL(l_debug_mode, 'Y');
339: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 983: IF FND_API.TO_BOOLEAN( p_commit )

979:
980: -- Bug 3802762, 30-JUN-2004, jwhite ------------------------------------
981: -- Added if/then test for p_commit.
982:
983: IF FND_API.TO_BOOLEAN( p_commit )
984: THEN
985: COMMIT;
986: END IF;
987:

Line 1007: (p_encoded => FND_API.G_TRUE

1003: WHEN null_res_format_id OR null_res_class_id OR null_res_class_code OR null_alias THEN
1004: l_msg_count := FND_MSG_PUB.count_msg;
1005: IF l_msg_count = 1 THEN
1006: PA_INTERFACE_UTILS_PUB.get_messages
1007: (p_encoded => FND_API.G_TRUE
1008: ,p_msg_index => 1
1009: ,p_msg_count => l_msg_count
1010: ,p_msg_data => l_msg_data
1011: ,p_data => l_data

Line 1024: x_return_status:= FND_API.G_RET_STS_ERROR;

1020: IF l_debug_mode = 'Y' THEN
1021: pa_debug.g_err_stage:= l_stage;
1022: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1023: END IF;
1024: x_return_status:= FND_API.G_RET_STS_ERROR;
1025: pa_debug.write_file('RES_LIST_TO_PLAN_RES_LIST: Upgrade has failed for the resource list '|| p_resource_list_id,5);
1026: pa_debug.write_file('RES_LIST_TO_PLAN_RES_LIST:: Failure Reason:'||x_msg_data,5);
1027: pa_debug.reset_err_stack;
1028: ROLLBACK to PA_RES_LIST_UPGRADE_PKG;

Line 1035: (p_encoded => FND_API.G_TRUE

1031: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc or RES_LIST_UPGRADED THEN
1032: l_msg_count := FND_MSG_PUB.count_msg;
1033: IF l_msg_count = 1 THEN
1034: PA_INTERFACE_UTILS_PUB.get_messages
1035: (p_encoded => FND_API.G_TRUE
1036: ,p_msg_index => 1
1037: ,p_msg_count => l_msg_count
1038: ,p_msg_data => l_msg_data
1039: ,p_data => l_data

Line 1052: x_return_status:= FND_API.G_RET_STS_ERROR;

1048: IF l_debug_mode = 'Y' THEN
1049: pa_debug.g_err_stage:='Invalid Arguments Passed';
1050: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1051: END IF;
1052: x_return_status:= FND_API.G_RET_STS_ERROR;
1053: pa_debug.write_file('RES_LIST_TO_PLAN_RES_LIST: Upgrade has failed for the resource list '|| p_resource_list_id,5);
1054: pa_debug.write_file('RES_LIST_TO_PLAN_RES_LIST:: Failure Reason:'||x_msg_data,5);
1055: pa_debug.reset_err_stack;
1056: ROLLBACK to PA_RES_LIST_UPGRADE_PKG;

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1087: if (chk_res_for_exists_csr%ISOPEN) then
1088: close chk_res_for_exists_csr;
1089: end if;
1090:
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: x_msg_count := 1;
1093: x_msg_data := SQLERRM;
1094:
1095: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_RES_LIST_UPGRADE_PKG',p_procedure_name => 'RES_LIST_TO_PLAN_RES_LIST');