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.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_OAM_DEBUG

Line 66: fnd_oam_debug.log(6, l_ctxt, 'ARG ID('||p_arg.arg_id||'), unknown datatype: '||p_arg.datatype);

62: --for some reason, this is refusing to throw an exception on invalid values
63: l_rowid := CHARTOROWID(p_canonical_value);
64: ELSE
65: --unknown datatype
66: fnd_oam_debug.log(6, l_ctxt, 'ARG ID('||p_arg.arg_id||'), unknown datatype: '||p_arg.datatype);
67: RAISE NO_DATA_FOUND;
68: END CASE;
69: END;
70:

Line 175: fnd_oam_debug.log(6, l_ctxt, 'Argument ID: ('||p_arg_id||'), Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

171:
172: RETURN TRUE;
173: EXCEPTION
174: WHEN OTHERS THEN
175: fnd_oam_debug.log(6, l_ctxt, 'Argument ID: ('||p_arg_id||'), Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
176: RETURN FALSE;
177: END;
178:
179: -- Private: similar to other add_arg_to_list but in this case we've already created an arg object

Line 194: fnd_oam_debug.log(6, l_ctxt, 'Argument ID: ('||p_arg.arg_id||'), Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

190:
191: RETURN TRUE;
192: EXCEPTION
193: WHEN OTHERS THEN
194: fnd_oam_debug.log(6, l_ctxt, 'Argument ID: ('||p_arg.arg_id||'), Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
195: RETURN FALSE;
196: END;
197:
198: -- Private helper to get_canonical_value to fetch the value for a given state key

Line 212: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

208: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_CANONICAL_VALUE_FOR_KEY';
209:
210: l_canonical_value VARCHAR2(4000);
211: BEGIN
212: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: x_return_msg := '';
215:
216: --do a big case statement on the state key to fetch the value

Line 281: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,
278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));
279: ELSE
280: x_return_msg := 'ARG ID('||px_arg.arg_id||'), invalid state key: '||p_state_key;
281: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
282: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
283: RETURN;
284: END CASE;
285:

Line 282: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));
279: ELSE
280: x_return_msg := 'ARG ID('||px_arg.arg_id||'), invalid state key: '||p_state_key;
281: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
282: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
283: RETURN;
284: END CASE;
285:
286: --success

Line 289: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

285:
286: --success
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: x_canonical_value := l_canonical_value;
289: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: -- since we involve no sql, this should only happen when there's missing state
293: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_STATE;

Line 294: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing state.');

290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: -- since we involve no sql, this should only happen when there's missing state
293: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_STATE;
294: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing state.');
295: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
296: RETURN;
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 295: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

291: WHEN NO_DATA_FOUND THEN
292: -- since we involve no sql, this should only happen when there's missing state
293: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_STATE;
294: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing state.');
295: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
296: RETURN;
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 300: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

296: RETURN;
297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
300: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
301: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
302: RETURN;
303: END;
304:

Line 301: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

297: WHEN OTHERS THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
300: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
301: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
302: RETURN;
303: END;
304:
305: -- Private helper to get_canonical_value to fetch the value from the execution cursor. Since binds

Line 324: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

320: l_date DATE := NULL;
321: l_bool BOOLEAN := NULL;
322: l_rowid ROWID := NULL;
323: BEGIN
324: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: x_return_msg := '';
327:
328: --fetch the value into the properly typed local variable then then

Line 355: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

351: l_rowid);
352: x_canonical_value := ROWIDTOCHAR(l_rowid);
353: ELSE
354: x_return_msg := 'Arg ('||px_arg.arg_id||') has unknown datatype:'||px_arg.datatype;
355: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
357: RETURN;
358: END CASE;
359:

Line 356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

352: x_canonical_value := ROWIDTOCHAR(l_rowid);
353: ELSE
354: x_return_msg := 'Arg ('||px_arg.arg_id||') has unknown datatype:'||px_arg.datatype;
355: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
357: RETURN;
358: END CASE;
359:
360: fnd_oam_debug.log(1, l_ctxt, 'Found canonical value: '||x_canonical_value);

Line 360: fnd_oam_debug.log(1, l_ctxt, 'Found canonical value: '||x_canonical_value);

356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
357: RETURN;
358: END CASE;
359:
360: fnd_oam_debug.log(1, l_ctxt, 'Found canonical value: '||x_canonical_value);
361:
362: --success
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

360: fnd_oam_debug.log(1, l_ctxt, 'Found canonical value: '||x_canonical_value);
361:
362: --success
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
365: EXCEPTION
366: WHEN BIND_DOES_NOT_EXIST THEN
367: --catch a common error and provide better feedback.
368: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||px_arg.arg_id||'), Bindvar('||l_bindvar_name||') does not exist');

Line 368: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||px_arg.arg_id||'), Bindvar('||l_bindvar_name||') does not exist');

364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
365: EXCEPTION
366: WHEN BIND_DOES_NOT_EXIST THEN
367: --catch a common error and provide better feedback.
368: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||px_arg.arg_id||'), Bindvar('||l_bindvar_name||') does not exist');
369: x_return_msg := 'Variable Value failure: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
370: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
371: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
372: RETURN;

Line 370: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

366: WHEN BIND_DOES_NOT_EXIST THEN
367: --catch a common error and provide better feedback.
368: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||px_arg.arg_id||'), Bindvar('||l_bindvar_name||') does not exist');
369: x_return_msg := 'Variable Value failure: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
370: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
371: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
372: RETURN;
373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 371: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

367: --catch a common error and provide better feedback.
368: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||px_arg.arg_id||'), Bindvar('||l_bindvar_name||') does not exist');
369: x_return_msg := 'Variable Value failure: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
370: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
371: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
372: RETURN;
373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 376: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

372: RETURN;
373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
376: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
377: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
378: RETURN;
379: END;
380:

Line 377: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
376: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
377: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
378: RETURN;
379: END;
380:
381: --Private, utility procedure for GET_CANONICAL_ARG_VALUE to execute a source sql using dynamic sql or the source_cursor and return the value as

Line 403: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

399: l_number NUMBER;
400: l_date DATE;
401: l_rowid ROWID;
402: BEGIN
403: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: x_return_msg := '';
406:
407: --fetch the canonical value differently based on what SQL is available to us

Line 414: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

410: --we don't support binding the rowids when using a manual sql stmt since it won't bind properly
411: --with user specified binds. Statements using binds should use the source_cursor.
412: IF px_arg.source_sql_bind_rowids THEN
413: x_return_msg := 'Cannot have a non-null final sql stmt when binding rowids. This should not happen.';
414: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
415: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
416: RETURN;
417: END IF;
418:

Line 415: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

411: --with user specified binds. Statements using binds should use the source_cursor.
412: IF px_arg.source_sql_bind_rowids THEN
413: x_return_msg := 'Cannot have a non-null final sql stmt when binding rowids. This should not happen.';
414: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
415: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
416: RETURN;
417: END IF;
418:
419: --different statements depending on datatype

Line 434: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

430: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_rowid;
431: l_canonical_value := ROWIDTOCHAR(l_rowid);
432: ELSE
433: x_return_msg := 'Arg ID('||px_arg.arg_id||'), invalid datatype: '||px_arg.datatype;
434: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
435: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
436: RETURN;
437: END CASE;
438: ELSIF px_arg.source_cursor_id IS NOT NULL THEN

Line 435: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

431: l_canonical_value := ROWIDTOCHAR(l_rowid);
432: ELSE
433: x_return_msg := 'Arg ID('||px_arg.arg_id||'), invalid datatype: '||px_arg.datatype;
434: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
435: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
436: RETURN;
437: END CASE;
438: ELSIF px_arg.source_cursor_id IS NOT NULL THEN
439: IF NOT DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN

Line 441: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

437: END CASE;
438: ELSIF px_arg.source_cursor_id IS NOT NULL THEN
439: IF NOT DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN
440: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), source cursor is already closed. This should not happen.';
441: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
442: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
443: RETURN;
444: END IF;
445:

Line 442: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

438: ELSIF px_arg.source_cursor_id IS NOT NULL THEN
439: IF NOT DBMS_SQL.IS_OPEN(px_arg.source_cursor_id) THEN
440: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), source cursor is already closed. This should not happen.';
441: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
442: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
443: RETURN;
444: END IF;
445:
446: --bind if we have to

Line 448: fnd_oam_debug.log(1, l_ctxt, 'Binding Rowids');

444: END IF;
445:
446: --bind if we have to
447: IF px_arg.source_sql_bind_rowids THEN
448: fnd_oam_debug.log(1, l_ctxt, 'Binding Rowids');
449: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,
450: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
451: p_rowid_lbound);
452: DBMS_SQL.BIND_VARIABLE(px_arg.source_cursor_id,

Line 458: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');

454: p_rowid_ubound);
455: END IF;
456:
457: --now execute and fetch
458: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
459: l_rows_fetched := DBMS_SQL.EXECUTE_AND_FETCH(px_arg.source_cursor_id);
460: fnd_oam_debug.log(1, l_ctxt, '...Done');
461:
462: IF l_rows_fetched <> 1 THEN

Line 460: fnd_oam_debug.log(1, l_ctxt, '...Done');

456:
457: --now execute and fetch
458: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
459: l_rows_fetched := DBMS_SQL.EXECUTE_AND_FETCH(px_arg.source_cursor_id);
460: fnd_oam_debug.log(1, l_ctxt, '...Done');
461:
462: IF l_rows_fetched <> 1 THEN
463: x_return_msg := 'Fetched '||l_rows_fetched||' rows. Args must return 1 row.';
464: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 464: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

460: fnd_oam_debug.log(1, l_ctxt, '...Done');
461:
462: IF l_rows_fetched <> 1 THEN
463: x_return_msg := 'Fetched '||l_rows_fetched||' rows. Args must return 1 row.';
464: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
465: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
466: RETURN;
467: END IF;
468:

Line 465: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

461:
462: IF l_rows_fetched <> 1 THEN
463: x_return_msg := 'Fetched '||l_rows_fetched||' rows. Args must return 1 row.';
464: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
465: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
466: RETURN;
467: END IF;
468:
469: --now depending on the datatype, set our local canonical value

Line 492: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

488: l_rowid);
489: l_canonical_value := ROWIDTOCHAR(l_rowid);
490: ELSE
491: x_return_msg := 'Arg ID('||px_arg.arg_id||'), invalid datatype: '||px_arg.datatype;
492: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
493: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
494: RETURN;
495: END CASE;
496: ELSE

Line 493: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

489: l_canonical_value := ROWIDTOCHAR(l_rowid);
490: ELSE
491: x_return_msg := 'Arg ID('||px_arg.arg_id||'), invalid datatype: '||px_arg.datatype;
492: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
493: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
494: RETURN;
495: END CASE;
496: ELSE
497: x_return_msg := 'Source Cursor is NULL and Source Final SQL Stmt is NULL, no SQL to fetch.';

Line 498: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

494: RETURN;
495: END CASE;
496: ELSE
497: x_return_msg := 'Source Cursor is NULL and Source Final SQL Stmt is NULL, no SQL to fetch.';
498: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
499: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
500: RETURN;
501: END IF;
502:

Line 499: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

495: END CASE;
496: ELSE
497: x_return_msg := 'Source Cursor is NULL and Source Final SQL Stmt is NULL, no SQL to fetch.';
498: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
499: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
500: RETURN;
501: END IF;
502:
503: --success

Line 506: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

502:
503: --success
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505: x_canonical_value := l_canonical_value;
506: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
507: EXCEPTION
508: WHEN missing_binds THEN
509: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_BINDS;
510: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing binds.');

Line 510: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing binds.');

506: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
507: EXCEPTION
508: WHEN missing_binds THEN
509: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_BINDS;
510: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing binds.');
511: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
512: RETURN;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 511: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

507: EXCEPTION
508: WHEN missing_binds THEN
509: x_return_status := FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_BINDS;
510: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||px_arg.arg_id||'), threw missing binds.');
511: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
512: RETURN;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 516: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

512: RETURN;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
516: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
517: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
518: RETURN;
519: END;
520:

Line 517: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
516: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
517: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
518: RETURN;
519: END;
520:
521: --Private, helper to INITIALIZE_ARG to sync up the arg's state with values INIT found. Primary responsibilities

Line 544: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

540:
541: l_return_status VARCHAR2(6);
542: l_return_msg VARCHAR2(2048);
543: BEGIN
544: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: x_return_msg := '';
547:
548: --SET DERIVED ATTRIBUTES

Line 571: fnd_oam_debug.log(1, l_ctxt, 'ARG ID ('||px_arg.arg_id||'), failed to set the canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

567: SET_STATE_ARG_VALUE(px_arg,
568: p_canonical_value);
569: EXCEPTION
570: WHEN OTHERS THEN
571: fnd_oam_debug.log(1, l_ctxt, 'ARG ID ('||px_arg.arg_id||'), failed to set the canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
572: --if it didn't set properly, store that after the init to keep other threads from doing it
573: px_arg.valid_value_flag := FND_API.G_FALSE;
574: END;
575: ELSIF px_arg.is_constant AND px_arg.valid_value_flag IS NULL THEN

Line 589: fnd_oam_debug.log(1, l_ctxt, 'Found initialized_success_flag was false after sync but before any sql actions.');

585: --Before doing further init, if we've already failed the init then return because we've updated enough state
586: IF px_arg.initialized_success_flag = FND_API.G_FALSE THEN
587: px_arg.init_locally := TRUE;
588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589: fnd_oam_debug.log(1, l_ctxt, 'Found initialized_success_flag was false after sync but before any sql actions.');
590: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
591: RETURN;
592: END IF;
593:

Line 590: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

586: IF px_arg.initialized_success_flag = FND_API.G_FALSE THEN
587: px_arg.init_locally := TRUE;
588: x_return_status := FND_API.G_RET_STS_SUCCESS;
589: fnd_oam_debug.log(1, l_ctxt, 'Found initialized_success_flag was false after sync but before any sql actions.');
590: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
591: RETURN;
592: END IF;
593:
594: --Since constants are rather common and they dont change, go ahead and validate the value and

Line 633: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

629: DBMS_SQL.NATIVE);
630: EXCEPTION
631: WHEN OTHERS THEN
632: x_return_msg := 'ARG_ID ('||px_arg.arg_id||'), failed to parse source final text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
633: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
634: px_arg.init_locally := TRUE;
635: fnd_oam_debug.log(1, l_ctxt, 'Source Final Text: "'||p_source_final_text||'"');
636: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
637: RETURN;

Line 635: fnd_oam_debug.log(1, l_ctxt, 'Source Final Text: "'||p_source_final_text||'"');

631: WHEN OTHERS THEN
632: x_return_msg := 'ARG_ID ('||px_arg.arg_id||'), failed to parse source final text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
633: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
634: px_arg.init_locally := TRUE;
635: fnd_oam_debug.log(1, l_ctxt, 'Source Final Text: "'||p_source_final_text||'"');
636: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
637: RETURN;
638: END;
639:

Line 636: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

632: x_return_msg := 'ARG_ID ('||px_arg.arg_id||'), failed to parse source final text: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
633: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
634: px_arg.init_locally := TRUE;
635: fnd_oam_debug.log(1, l_ctxt, 'Source Final Text: "'||p_source_final_text||'"');
636: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
637: RETURN;
638: END;
639:
640: --finally, define a column with the correct output type

Line 661: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

657: 1,
658: l_rowid);
659: ELSE
660: x_return_msg := 'Unknown Arg Dataype: '||px_arg.datatype;
661: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
662: px_arg.init_locally := TRUE;
663: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
664: RETURN;
665: END CASE;

Line 663: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

659: ELSE
660: x_return_msg := 'Unknown Arg Dataype: '||px_arg.datatype;
661: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
662: px_arg.init_locally := TRUE;
663: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
664: RETURN;
665: END CASE;
666:
667: --set these sorts of args to be initialized

Line 685: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

681:
682: --return success
683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684: px_arg.init_locally := TRUE;
685: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
686: EXCEPTION
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 690: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

686: EXCEPTION
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
690: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
691: px_arg.init_locally := TRUE;
692: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
693: END;
694:

Line 692: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: x_return_msg := 'Arg ID('||px_arg.arg_id||') Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
690: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
691: px_arg.init_locally := TRUE;
692: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
693: END;
694:
695: -- Private: used to set up the arg state and perform any pre-GET operations to make sure that all GETS
696: -- proceed in the same way. Only messes with the value fields in the case of constants so we don't have to select out

Line 720: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

716:
717: l_return_status VARCHAR2(6);
718: l_return_msg VARCHAR2(2048);
719: BEGIN
720: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: x_return_msg := '';
723:
724: fnd_oam_debug.log(1, l_ctxt, 'Argument(Splitting?): '||px_arg.arg_name||'('||FND_OAM_DSCRAM_UTILS_PKG.BOOLEAN_TO_FLAG(p_using_splitting)||')');

Line 724: fnd_oam_debug.log(1, l_ctxt, 'Argument(Splitting?): '||px_arg.arg_name||'('||FND_OAM_DSCRAM_UTILS_PKG.BOOLEAN_TO_FLAG(p_using_splitting)||')');

720: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: x_return_msg := '';
723:
724: fnd_oam_debug.log(1, l_ctxt, 'Argument(Splitting?): '||px_arg.arg_name||'('||FND_OAM_DSCRAM_UTILS_PKG.BOOLEAN_TO_FLAG(p_using_splitting)||')');
725:
726: --check if we've already done the local init
727: IF px_arg.init_locally THEN
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 729: fnd_oam_debug.log(1, l_ctxt, 'Already locally initialized');

725:
726: --check if we've already done the local init
727: IF px_arg.init_locally THEN
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729: fnd_oam_debug.log(1, l_ctxt, 'Already locally initialized');
730: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
731: RETURN;
732: END IF;
733:

Line 730: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

726: --check if we've already done the local init
727: IF px_arg.init_locally THEN
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729: fnd_oam_debug.log(1, l_ctxt, 'Already locally initialized');
730: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
731: RETURN;
732: END IF;
733:
734: --before locking the arg, select to see if its initialized already by another thread

Line 752: fnd_oam_debug.log(1, l_ctxt, 'Pre-Lock select found already initialized.');

748: l_source_text,
749: l_source_final_text,
750: x_return_status,
751: x_return_msg);
752: fnd_oam_debug.log(1, l_ctxt, 'Pre-Lock select found already initialized.');
753: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
754: RETURN;
755: END IF;
756:

Line 753: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

749: l_source_final_text,
750: x_return_status,
751: x_return_msg);
752: fnd_oam_debug.log(1, l_ctxt, 'Pre-Lock select found already initialized.');
753: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
754: RETURN;
755: END IF;
756:
757: -- if we got here, we'll probably be updating the arg so lock it and make sure we still need to update it

Line 776: fnd_oam_debug.log(1, l_ctxt, 'Locking select found already initialized.');

772: l_source_text,
773: l_source_final_text,
774: x_return_status,
775: x_return_msg);
776: fnd_oam_debug.log(1, l_ctxt, 'Locking select found already initialized.');
777: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
778: ROLLBACK;
779: RETURN;
780: END IF;

Line 777: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

773: l_source_final_text,
774: x_return_status,
775: x_return_msg);
776: fnd_oam_debug.log(1, l_ctxt, 'Locking select found already initialized.');
777: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
778: ROLLBACK;
779: RETURN;
780: END IF;
781:

Line 803: fnd_oam_debug.log(6, l_ctxt, 'ARG ID('||px_arg.arg_id||'), failed to create final sql stmt: '||l_return_msg);

799: l_source_final_text,
800: l_return_status,
801: l_return_msg);
802: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: fnd_oam_debug.log(6, l_ctxt, 'ARG ID('||px_arg.arg_id||'), failed to create final sql stmt: '||l_return_msg);
804: px_arg.initialized_success_flag := FND_API.G_FALSE;
805: END IF;
806: END IF;
807:

Line 839: fnd_oam_debug.log(1, l_ctxt, 'Pre-emptively writing the arg value');

835: --if the arg is writable and we determined if it has a valid value or not, write out the canonical value and valid_value_flag
836: --For constants, we bend the rules and write them even if it's not writable because otherwise get must incur the cost of messing
837: --with the source_text.
838: IF (px_arg.valid_value_flag IS NOT NULL AND IS_WRITABLE(px_arg)) THEN
839: fnd_oam_debug.log(1, l_ctxt, 'Pre-emptively writing the arg value');
840: UPDATE fnd_oam_dscram_args_b
841: SET valid_value_flag = px_arg.valid_value_flag,
842: canonical_value = px_arg.canonical_value
843: WHERE arg_id = px_arg.arg_id;

Line 852: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

848: --return success
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850: ELSE
851: x_return_msg := 'ARG ID('||px_arg.arg_id||'), got to the end but arg was not initialized. This should not happen.';
852: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
853: RAISE INIT_FAILED;
854: END IF;
855:
856: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 856: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

852: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
853: RAISE INIT_FAILED;
854: END IF;
855:
856: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
857: EXCEPTION
858: WHEN INIT_FAILED THEN
859: --x_return_* already set, only raised after locking select
860: BEGIN

Line 869: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

865: last_update_date = SYSDATE
866: WHERE arg_id = px_arg.arg_id;
867: COMMIT;
868: px_arg.initialized_success_flag := FND_API.G_FALSE;
869: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
870: EXCEPTION
871: WHEN OTHERS THEN
872: x_return_msg := 'Unexpected Error while processing init_failed: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
873: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 873: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

869: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
870: EXCEPTION
871: WHEN OTHERS THEN
872: x_return_msg := 'Unexpected Error while processing init_failed: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
873: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
874: ROLLBACK;
875: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
876: END;
877: WHEN OTHERS THEN

Line 875: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

871: WHEN OTHERS THEN
872: x_return_msg := 'Unexpected Error while processing init_failed: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
873: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
874: ROLLBACK;
875: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
876: END;
877: WHEN OTHERS THEN
878: --here we can't assume we have a lock so leave out update of DB but do update our local state
879: px_arg.initialized_success_flag := FND_API.G_FALSE;

Line 882: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

878: --here we can't assume we have a lock so leave out update of DB but do update our local state
879: px_arg.initialized_success_flag := FND_API.G_FALSE;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while initializing: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
882: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
883: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
884: ROLLBACK;
885: END;
886:

Line 883: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

879: px_arg.initialized_success_flag := FND_API.G_FALSE;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while initializing: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
882: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
883: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
884: ROLLBACK;
885: END;
886:
887: -- Private, helper to STORE_CANONICAL_ARG_VALUE to perform an insert into the ARG_VALUES table

Line 949: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

945: l_ctxt VARCHAR2(60) := PKG_NAME||'STORE_ARG_VALUE';
946:
947: l_arg_val_id NUMBER;
948: BEGIN
949: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: x_return_msg := '';
952:
953: IF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE THEN

Line 974: fnd_oam_debug.log(1, l_ctxt, 'Inserting per-worker arg value.');

970: WHERE arg_id = px_arg.arg_id
971: AND parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND
972: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;
973: IF SQL%ROWCOUNT = 0 THEN
974: fnd_oam_debug.log(1, l_ctxt, 'Inserting per-worker arg value.');
975: INSERT_ARG_VALUE(px_arg.arg_id,
976: px_arg.valid_value_flag,
977: px_arg.canonical_value,
978: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER,

Line 997: fnd_oam_debug.log(1, l_ctxt, 'Inserting per-range arg value.');

993: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RANGE AND
994: rowid_lbound = px_arg.rowid_lbound AND
995: rowid_ubound = px_arg.rowid_ubound;
996: IF SQL%ROWCOUNT = 0 THEN
997: fnd_oam_debug.log(1, l_ctxt, 'Inserting per-range arg value.');
998: INSERT_ARG_VALUE(px_arg.arg_id,
999: px_arg.valid_value_flag,
1000: px_arg.canonical_value,
1001: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RANGE,

Line 1007: fnd_oam_debug.log(1, l_ctxt, 'Inserting always arg value.');

1003: p_rowid_ubound => px_arg.rowid_ubound,
1004: x_arg_val_id => l_arg_val_id);
1005: END IF;
1006: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ALWAYS THEN
1007: fnd_oam_debug.log(1, l_ctxt, 'Inserting always arg value.');
1008: INSERT_ARG_VALUE(px_arg.arg_id,
1009: px_arg.valid_value_flag,
1010: px_arg.canonical_value,
1011: NULL,

Line 1017: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1013: p_rowid_ubound => px_arg.rowid_ubound,
1014: x_arg_val_id => l_arg_val_id);
1015: ELSE
1016: x_return_msg := 'Invalid write policy: '||px_arg.write_policy;
1017: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1018: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1019: RETURN;
1020: END IF;
1021:

Line 1018: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1014: x_arg_val_id => l_arg_val_id);
1015: ELSE
1016: x_return_msg := 'Invalid write policy: '||px_arg.write_policy;
1017: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1018: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1019: RETURN;
1020: END IF;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1023: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1019: RETURN;
1020: END IF;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while storing canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 1028: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while storing canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1028: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1029: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1030: END;
1031:
1032: -- Private Wrapper: STORE in an autonomous transaction for cases such as context args where we can't roll back or

Line 1029: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while storing canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1028: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1029: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1030: END;
1031:
1032: -- Private Wrapper: STORE in an autonomous transaction for cases such as context args where we can't roll back or
1033: -- failure cases where we're going to roll back but we don't want future get_args to keep failing.

Line 1098: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

1094: l_ignore VARCHAR2(128);
1095: l_return_status VARCHAR2(6);
1096: l_return_msg VARCHAR2(2048);
1097: BEGIN
1098: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: x_return_msg := '';
1101:
1102: fnd_oam_debug.log(1, l_ctxt, 'Argument(ID): '||px_arg.arg_name||'('||px_arg.arg_id||')');

Line 1102: fnd_oam_debug.log(1, l_ctxt, 'Argument(ID): '||px_arg.arg_name||'('||px_arg.arg_id||')');

1098: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: x_return_msg := '';
1101:
1102: fnd_oam_debug.log(1, l_ctxt, 'Argument(ID): '||px_arg.arg_name||'('||px_arg.arg_id||')');
1103:
1104: --initialize the argument if it hasn't been initialized locally yet (sets up source_cursor/derived state)
1105: IF NOT px_arg.init_locally THEN
1106: INITIALIZE_ARG(px_arg,

Line 1114: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1110: l_return_msg);
1111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1112: x_return_status := l_return_status;
1113: x_return_msg := l_return_msg;
1114: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1115: END IF;
1116: END IF;
1117:
1118: --if the arg went through init before and we stored that it failed, return an error, this is less likely

Line 1121: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1117:
1118: --if the arg went through init before and we stored that it failed, return an error, this is less likely
1119: IF px_arg.initialized_success_flag = FND_API.G_FALSE THEN
1120: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), previous call to init stored that it failed. Get cannot continue.';
1121: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1122: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1123: RETURN;
1124: END IF;
1125:

Line 1122: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1118: --if the arg went through init before and we stored that it failed, return an error, this is less likely
1119: IF px_arg.initialized_success_flag = FND_API.G_FALSE THEN
1120: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), previous call to init stored that it failed. Get cannot continue.';
1121: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1122: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1123: RETURN;
1124: END IF;
1125:
1126: --at this point, we should have a sucessfully initialized arg, try to determine its value

Line 1134: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1130: --now check if valid_value_flag's been set to false meaning we have no value and sourcing fails
1131: IF px_arg.valid_value_flag = FND_API.G_FALSE THEN
1132: --note: this means that a malformed constant will not be overrideable by the arg_context, should be a very infrequent corner case.
1133: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), previous call to get_value stored that fetching the value fails. Exiting.';
1134: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1135: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1136: RETURN;
1137: -- see if we already have a value, skip the check if we write always
1138: ELSIF px_arg.valid_value_flag = FND_API.G_TRUE AND

Line 1135: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1131: IF px_arg.valid_value_flag = FND_API.G_FALSE THEN
1132: --note: this means that a malformed constant will not be overrideable by the arg_context, should be a very infrequent corner case.
1133: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), previous call to get_value stored that fetching the value fails. Exiting.';
1134: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1135: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1136: RETURN;
1137: -- see if we already have a value, skip the check if we write always
1138: ELSIF px_arg.valid_value_flag = FND_API.G_TRUE AND
1139: (NOT (IS_WRITABLE(px_arg)) OR

Line 1148: fnd_oam_debug.log(1, l_ctxt, 'Ranged Value cached');

1144: (px_arg.rowid_ubound IS NULL OR (px_arg.rowid_ubound = p_rowid_ubound))) THEN
1145:
1146: x_return_status := FND_API.G_RET_STS_SUCCESS;
1147: x_value := px_arg.canonical_value;
1148: fnd_oam_debug.log(1, l_ctxt, 'Ranged Value cached');
1149: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1150: RETURN;
1151: END IF;
1152: ELSE

Line 1149: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1145:
1146: x_return_status := FND_API.G_RET_STS_SUCCESS;
1147: x_value := px_arg.canonical_value;
1148: fnd_oam_debug.log(1, l_ctxt, 'Ranged Value cached');
1149: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1150: RETURN;
1151: END IF;
1152: ELSE
1153: --if not contingent on a range, the value is the arg's stored canonical value

Line 1156: fnd_oam_debug.log(1, l_ctxt, 'Value cached');

1152: ELSE
1153: --if not contingent on a range, the value is the arg's stored canonical value
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155: x_value := px_arg.canonical_value;
1156: fnd_oam_debug.log(1, l_ctxt, 'Value cached');
1157: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1158: RETURN;
1159: END IF;
1160: ELSE

Line 1157: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1153: --if not contingent on a range, the value is the arg's stored canonical value
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155: x_value := px_arg.canonical_value;
1156: fnd_oam_debug.log(1, l_ctxt, 'Value cached');
1157: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1158: RETURN;
1159: END IF;
1160: ELSE
1161: -- we haven't cached that the value's valid somewhere, but it may have been calculated and stored already in the DB

Line 1170: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once: first query valid_value_flag: '||l_valid_value_flag);

1166: SELECT valid_value_flag, canonical_value
1167: INTO l_valid_value_flag, l_canonical_value
1168: FROM fnd_oam_dscram_args_b
1169: WHERE arg_id = px_arg.arg_id;
1170: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once: first query valid_value_flag: '||l_valid_value_flag);
1171: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER THEN
1172: --Needed in the case of restart to get the value we may have comitted for this worker
1173: --query arg_values with parent_type=worker
1174: BEGIN

Line 1185: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Per-Worker: first query valid_value_flag: '||l_valid_value_flag);

1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: l_valid_value_flag := NULL;
1184: END;
1185: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Per-Worker: first query valid_value_flag: '||l_valid_value_flag);
1186: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE THEN
1187: --Since we don't share ranges, this won't happen on the initial execute, but it may be necessary on restart
1188: --if the arg's value was comitted since we won't read it back on initialize.
1189: --query arg_values with range values and parent_type = range

Line 1202: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Per-Range: first query valid_value_flag: '||l_valid_value_flag);

1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: l_valid_value_flag := NULL;
1201: END;
1202: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Per-Range: first query valid_value_flag: '||l_valid_value_flag);
1203: END IF;
1204:
1205: --if we found a value for valid_value_flag, we've determined a value or a failure
1206: IF l_valid_value_flag = FND_API.G_TRUE THEN

Line 1211: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1207: l_determined_value := TRUE;
1208: ELSIF l_valid_value_flag = FND_API.G_FALSE THEN
1209: --A false means sourcing failes
1210: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), non-locking select: previous call to get_value stored that fetching the value fails. Exiting.';
1211: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1212: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1213: RETURN;
1214: END IF;
1215: END IF;

Line 1212: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1208: ELSIF l_valid_value_flag = FND_API.G_FALSE THEN
1209: --A false means sourcing failes
1210: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), non-locking select: previous call to get_value stored that fetching the value fails. Exiting.';
1211: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1212: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1213: RETURN;
1214: END IF;
1215: END IF;
1216:

Line 1234: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once, locking query valid_value_flag: '||l_valid_value_flag);

1230: SELECT valid_value_flag, canonical_value
1231: INTO l_valid_value_flag, l_canonical_value
1232: FROM fnd_oam_dscram_args_b
1233: WHERE arg_id = px_arg.arg_id;
1234: fnd_oam_debug.log(1, l_ctxt, 'Write Policy Once, locking query valid_value_flag: '||l_valid_value_flag);
1235:
1236: --re-check the valid value flag
1237: IF l_valid_value_flag = FND_API.G_TRUE THEN
1238: l_determined_value := TRUE;

Line 1243: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1239: ELSIF l_valid_value_flag = FND_API.G_FALSE THEN
1240: --A false means sourcing failed previously
1241: px_arg.valid_value_flag := FND_API.G_FALSE;
1242: x_return_msg := 'Arg ID ('||px_arg.arg_id||'), locking select: previous call to get_value stored that fetching the value fails. Exiting.';
1243: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1244: RAISE GET_FAILED;
1245: END IF;
1246: END IF;
1247: END IF;

Line 1387: fnd_oam_debug.log(1, l_ctxt, 'Doing Last ditch context check.');

1383: --if we don't have a value here, any arg can try to source from the context before being flagged as a failure.
1384: --This allows placeholder args for dmls where there is no source, just the expectation of inheriting a value from the context
1385: IF NOT l_determined_value AND
1386: px_arg_context.EXISTS(px_arg.arg_name) THEN
1387: fnd_oam_debug.log(1, l_ctxt, 'Doing Last ditch context check.');
1388: IF IS_READABLE(px_arg_context(px_arg.arg_name)) AND
1389: px_arg_context(px_arg.arg_name).datatype = px_arg.datatype THEN
1390:
1391: GET_CANONICAL_CTXT_ARG_VALUE(px_arg_context(px_arg.arg_name),

Line 1411: fnd_oam_debug.log(1, l_ctxt, 'Returning Missing Binds');

1407: ELSIF l_return_status = FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_BINDS THEN
1408: --since this is the last thing before failure, let missing binds return
1409: x_return_status := l_return_status;
1410: x_return_msg := l_return_msg;
1411: fnd_oam_debug.log(1, l_ctxt, 'Returning Missing Binds');
1412: RETURN;
1413: END IF;
1414: END IF;
1415: END IF;

Line 1419: fnd_oam_debug.log(6, l_ctxt, 'Arg ID ('||px_arg.arg_id||'), failed to determine a value.');

1415: END IF;
1416:
1417: --at this point, we've done everything we can to determine the value, if we haven't and we allowed sourcing then the get's a failure
1418: IF NOT l_determined_value AND p_allow_sourcing THEN
1419: fnd_oam_debug.log(6, l_ctxt, 'Arg ID ('||px_arg.arg_id||'), failed to determine a value.');
1420: l_valid_value_flag := FND_API.G_FALSE;
1421: l_determined_value := TRUE;
1422: l_value_requires_store := TRUE;
1423: END IF;

Line 1472: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);

1468: (px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE AND NOT l_value_requires_store)) THEN
1469: IF l_lock_handle IS NOT NULL THEN
1470: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
1471: IF l_retval <> 0 THEN
1472: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
1473: END IF;
1474: END IF;
1475: x_arg_lock_handle := NULL;
1476: ELSE

Line 1491: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1487: --it's a real successful get or just a sucessful lack of failure.
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: x_value := NULL;
1490: END IF;
1491: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1492: EXCEPTION
1493: WHEN GET_FAILED THEN
1494: IF l_lock_handle IS NOT NULL THEN
1495: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);

Line 1497: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);

1493: WHEN GET_FAILED THEN
1494: IF l_lock_handle IS NOT NULL THEN
1495: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
1496: IF l_retval <> 0 THEN
1497: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
1498: END IF;
1499: END IF;
1500:
1501: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 1501: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1497: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
1498: END IF;
1499: END IF;
1500:
1501: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1502: RETURN;
1503: WHEN OTHERS THEN
1504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while getting canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 1506: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1502: RETURN;
1503: WHEN OTHERS THEN
1504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: x_return_msg := 'Arg ID('||px_arg.arg_id||'), unexpected error while getting canonical value: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1506: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1507:
1508: --store that the arg's value yields failure
1509: BEGIN
1510: IF IS_WRITABLE(px_arg) THEN

Line 1519: fnd_oam_debug.log(6, l_ctxt, 'Store failure failed('||l_return_status||'): '||l_return_msg);

1515: STORE_ARG_VALUE_AUTONOMOUSLY(px_arg,
1516: l_return_status,
1517: l_return_msg);
1518: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1519: fnd_oam_debug.log(6, l_ctxt, 'Store failure failed('||l_return_status||'): '||l_return_msg);
1520: END IF;
1521: END IF;
1522: EXCEPTION
1523: WHEN OTHERS THEN

Line 1524: fnd_oam_debug.log(6, l_ctxt, 'Exception while storing failed arg fetch: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

1520: END IF;
1521: END IF;
1522: EXCEPTION
1523: WHEN OTHERS THEN
1524: fnd_oam_debug.log(6, l_ctxt, 'Exception while storing failed arg fetch: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1525: END;
1526: IF l_lock_handle IS NOT NULL THEN
1527: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
1528: IF l_retval <> 0 THEN

Line 1529: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);

1525: END;
1526: IF l_lock_handle IS NOT NULL THEN
1527: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
1528: IF l_retval <> 0 THEN
1529: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
1530: END IF;
1531: END IF;
1532: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1533: END;

Line 1532: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1528: IF l_retval <> 0 THEN
1529: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
1530: END IF;
1531: END IF;
1532: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1533: END;
1534:
1535: -- Private Wrapper for context args
1536: PROCEDURE GET_CANONICAL_CTXT_ARG_VALUE(px_arg IN OUT NOCOPY arg,

Line 1639: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1639: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1640: x_value := NULL;
1641: END;
1642:
1643: -- Public, getter for type NUMBER

Line 1691: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1687: EXCEPTION
1688: WHEN OTHERS THEN
1689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1690: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1691: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1692: x_value := NULL;
1693: END;
1694:
1695: -- Public, getter for type DATE

Line 1743: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1743: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1744: x_value := NULL;
1745: END;
1746:
1747: -- Public, getter for type ROWID

Line 1795: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1791: EXCEPTION
1792: WHEN OTHERS THEN
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1795: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1796: x_value := NULL;
1797: END;
1798:
1799: --Private, used by internal_print_arg_context to reset an arg to an unknown initialized status

Line 1815: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||p_arg_id||'), failed to reset initialized flag: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

1811: WHERE arg_id = p_arg_id;
1812: COMMIT;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||p_arg_id||'), failed to reset initialized flag: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1816: ROLLBACK;
1817: END;
1818:
1819: -- Private

Line 1839: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

1835: l_prev_valid_value_flag VARCHAR2(3);
1836: l_return_status VARCHAR2(6);
1837: l_return_msg VARCHAR2(2048);
1838: BEGIN
1839: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1840: x_return_status := FND_API.G_RET_STS_ERROR;
1841: x_return_msg := '';
1842:
1843: l_s := p_arg_ctxt.FIRST;

Line 1845: fnd_oam_debug.log(1, l_ctxt, 'Arg Name(Permissions): '||p_arg_ctxt(l_s).arg_name||'('||p_arg_ctxt(l_s).permissions||')');

1841: x_return_msg := '';
1842:
1843: l_s := p_arg_ctxt.FIRST;
1844: WHILE l_s IS NOT NULL LOOP
1845: fnd_oam_debug.log(1, l_ctxt, 'Arg Name(Permissions): '||p_arg_ctxt(l_s).arg_name||'('||p_arg_ctxt(l_s).permissions||')');
1846: IF p_get_values AND
1847: IS_READABLE(p_arg_ctxt(l_s)) THEN
1848:
1849: --go ahead and fetch the value

Line 1863: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);

1859: ROLLBACK;
1860:
1861: --print the value if we suceeded
1862: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1863: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);
1864: END IF;
1865:
1866: --reset the arg's local state
1867: p_arg_ctxt(l_s).init_locally := FALSE;

Line 1881: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1877: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS,
1878: FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_MISSING_BINDS) THEN
1879: x_return_status := l_return_status;
1880: x_return_msg := l_return_msg;
1881: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1882: ROLLBACK;
1883: RETURN;
1884: END IF;
1885: ELSE

Line 1887: fnd_oam_debug.log(1, l_ctxt, 'Value: '||p_arg_ctxt(l_s).canonical_value);

1883: RETURN;
1884: END IF;
1885: ELSE
1886: IF p_arg_ctxt(l_s).valid_value_flag = FND_API.G_TRUE THEN
1887: fnd_oam_debug.log(1, l_ctxt, 'Value: '||p_arg_ctxt(l_s).canonical_value);
1888: ELSE
1889: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');
1890: END IF;
1891: END IF;

Line 1889: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');

1885: ELSE
1886: IF p_arg_ctxt(l_s).valid_value_flag = FND_API.G_TRUE THEN
1887: fnd_oam_debug.log(1, l_ctxt, 'Value: '||p_arg_ctxt(l_s).canonical_value);
1888: ELSE
1889: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');
1890: END IF;
1891: END IF;
1892:
1893: l_s := p_arg_ctxt.NEXT(l_s);

Line 1897: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1893: l_s := p_arg_ctxt.NEXT(l_s);
1894: END LOOP;
1895:
1896: x_return_status := FND_API.G_RET_STS_SUCCESS;
1897: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 1902: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1902: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1903: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1904: END;
1905:
1906: -- Public

Line 1903: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1902: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1903: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1904: END;
1905:
1906: -- Public
1907: PROCEDURE PRINT_ARG_CONTEXT(px_arg_context IN OUT NOCOPY arg_context)

Line 1937: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

1933:
1934: l_return_status VARCHAR2(6);
1935: l_return_msg VARCHAR2(2048);
1936: BEGIN
1937: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1938: x_return_status := FND_API.G_RET_STS_ERROR;
1939: x_return_msg := '';
1940:
1941: k := p_arg_list.FIRST;

Line 1943: fnd_oam_debug.log(1, l_ctxt, 'Arg Name(Permissions): '||p_arg_list(k).arg_name||'('||p_arg_list(k).permissions||')');

1939: x_return_msg := '';
1940:
1941: k := p_arg_list.FIRST;
1942: WHILE k IS NOT NULL LOOP
1943: fnd_oam_debug.log(1, l_ctxt, 'Arg Name(Permissions): '||p_arg_list(k).arg_name||'('||p_arg_list(k).permissions||')');
1944:
1945: --skip fetching the value since this is typically proceeded by a call to bind_args which does the gets
1946: IF p_arg_list(k).valid_value_flag = FND_API.G_TRUE THEN
1947: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);

Line 1947: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);

1943: fnd_oam_debug.log(1, l_ctxt, 'Arg Name(Permissions): '||p_arg_list(k).arg_name||'('||p_arg_list(k).permissions||')');
1944:
1945: --skip fetching the value since this is typically proceeded by a call to bind_args which does the gets
1946: IF p_arg_list(k).valid_value_flag = FND_API.G_TRUE THEN
1947: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);
1948: ELSE
1949: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');
1950: END IF;
1951:

Line 1949: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');

1945: --skip fetching the value since this is typically proceeded by a call to bind_args which does the gets
1946: IF p_arg_list(k).valid_value_flag = FND_API.G_TRUE THEN
1947: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_val);
1948: ELSE
1949: fnd_oam_debug.log(1, l_ctxt, 'Value: ?');
1950: END IF;
1951:
1952: k := p_arg_list.NEXT(k);
1953: END LOOP;

Line 1956: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1952: k := p_arg_list.NEXT(k);
1953: END LOOP;
1954:
1955: x_return_status := FND_API.G_RET_STS_SUCCESS;
1956: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1957: EXCEPTION
1958: WHEN OTHERS THEN
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 1961: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

1957: EXCEPTION
1958: WHEN OTHERS THEN
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1961: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1962: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1963: END;
1964:
1965: -- Public

Line 1962: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1958: WHEN OTHERS THEN
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
1961: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
1962: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1963: END;
1964:
1965: -- Public
1966: PROCEDURE FETCH_RUN_ARG_CONTEXT(p_run_id IN NUMBER,

Line 1993: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

1989: l_return_msg VARCHAR2(2048);
1990: k NUMBER;
1991: l_ignore BOOLEAN;
1992: BEGIN
1993: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1994: x_return_status := FND_API.G_RET_STS_ERROR;
1995: x_return_msg := '';
1996:
1997: -- grab all the global and run args, global before run to allow run to override

Line 2039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2036: x_return_status := l_return_status;
2037: x_return_msg := l_return_msg;
2038: x_arg_context := l_empty_arg_context;
2039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2040: RETURN;
2041: END IF;
2042: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN
2043: --try to print the arg context but don't init or fail if bad.

Line 2042: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN

2038: x_arg_context := l_empty_arg_context;
2039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2040: RETURN;
2041: END IF;
2042: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN
2043: --try to print the arg context but don't init or fail if bad.
2044: print_arg_context(l_arg_ctxt);
2045: END IF;
2046:

Line 2050: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2046:
2047: --return the context
2048: x_return_status := FND_API.G_RET_STS_SUCCESS;
2049: x_arg_context := l_arg_ctxt;
2050: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2051: EXCEPTION
2052: WHEN OTHERS THEN
2053: x_arg_context := l_empty_arg_context;
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2056: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2052: WHEN OTHERS THEN
2053: x_arg_context := l_empty_arg_context;
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2055: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2056: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2057: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2058: END;
2059:
2060: -- Public

Line 2057: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2053: x_arg_context := l_empty_arg_context;
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2055: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2056: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2057: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2058: END;
2059:
2060: -- Public
2061: PROCEDURE FETCH_ARG_LIST(p_parent_type IN VARCHAR2,

Line 2093: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2089:
2090: l_return_status VARCHAR2(6);
2091: l_return_msg VARCHAR2(2048);
2092: BEGIN
2093: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095: x_return_msg := '';
2096:
2097: --get all the args attached to the specified parent type/id

Line 2150: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2147: x_return_status := l_return_status;
2148: x_return_msg := l_return_msg;
2149: x_arg_list := l_empty_arg_list;
2150: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2151: RETURN;
2152: END IF;
2153: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN
2154: --print the arg list

Line 2153: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN

2149: x_arg_list := l_empty_arg_list;
2150: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2151: RETURN;
2152: END IF;
2153: ELSIF fnd_oam_debug.test(1, l_ctxt) THEN
2154: --print the arg list
2155: print_arg_list(l_arg_list,
2156: l_return_status,
2157: l_return_msg);

Line 2164: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2160: --return the final list
2161: x_return_status := FND_API.G_RET_STS_SUCCESS;
2162: x_arg_list := l_arg_list;
2163: x_has_writable := l_has_writable;
2164: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2168: x_return_msg := 'Parent Type ('||p_parent_type||'), ID('||p_parent_id||'), while fetching arg list: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 2169: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2168: x_return_msg := 'Parent Type ('||p_parent_type||'), ID('||p_parent_id||'), while fetching arg list: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2169: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2171: END;
2172:
2173: -- Public

Line 2170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2166: WHEN OTHERS THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2168: x_return_msg := 'Parent Type ('||p_parent_type||'), ID('||p_parent_id||'), while fetching arg list: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2169: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2170: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2171: END;
2172:
2173: -- Public
2174: PROCEDURE BIND_ARG_LIST_TO_CURSOR(p_arg_list IN OUT NOCOPY arg_list,

Line 2195: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2191:
2192: l_return_status VARCHAR2(6);
2193: l_return_msg VARCHAR2(2048);
2194: BEGIN
2195: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: x_return_msg := '';
2198:
2199: --traverse the arg list, everything that's readable MUST be bound, otherwise it wouldn't be in the list

Line 2212: fnd_oam_debug.log(1, l_ctxt, 'Binding Arg: '||p_arg_list(k).arg_name);

2208: l_number := NULL;
2209: l_date := NULL;
2210: l_rowid := NULL;
2211:
2212: fnd_oam_debug.log(1, l_ctxt, 'Binding Arg: '||p_arg_list(k).arg_name);
2213:
2214: --prep the name of the bind variable
2215: l_bindvar_name := ':'||p_arg_list(k).arg_name;
2216:

Line 2232: fnd_oam_debug.log(1, l_ctxt, 'Value(VARCHAR2): '||l_varchar2);

2228: l_varchar2,
2229: l_return_status,
2230: l_return_msg);
2231: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2232: fnd_oam_debug.log(1, l_ctxt, 'Value(VARCHAR2): '||l_varchar2);
2233: ELSE
2234: x_return_status := l_return_status;
2235: x_return_msg := l_return_msg;
2236: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 2236: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2232: fnd_oam_debug.log(1, l_ctxt, 'Value(VARCHAR2): '||l_varchar2);
2233: ELSE
2234: x_return_status := l_return_status;
2235: x_return_msg := l_return_msg;
2236: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2237: RETURN;
2238: END IF;
2239:
2240: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN

Line 2252: fnd_oam_debug.log(1, l_ctxt, 'Value(NUMBER): '||FND_NUMBER.NUMBER_TO_CANONICAL(l_number));

2248: l_number,
2249: l_return_status,
2250: l_return_msg);
2251: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2252: fnd_oam_debug.log(1, l_ctxt, 'Value(NUMBER): '||FND_NUMBER.NUMBER_TO_CANONICAL(l_number));
2253: ELSE
2254: --or fail
2255: x_return_status := l_return_status;
2256: x_return_msg := l_return_msg;

Line 2257: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2253: ELSE
2254: --or fail
2255: x_return_status := l_return_status;
2256: x_return_msg := l_return_msg;
2257: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2258: RETURN;
2259: END IF;
2260:
2261: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN

Line 2273: fnd_oam_debug.log(1, l_ctxt, 'Value(DATE): '||FND_DATE.DATE_TO_CANONICAL(l_date));

2269: l_date,
2270: l_return_status,
2271: l_return_msg);
2272: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2273: fnd_oam_debug.log(1, l_ctxt, 'Value(DATE): '||FND_DATE.DATE_TO_CANONICAL(l_date));
2274: ELSE
2275: --or fail
2276: x_return_status := l_return_status;
2277: x_return_msg := l_return_msg;

Line 2278: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2274: ELSE
2275: --or fail
2276: x_return_status := l_return_status;
2277: x_return_msg := l_return_msg;
2278: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2279: RETURN;
2280: END IF;
2281:
2282: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN

Line 2294: fnd_oam_debug.log(1, l_ctxt, 'Value(ROWID): '||ROWIDTOCHAR(l_rowid));

2290: l_rowid,
2291: l_return_status,
2292: l_return_msg);
2293: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2294: fnd_oam_debug.log(1, l_ctxt, 'Value(ROWID): '||ROWIDTOCHAR(l_rowid));
2295: ELSE
2296: --or fail
2297: x_return_status := l_return_status;
2298: x_return_msg := l_return_msg;

Line 2299: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2295: ELSE
2296: --or fail
2297: x_return_status := l_return_status;
2298: x_return_msg := l_return_msg;
2299: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2300: RETURN;
2301: END IF;
2302: ELSE
2303: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;

Line 2304: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2300: RETURN;
2301: END IF;
2302: ELSE
2303: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;
2304: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2305: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2306: RETURN;
2307: END CASE;
2308: END IF;

Line 2305: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2301: END IF;
2302: ELSE
2303: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;
2304: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2305: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2306: RETURN;
2307: END CASE;
2308: END IF;
2309:

Line 2335: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2331: l_bindvar_name,
2332: l_rowid);
2333: ELSE
2334: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;
2335: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2336: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2337: RETURN;
2338: END CASE;
2339: EXCEPTION

Line 2336: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2332: l_rowid);
2333: ELSE
2334: x_return_msg := 'Arg ('||p_arg_list(k).arg_id||') has unknown datatype:'||p_arg_list(k).datatype;
2335: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2336: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2337: RETURN;
2338: END CASE;
2339: EXCEPTION
2340: WHEN BIND_DOES_NOT_EXIST THEN

Line 2342: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||p_arg_list(k).arg_id||'), Bindvar('||l_bindvar_name||') does not exist');

2338: END CASE;
2339: EXCEPTION
2340: WHEN BIND_DOES_NOT_EXIST THEN
2341: --catch a common error and provide better feedback.
2342: fnd_oam_debug.log(1, l_ctxt, 'Arg ID('||p_arg_list(k).arg_id||'), Bindvar('||l_bindvar_name||') does not exist');
2343: x_return_msg := 'Arg ID('||p_arg_list(k).arg_id||'), Bind Variable ('||l_bindvar_name||') failure: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2344: RETURN;
2345: WHEN OTHERS THEN
2346: RAISE;

Line 2356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2352: END LOOP;
2353:
2354: --all bound, return success
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;
2356: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 2361: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2361: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2363: END;
2364:
2365: -- Public

Line 2362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2358: WHEN OTHERS THEN
2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2361: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2363: END;
2364:
2365: -- Public
2366: PROCEDURE UPDATE_WRITABLE_ARG_VALUES(px_arg_list IN OUT NOCOPY arg_list,

Line 2387: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2383:
2384: l_return_status VARCHAR2(6);
2385: l_return_msg VARCHAR2(2048);
2386: BEGIN
2387: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2388: x_return_status := FND_API.G_RET_STS_ERROR;
2389: x_return_msg := '';
2390:
2391: --if we're in a non-normal mode, store the values we get autonomously to keep them from

Line 2434: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2430:
2431: --if an arg failed to get a value, return it as an error, stop fetching other args
2432: x_return_status := l_return_status;
2433: x_return_msg := l_return_msg;
2434: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2435: RETURN;
2436: ELSE
2437: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_canonical_value);
2438: END IF;

Line 2437: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_canonical_value);

2433: x_return_msg := l_return_msg;
2434: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2435: RETURN;
2436: ELSE
2437: fnd_oam_debug.log(1, l_ctxt, 'Value: '||l_canonical_value);
2438: END IF;
2439: END IF;
2440: END IF;
2441:

Line 2447: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2443: END LOOP;
2444:
2445: --return the final list
2446: x_return_status := FND_API.G_RET_STS_SUCCESS;
2447: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 2452: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2452: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2453: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2454: END;
2455:
2456: -- Public

Line 2453: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2452: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2453: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2454: END;
2455:
2456: -- Public
2457: PROCEDURE UPDATE_CONTEXT_USING_ARG_LIST(px_arg_context IN OUT NOCOPY arg_context,

Line 2471: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2467:
2468: l_return_status VARCHAR2(6);
2469: l_return_msg VARCHAR2(2048);
2470: BEGIN
2471: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2472:
2473: --loop over each item in the arg list since its easier to lookup a match in the context
2474: k := p_arg_list.FIRST;
2475: WHILE k IS NOT NULL LOOP

Line 2514: fnd_oam_debug.log(1, l_ctxt, 'Set the context arg to value: '||p_arg_list(k).canonical_value);

2510: STORE_ARG_VALUE_AUTONOMOUSLY(px_arg_context(l_arg_name),
2511: l_return_status,
2512: l_return_msg);
2513: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2514: fnd_oam_debug.log(1, l_ctxt, 'Set the context arg to value: '||p_arg_list(k).canonical_value);
2515: ELSE
2516: --if we didn't store correctly, reset the context arg to unknown
2517: px_arg_context(l_arg_name).valid_value_flag := NULL;
2518: END IF;

Line 2525: fnd_oam_debug.log(1, l_ctxt, 'Context already has value: '||l_canonical_value);

2521: --if the set or store fail, reset the context arg's value to unknown
2522: px_arg_context(l_arg_name).valid_value_flag := NULL;
2523: END;
2524: ELSE
2525: fnd_oam_debug.log(1, l_ctxt, 'Context already has value: '||l_canonical_value);
2526: END IF;
2527:
2528: --release the lock if we have one
2529: IF l_lock_handle IS NOT NULL THEN

Line 2532: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);

2528: --release the lock if we have one
2529: IF l_lock_handle IS NOT NULL THEN
2530: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2531: IF l_retval <> 0 THEN
2532: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
2533: END IF;
2534: END IF;
2535: END IF;
2536: END IF;

Line 2541: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2537: END IF;
2538: k := p_arg_list.NEXT(k);
2539: END LOOP;
2540:
2541: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: --make sure there isn't a lock hanging around
2545: IF l_lock_handle IS NOT NULL THEN

Line 2548: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);

2544: --make sure there isn't a lock hanging around
2545: IF l_lock_handle IS NOT NULL THEN
2546: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2547: IF l_retval <> 0 THEN
2548: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
2549: END IF;
2550: END IF;
2551:
2552: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 2552: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

2548: fnd_oam_debug.log(6, l_ctxt, 'Failed to release arg lock: '||l_retval);
2549: END IF;
2550: END IF;
2551:
2552: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2553: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2554: RETURN;
2555: END;
2556:

Line 2553: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2549: END IF;
2550: END IF;
2551:
2552: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2553: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2554: RETURN;
2555: END;
2556:
2557: -- Public

Line 2569: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2565:
2566: l_return_status VARCHAR2(6);
2567: l_return_msg VARCHAR2(2048);
2568: BEGIN
2569: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: x_return_msg := '';
2572:
2573: k := px_arg_list.FIRST;

Line 2589: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2585: --delete the arg list
2586: px_arg_list.DELETE;
2587:
2588: x_return_status := FND_API.G_RET_STS_SUCCESS;
2589: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 2594: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2594: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2595: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2596: END;
2597:
2598: -- Public

Line 2595: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2594: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2595: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2596: END;
2597:
2598: -- Public
2599: PROCEDURE DESTROY_ARG_CONTEXT(px_arg_context IN OUT NOCOPY arg_context,

Line 2612: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

2608:
2609: l_return_status VARCHAR2(6);
2610: l_return_msg VARCHAR2(2048);
2611: BEGIN
2612: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: x_return_msg := '';
2615:
2616: --go through the args

Line 2634: fnd_oam_debug.log(1, l_ctxt, 'Arg('||l_s||'), stored final context value: '||l_canonical_value);

2630: l_canonical_value,
2631: l_return_status,
2632: l_return_msg);
2633: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2634: fnd_oam_debug.log(1, l_ctxt, 'Arg('||l_s||'), stored final context value: '||l_canonical_value);
2635: END IF;
2636: END IF;
2637:
2638: --close up the arg's cursor if it exists

Line 2651: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2647: --delete the arg context
2648: px_arg_context.DELETE;
2649:
2650: x_return_status := FND_API.G_RET_STS_SUCCESS;
2651: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 2656: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

2652: EXCEPTION
2653: WHEN OTHERS THEN
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2656: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2657: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2658: END;
2659:
2660: -- Public

Line 2657: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

2653: WHEN OTHERS THEN
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: x_return_msg := 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
2656: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
2657: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2658: END;
2659:
2660: -- Public
2661: -- Copied from FND_OAM_DS_PSETS_PKG, seems to mimic standard syntax of calls