DBA Data[Home] [Help]

APPS.IEX_PARTY_PREF_PUB dependencies on IEX_PARTY_PREF_PUB

Line 1: PACKAGE BODY IEX_PARTY_PREF_PUB AS

1: PACKAGE BODY IEX_PARTY_PREF_PUB AS
2: /* $Header: iexphppb.pls 120.0.12010000.9 2009/08/12 15:05:10 ehuh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PARTY_PREF_PUB';
5: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PARTY_PREF_PUB';

1: PACKAGE BODY IEX_PARTY_PREF_PUB AS
2: /* $Header: iexphppb.pls 120.0.12010000.9 2009/08/12 15:05:10 ehuh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PARTY_PREF_PUB';
5: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
6:
7: PROCEDURE assign_collection_level
8: (

Line 66: SAVEPOINT IEX_PARTY_PREF_PUB_START;

62:
63:
64: BEGIN
65:
66: SAVEPOINT IEX_PARTY_PREF_PUB_START;
67:
68: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
69: p_api_version_number,
70: l_api_name,

Line 82: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Input Count = ' ||p_level_tbl.count);

78:
79: x_return_status := 'S';
80:
81:
82: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Input Count = ' ||p_level_tbl.count);
83:
84: j := 0;
85: k := 0;
86: m := 0;

Line 163: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - deleting - Exception = ' ||SQLERRM);

159: x_update_count := R_level_prefids.count;
160:
161: exception
162: when others then
163: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - deleting - Exception = ' ||SQLERRM);
164: x_return_status := 'E';
165: x_msg_data := SQLERRM||'Deleting Party preferences..';
166: x_update_count := 0;
167: RETURN;

Line 196: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Updating - Exception = ' ||SQLERRM);

192: x_update_count := U_level_tbl.count;
193:
194: exception
195: when others then
196: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Updating - Exception = ' ||SQLERRM);
197: x_return_status := 'E';
198: x_msg_data := SQLERRM||'Updating Party ';
199: x_update_count := 0;
200: RETURN;

Line 261: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Inserting - Exception = ' ||SQLERRM);

257: x_insert_count := I_level_tbl.count;
258:
259: exception
260: when others then
261: iex_debug_pub.logmessage (' IEX_PARTY_PREF_PUB.assign_collection_level - Inserting - Exception = ' ||SQLERRM);
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: x_msg_data := SQLERRM||'Inserting Party ';
264: x_insert_count := 0;
265: RETURN;

Line 274: END IEX_PARTY_PREF_PUB;

270: END IF;
271:
272: END assign_collection_level;
273:
274: END IEX_PARTY_PREF_PUB;