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.IGW_PROP_NARRATIVES_PVT dependencies on IGW_PROP

Line 1: PACKAGE BODY IGW_PROP_NARRATIVES_PVT as

1: PACKAGE BODY IGW_PROP_NARRATIVES_PVT as
2: /* $Header: igwvprnb.pls 115.6 2002/11/15 00:38:17 ashkumar ship $*/
3: PROCEDURE create_prop_narrative (
4: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 61: igw_prop_narratives_tbh.insert_row(

57:
58: -- call table handler
59: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
60:
61: igw_prop_narratives_tbh.insert_row(
62: x_rowid => x_rowid
63: ,P_PROPOSAL_ID => P_PROPOSAL_ID
64: ,P_MODULE_TITLE => P_MODULE_TITLE
65: ,P_MODULE_STATUS => P_MODULE_STATUS

Line 72: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);

68: ,P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
69: ,P_COMMENTS => P_COMMENTS
70: ,p_mode => 'R'
71: ,x_return_status => x_return_status);
72: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
73: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
74:
75: end if;
76:

Line 73: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);

69: ,P_COMMENTS => P_COMMENTS
70: ,p_mode => 'R'
71: ,x_return_status => x_return_status);
72: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
73: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
74:
75: end if;
76:
77: check_errors;

Line 108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
109: p_procedure_name => 'CREATE_PROP_NARRATIVE',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 183: igw_prop_narratives_tbh.update_row (

179:
180: -------------------------------------------- validations -----------------------------------------------------
181:
182: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
183: igw_prop_narratives_tbh.update_row (
184: x_rowid => x_rowid
185: ,P_PROPOSAL_ID => P_PROPOSAL_ID
186: ,P_MODULE_ID => P_MODULE_ID
187: ,P_MODULE_TITLE => P_MODULE_TITLE

Line 196: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);

192: ,P_COMMENTS => P_COMMENTS
193: ,p_mode => 'R'
194: ,p_record_version_number => p_record_version_number
195: ,x_return_status => x_return_status);
196: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
197: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
198:
199: end if;
200:

Line 197: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);

193: ,p_mode => 'R'
194: ,p_record_version_number => p_record_version_number
195: ,x_return_status => x_return_status);
196: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
197: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
198:
199: end if;
200:
201: check_errors;

Line 233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

229: END IF;
230:
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232:
233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
234: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
235: p_error_text => SUBSTRB(SQLERRM,1,240));
236:
237: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 300: select module_id into l_module_id from igw_prop_narratives where rowid = x_rowid;

296:
297:
298: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
299:
300: select module_id into l_module_id from igw_prop_narratives where rowid = x_rowid;
301:
302: igw_prop_narratives_tbh.delete_row(
303: x_rowid => x_rowid,
304: p_record_version_number => p_record_version_number,

Line 302: igw_prop_narratives_tbh.delete_row(

298: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
299:
300: select module_id into l_module_id from igw_prop_narratives where rowid = x_rowid;
301:
302: igw_prop_narratives_tbh.delete_row(
303: x_rowid => x_rowid,
304: p_record_version_number => p_record_version_number,
305: x_return_status => x_return_status);
306:

Line 308: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS('IGW_PROP_NARRATIVES',

304: p_record_version_number => p_record_version_number,
305: x_return_status => x_return_status);
306:
307:
308: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS('IGW_PROP_NARRATIVES',
309: p_proposal_id, l_module_id);
310:
311: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
312: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);

Line 311: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);

307:
308: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS('IGW_PROP_NARRATIVES',
309: p_proposal_id, l_module_id);
310:
311: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
312: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
313: end if;
314:
315:

Line 312: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);

308: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS('IGW_PROP_NARRATIVES',
309: p_proposal_id, l_module_id);
310:
311: STATUS_OF_NARRATIVES := IGW_PROP.GET_NARRATIVE_STATUS (P_PROPOSAL_ID);
312: IGW_PROP.SET_COMPONENT_STATUS ('NARRATIVE', P_PROPOSAL_ID, STATUS_OF_NARRATIVES);
313: end if;
314:
315:
316: check_errors;

Line 347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

343: END IF;
344:
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346:
347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
348: p_procedure_name => 'DELETE_PROP_NARRATIVE',
349: p_error_text => SUBSTRB(SQLERRM,1,240));
350:
351: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 404: UPDATE IGW_PROPOSALS_ALL

400: -------------------------------------------- validations -----------------------------------------------------
401:
402: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
403:
404: UPDATE IGW_PROPOSALS_ALL
405: SET NARRATIVE_TYPE_CODE = P_NARRATIVE_TYPE_CODE,
406: NARRATIVE_SUBMISSION_CODE = P_NARRATIVE_SUBMISSION_CODE
407: WHERE PROPOSAL_ID = P_PROPOSAL_ID;
408:

Line 444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

440: END IF;
441:
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443:
444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
445: p_procedure_name => 'UPDATE_PROP_NARRATIVE',
446: p_error_text => SUBSTRB(SQLERRM,1,240));
447:
448: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 463: from igw_prop_narratives

459: l_proposal_id number;
460: BEGIN
461: select proposal_id
462: into l_proposal_id
463: from igw_prop_narratives
464: where rowid = x_rowid
465: and record_version_number = p_record_version_number;
466:
467: EXCEPTION

Line 476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

472: raise fnd_api.g_exc_error;
473:
474: WHEN OTHERS THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
477: p_procedure_name => 'CHECK_LOCK',
478: p_error_text => SUBSTRB(SQLERRM,1,240));
479: raise fnd_api.g_exc_unexpected_error;
480:

Line 516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',

512: EXCEPTION
513:
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_PVT',
517: p_procedure_name => 'VALIDATE_LOGGED_USER_RIGHTS',
518: p_error_text => SUBSTRB(SQLERRM,1,240));
519: raise fnd_api.g_exc_unexpected_error;
520: END VALIDATE_LOGGED_USER_RIGHTS;

Line 523: END IGW_PROP_NARRATIVES_PVT;

519: raise fnd_api.g_exc_unexpected_error;
520: END VALIDATE_LOGGED_USER_RIGHTS;
521:
522:
523: END IGW_PROP_NARRATIVES_PVT;