DBA Data[Home] [Help]

APPS.FUN_NET_BATCHES_PKG dependencies on FUN_NET_UTIL

Line 62: fun_net_util.Log_String(g_proc_level,l_path,'Before inserting into fun_net_batches_all');

58: l_path VARCHAR2(100);
59: BEGIN
60:
61: l_path := g_path||'Insert_Row';
62: fun_net_util.Log_String(g_proc_level,l_path,'Before inserting into fun_net_batches_all');
63:
64: IF x_batch_id IS NULL THEN
65: SELECT fun_net_batches_s.NEXTVAL INTO l_batch_id FROM DUAL;
66: x_batch_id := l_batch_id;

Line 70: fun_net_util.Log_String(g_state_level,l_path,'batch_id:'||l_batch_id);

66: x_batch_id := l_batch_id;
67: ELSE
68: l_batch_id := x_batch_id;
69: END IF;
70: fun_net_util.Log_String(g_state_level,l_path,'batch_id:'||l_batch_id);
71:
72: IF x_batch_number IS NULL THEN
73: l_batch_number := l_batch_id;
74: ELSE

Line 168: fun_net_util.Log_String(g_excep_level,l_path,'Could not insert batch record');

164: NVL(FND_GLOBAL.user_id,-1)
165: );
166:
167: IF SQL%NOTFOUND THEN
168: fun_net_util.Log_String(g_excep_level,l_path,'Could not insert batch record');
169: RAISE NO_DATA_FOUND;
170: END IF;
171: fun_net_util.Log_String(g_proc_level,l_path,'Successfully inserted batch record');
172: END Insert_Row;

Line 171: fun_net_util.Log_String(g_proc_level,l_path,'Successfully inserted batch record');

167: IF SQL%NOTFOUND THEN
168: fun_net_util.Log_String(g_excep_level,l_path,'Could not insert batch record');
169: RAISE NO_DATA_FOUND;
170: END IF;
171: fun_net_util.Log_String(g_proc_level,l_path,'Successfully inserted batch record');
172: END Insert_Row;
173:
174:
175: PROCEDURE Update_Row (

Line 218: fun_net_util.Log_String(g_proc_level,l_path,'Before updating fun_net_batches_all');

214:
215: l_path VARCHAR2(100);
216: BEGIN
217: l_path := g_path||'Update_Row';
218: fun_net_util.Log_String(g_proc_level,l_path,'Before updating fun_net_batches_all');
219:
220: UPDATE FUN_NET_BATCHES_ALL SET
221: batch_id = x_batch_id,
222: object_version_number = x_object_version_number,

Line 264: fun_net_util.Log_String(g_excep_level,l_path,'Could not update record for batch_id:'||x_batch_id);

260: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
261: WHERE batch_id = x_batch_id;
262:
263: IF ( SQL%NOTFOUND ) THEN
264: fun_net_util.Log_String(g_excep_level,l_path,'Could not update record for batch_id:'||x_batch_id);
265: RAISE NO_DATA_FOUND;
266: END IF;
267: fun_net_util.Log_String(g_proc_level,l_path,'Successfully updated batch record');
268: END Update_Row;

Line 267: fun_net_util.Log_String(g_proc_level,l_path,'Successfully updated batch record');

263: IF ( SQL%NOTFOUND ) THEN
264: fun_net_util.Log_String(g_excep_level,l_path,'Could not update record for batch_id:'||x_batch_id);
265: RAISE NO_DATA_FOUND;
266: END IF;
267: fun_net_util.Log_String(g_proc_level,l_path,'Successfully updated batch record');
268: END Update_Row;
269:
270:
271: PROCEDURE Update_Row (