APPS.IGW_PROP_CHECKLIST_PVT dependencies on IGW_PROP_CHECKLIST

Line 1: PACKAGE BODY IGW_PROP_CHECKLIST_PVT as

1: PACKAGE BODY IGW_PROP_CHECKLIST_PVT as
2: /* $Header: igwvpchb.pls 115.7 2002/11/14 18:52:13 vmedikon ship $*/
3:
4:
5: Procedure update_prop_checklist (

Line 76: igw_prop_checklist_tbh.update_row (

72:
73: check_errors;
74:
75: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
76: igw_prop_checklist_tbh.update_row (
77: x_rowid => x_rowid
78: ,P_PROPOSAL_ID => P_PROPOSAL_ID
79: ,P_DOCUMENT_TYPE_CODE => P_DOCUMENT_TYPE_CODE
80: ,P_CHECKLIST_ORDER => P_CHECKLIST_ORDER

Line 121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',

117: END IF;
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120:
121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
122: p_procedure_name => 'UPDATE_PROP_CHECKLIST',
123: p_error_text => SUBSTRB(SQLERRM,1,240));
124:
125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 141: from igw_prop_checklist

137: l_proposal_id number;
138: BEGIN
139: select proposal_id
140: into l_proposal_id
141: from igw_prop_checklist
142: where rowid = x_rowid
143: and record_version_number = p_record_version_number;
144:
145: EXCEPTION

Line 154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',

150: raise fnd_api.g_exc_error;
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
155: p_procedure_name => 'CHECK_LOCK',
156: p_error_text => SUBSTRB(SQLERRM,1,240));
157: raise fnd_api.g_exc_unexpected_error;
158:

Line 177: insert into igw_prop_checklist (

173: P_PROPOSAL_ID IN NUMBER,
174: x_return_status OUT NOCOPY VARCHAR2) is
175:
176: BEGIN
177: insert into igw_prop_checklist (
178: proposal_id,
179: document_type_code,
180: checklist_order,
181: complete,

Line 220: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',

216: WHEN OTHERS THEN
217:
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219:
220: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_CHECKLIST_PVT',
221: p_procedure_name => 'POPULATE_CHECKLIST',
222: p_error_text => SUBSTRB(SQLERRM,1,240));
223:
224: END POPULATE_CHECKLIST;

Line 246: END IGW_PROP_CHECKLIST_PVT;

242: l_full_name := null;
243: return l_full_name;
244: END GET_PERSON_NAME_FROM_USER_ID;
245:
246: END IGW_PROP_CHECKLIST_PVT;