APPS.FUN_VENDORMERGE_GRP dependencies on FUN_NET_UTIL

Line 68: fun_net_util.Log_String(g_event_level,l_path,'Supplier Merge(+)');

64: g_user_id := fnd_global.user_id;
65: g_login_id := fnd_global.login_id;
66:
67: l_path := g_path||'Supplier Merge:';
68: fun_net_util.Log_String(g_event_level,l_path,'Supplier Merge(+)');
69:
70: -- **** Standard start of API savepoint ****
71:
72: SAVEPOINT Merge_Vendor_SP;

Line 89: /* fun_net_util.Log_String(g_event_level,

85: +-----------------------------------------------*/
86:
87: -- **** Check for mandatory parameters ****
88:
89: /* fun_net_util.Log_String(g_event_level,
90: l_path
91: ,'Check Mandatory Params(+)');
92:
93: Check_Mandatory_Parameters(

Line 96: fun_net_util.Log_String(g_event_level,

92:
93: Check_Mandatory_Parameters(
94: x_return_status => l_return_status);
95:
96: fun_net_util.Log_String(g_event_level,
97: l_path
98: ,'Return Status'|| l_return_status);
99:
100: fun_net_util.Log_String(g_event_level,

Line 100: fun_net_util.Log_String(g_event_level,

96: fun_net_util.Log_String(g_event_level,
97: l_path
98: ,'Return Status'|| l_return_status);
99:
100: fun_net_util.Log_String(g_event_level,
101: l_path,
102: 'Check Mandatory Params(-)');
103:
104: IF l_return_status = FND_API.G_FALSE THEN

Line 117: fun_net_util.Log_String(g_event_level,

113: -- with the higher priority of the two
114:
115: BEGIN
116:
117: fun_net_util.Log_String(g_event_level,
118: l_path
119: ,'Updating Netting Suppliers');
120:
121: UPDATE fun_net_suppliers_all s

Line 130: fun_net_util.Log_String(g_event_level

126: AND nvl(supplier_site_id, 0) =
127: decode(supplier_site_id, NULL,
128: 0, p_dup_vendor_site_id);
129:
130: fun_net_util.Log_String(g_event_level
131: ,l_path
132: ,'Rows Updated'|| sql%rowcount);
133:
134: UPDATE fun_net_suppliers_all s

Line 154: fun_net_util.Log_String(g_event_level,

150: null;
151:
152: WHEN OTHERS THEN
153:
154: fun_net_util.Log_String(g_event_level,
155: l_path
156: ,'sqlcode '||sqlcode||' sqlerrm ' || sqlerrm);
157: RAISE FND_API.G_EXC_ERROR;
158: END;

Line 164: fun_net_util.Log_String(g_event_level,

160: /* Delete the record that has the same agreement id, supplier priority , vendor and vendor site */
161:
162: BEGIN
163:
164: fun_net_util.Log_String(g_event_level,
165: l_path
166: ,'Deleting Records');
167:
168: DELETE FROM fun_net_suppliers_all s

Line 182: fun_net_util.Log_String(g_event_level,

178: supplier_site_id,
179: supplier_priority
180: HAVING COUNT(netting_supplier_id) > 1);
181:
182: fun_net_util.Log_String(g_event_level,
183: l_path
184: ,'Records Deleted' || sql%rowcount);
185:
186: fun_net_util.Log_String(g_event_level,

Line 186: fun_net_util.Log_String(g_event_level,

182: fun_net_util.Log_String(g_event_level,
183: l_path
184: ,'Records Deleted' || sql%rowcount);
185:
186: fun_net_util.Log_String(g_event_level,
187: l_path
188: ,'Supplier Merge (-)');
189: EXCEPTION
190: WHEN NO_DATA_FOUND THEN

Line 194: fun_net_util.Log_String

190: WHEN NO_DATA_FOUND THEN
191: null;
192: WHEN OTHERS THEN
193:
194: fun_net_util.Log_String
195: (g_event_level,
196: l_path
197: ,'sqlcode' || sqlcode || 'sqlerrm ' || sqlerrm);
198: