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_PT_CO_IMPL_STATUSES_PKG dependencies on FND_API

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: IS
21:
22: BEGIN
23:
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25:
26: INSERT
27: INTO PA_PT_CO_IMPL_STATUSES (
28: pt_co_impl_statuses_id,

Line 57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

53: RETURNING ROWID INTO x_row_id;
54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: x_msg_count := 1;
59: x_msg_data := SQLERRM;
60: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
61: 'PA_PT_CO_IMPL_STATUSES_PKG',

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: x_msg_data := SQLERRM;
60: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
61: 'PA_PT_CO_IMPL_STATUSES_PKG',
62: p_procedure_name => 'INSERT_ROW');
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64:
65: END Insert_Row;
66:
67: /*==================================================================

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: l_msg_data VARCHAR2(2000);
94:
95: BEGIN
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
100:
101: IF l_debug_mode = 'Y' THEN

Line 138: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

134: x_return_status => l_return_status,
135: x_msg_count => l_msg_count,
136: x_msg_data => l_msg_data);
137:
138: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
139: IF l_debug_mode = 'Y' THEN
140: pa_debug.g_err_stage:= 'Error in Lock_Row';
141: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
142: END IF;

Line 155: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,

151: END IF;
152:
153: UPDATE PA_PT_CO_IMPL_STATUSES
154: SET
155: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
156: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
157: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
158: NVL(p_fin_plan_type_id, fin_plan_type_id)),
159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,

Line 157: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,

153: UPDATE PA_PT_CO_IMPL_STATUSES
154: SET
155: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
156: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
157: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
158: NVL(p_fin_plan_type_id, fin_plan_type_id)),
159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
160: NVL(p_ci_type_id, ci_type_id)),
161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,

Line 159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,

155: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
156: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
157: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
158: NVL(p_fin_plan_type_id, fin_plan_type_id)),
159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
160: NVL(p_ci_type_id, ci_type_id)),
161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
162: NVL(p_version_type, version_type)),
163: status_code = DECODE (p_status_code, FND_API.G_MISS_NUM, NULL,

Line 161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,

157: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
158: NVL(p_fin_plan_type_id, fin_plan_type_id)),
159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
160: NVL(p_ci_type_id, ci_type_id)),
161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
162: NVL(p_version_type, version_type)),
163: status_code = DECODE (p_status_code, FND_API.G_MISS_NUM, NULL,
164: NVL(p_status_code, status_code)),
165: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,

Line 163: status_code = DECODE (p_status_code, FND_API.G_MISS_NUM, NULL,

159: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
160: NVL(p_ci_type_id, ci_type_id)),
161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
162: NVL(p_version_type, version_type)),
163: status_code = DECODE (p_status_code, FND_API.G_MISS_NUM, NULL,
164: NVL(p_status_code, status_code)),
165: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,
166: NVL(p_impl_default_flag, impl_default_flag)),
167: record_version_number = p_record_version_number + 1,

Line 165: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,

161: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
162: NVL(p_version_type, version_type)),
163: status_code = DECODE (p_status_code, FND_API.G_MISS_NUM, NULL,
164: NVL(p_status_code, status_code)),
165: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,
166: NVL(p_impl_default_flag, impl_default_flag)),
167: record_version_number = p_record_version_number + 1,
168: last_update_date = SYSDATE,
169: last_updated_by = FND_GLOBAL.USER_ID,

Line 193: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

189: x_return_status => l_return_status,
190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data);
192:
193: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
194: IF l_debug_mode = 'Y' THEN
195: pa_debug.g_err_stage:= 'Error in Lock_Row';
196: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
197: END IF;

Line 210: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,

206: END IF;
207:
208: UPDATE PA_PT_CO_IMPL_STATUSES
209: SET
210: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
211: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
212: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
213: NVL(p_fin_plan_type_id, fin_plan_type_id)),
214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,

Line 212: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,

208: UPDATE PA_PT_CO_IMPL_STATUSES
209: SET
210: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
211: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
212: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
213: NVL(p_fin_plan_type_id, fin_plan_type_id)),
214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
215: NVL(p_ci_type_id, ci_type_id)),
216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,

Line 214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,

210: pt_co_impl_statuses_id = DECODE (p_pt_co_impl_statuses_id, FND_API.G_MISS_NUM,
211: NULL, NVL(p_pt_co_impl_statuses_id, pt_co_impl_statuses_id)),
212: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
213: NVL(p_fin_plan_type_id, fin_plan_type_id)),
214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
215: NVL(p_ci_type_id, ci_type_id)),
216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
217: NVL(p_version_type, version_type)),
218: status_code = DECODE (p_status_code, FND_API.G_MISS_CHAR, NULL,

Line 216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,

212: fin_plan_type_id = DECODE (p_fin_plan_type_id, FND_API.G_MISS_NUM, NULL,
213: NVL(p_fin_plan_type_id, fin_plan_type_id)),
214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
215: NVL(p_ci_type_id, ci_type_id)),
216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
217: NVL(p_version_type, version_type)),
218: status_code = DECODE (p_status_code, FND_API.G_MISS_CHAR, NULL,
219: NVL(p_status_code, status_code)),
220: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,

Line 218: status_code = DECODE (p_status_code, FND_API.G_MISS_CHAR, NULL,

214: ci_type_id = DECODE (p_ci_type_id, FND_API.G_MISS_NUM, NULL,
215: NVL(p_ci_type_id, ci_type_id)),
216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
217: NVL(p_version_type, version_type)),
218: status_code = DECODE (p_status_code, FND_API.G_MISS_CHAR, NULL,
219: NVL(p_status_code, status_code)),
220: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,
221: NVL(p_impl_default_flag, impl_default_flag)),
222: record_version_number = nvl(p_record_version_number,record_version_number) + 1,

Line 220: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,

216: version_type = DECODE (p_version_type, FND_API.G_MISS_CHAR, NULL,
217: NVL(p_version_type, version_type)),
218: status_code = DECODE (p_status_code, FND_API.G_MISS_CHAR, NULL,
219: NVL(p_status_code, status_code)),
220: impl_default_flag = DECODE (p_impl_default_flag, FND_API.G_MISS_CHAR, NULL,
221: NVL(p_impl_default_flag, impl_default_flag)),
222: record_version_number = nvl(p_record_version_number,record_version_number) + 1,
223: last_update_login = FND_GLOBAL.LOGIN_ID,
224: last_updated_by = FND_GLOBAL.USER_ID,

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234:
235: IF SQL%NOTFOUND THEN
236: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
237: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: END IF;
240:
241: IF l_debug_mode = 'Y' THEN
242: pa_debug.reset_curr_function;

Line 250: (p_encoded => FND_API.G_TRUE,

246:
247: IF l_msg_count > 0 THEN
248: IF l_msg_count = 1 THEN
249: PA_INTERFACE_UTILS_PUB.get_messages
250: (p_encoded => FND_API.G_TRUE,
251: p_msg_index => 1,
252: p_msg_count => l_msg_count,
253: p_msg_data => l_msg_data,
254: p_data => l_data,

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: END IF;
269:
270: EXCEPTION
271: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273:
274: IF l_debug_mode = 'Y' THEN
275: pa_debug.reset_curr_function;
276: END IF;

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG' ,
279: p_procedure_name => 'Update_Row');
280:
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: x_msg_count := 1;
284: x_msg_data := SQLERRM;
285: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
286: p_procedure_name => 'Update_Row');

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: x_msg_count := 1;
284: x_msg_data := SQLERRM;
285: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
286: p_procedure_name => 'Update_Row');
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288:
289: END UPDATE_ROW;
290:
291: /*==================================================================

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: l_data VARCHAR2(2000);
313: l_msg_data VARCHAR2(2000);
314: BEGIN
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: IF p_pt_co_impl_statuses_id IS NOT NULL THEN
319: IF p_lock_row = 'Y' THEN
320: /* Calling Lock_Row */

Line 338: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

334: x_return_status => l_return_status,
335: x_msg_count => l_msg_count,
336: x_msg_data => l_msg_data);
337:
338: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
339: IF l_debug_mode = 'Y' THEN
340: pa_debug.g_err_stage:= 'Error in Lock_Row';
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
342: END IF;

Line 383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

379: x_return_status => l_return_status,
380: x_msg_count => l_msg_count,
381: x_msg_data => l_msg_data);
382:
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: IF l_debug_mode = 'Y' THEN
385: pa_debug.g_err_stage:= 'Error in Lock_Row';
386: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
387: END IF;

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413:
414: IF (SQL%NOTFOUND) THEN
415: PA_UTILS.Add_Message ( p_app_short_name => 'PA',
416: p_msg_name => 'PA_XC_RECORD_CHANGED');
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: END IF;
419:
420: EXCEPTION
421: WHEN OTHERS THEN

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: END IF;
419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: x_msg_count := 1;
424: x_msg_data := SQLERRM;
425: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
426: p_procedure_name => 'DELETE_ROW');

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: x_msg_count := 1;
424: x_msg_data := SQLERRM;
425: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
426: p_procedure_name => 'DELETE_ROW');
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428:
429: END DELETE_ROW;
430:
431: /*==================================================================

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464:
465: l_row_id_rec lock_rows_crs%ROWTYPE;
466:
467: BEGIN
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469:
470: IF p_pt_co_impl_statuses_id IS NOT NULL THEN
471: IF l_debug_mode = 'Y' THEN
472: pa_debug.g_err_stage:= 'Lockin Row when p_pt_co_impl_statuses_id is not null';

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: END IF;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: x_msg_count := 1;
511: x_msg_data := SQLERRM;
512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
513: p_procedure_name => 'LOCK_ROW');

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: x_msg_count := 1;
511: x_msg_data := SQLERRM;
512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PT_CO_IMPL_STATUSES_PKG',
513: p_procedure_name => 'LOCK_ROW');
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515:
516: END Lock_Row;
517:
518: END PA_PT_CO_IMPL_STATUSES_PKG;