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_DIAG_PKG dependencies on FND_OAM_DEBUG

Line 40: fnd_oam_debug.log(1, l_ctxt, 'Dropping test table indicies');

36: l_stmt VARCHAR2(2000);
37: index_missing EXCEPTION;
38: PRAGMA EXCEPTION_INIT(index_missing, -1418);
39: BEGIN
40: fnd_oam_debug.log(1, l_ctxt, 'Dropping test table indicies');
41: l_stmt := 'DROP INDEX '||p_table_name||'_N1';
42: EXECUTE IMMEDIATE l_stmt;
43: l_stmt := 'DROP INDEX '||p_table_name||'_N2';
44: EXECUTE IMMEDIATE l_stmt;

Line 50: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

46: EXCEPTION
47: WHEN index_missing THEN
48: RETURN TRUE;
49: WHEN OTHERS THEN
50: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
51: RETURN FALSE;
52: END;
53:
54: --Private, helper to MAKE_TEST_TABLE to drop it if it already exists

Line 68: fnd_oam_debug.log(1, l_ctxt, 'Dropping table');

64: p_owner) THEN
65: RETURN FALSE;
66: END IF;
67:
68: fnd_oam_debug.log(1, l_ctxt, 'Dropping table');
69: l_stmt := 'DROP TABLE '||p_owner||'.'||p_table_name;
70: EXECUTE IMMEDIATE l_stmt;
71: RETURN TRUE;
72: EXCEPTION

Line 74: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

70: EXECUTE IMMEDIATE l_stmt;
71: RETURN TRUE;
72: EXCEPTION
73: WHEN OTHERS THEN
74: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
75: RETURN FALSE;
76: END;
77:
78: --helper to make_test_table

Line 87: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Indicies');

83: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_TEST_TABLE_INDICIES';
84:
85: l_stmt VARCHAR2(2000);
86: BEGIN
87: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Indicies');
88: l_stmt := 'CREATE UNIQUE INDEX '||p_table_name||'_U1 ON '||p_table_name||' (C1)';
89: EXECUTE IMMEDIATE l_stmt;
90: l_stmt := 'CREATE INDEX '||p_table_name||'_N1 ON '||p_table_name||' (C3)';
91: EXECUTE IMMEDIATE l_stmt;

Line 95: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

91: EXECUTE IMMEDIATE l_stmt;
92: RETURN TRUE;
93: EXCEPTION
94: WHEN OTHERS THEN
95: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
96: RETURN FALSE;
97: END;
98:
99: --Private helper to make_test_table to create the data

Line 122: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Data');

118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;
121: BEGIN
122: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Data');
123: l_stmt := 'INSERT INTO '||p_owner||'.'||p_table_name||' (C1, C2, C3, C4, C5) VALUES (:1, :2, :3, :4, :5)';
124:
125: --if below some threshold, prepare in memory and insert
126: --DBMS_RANDOM.initialize(100);

Line 128: fnd_oam_debug.log(1, l_ctxt, 'Using Buffer and Bulk Bind method.');

124:
125: --if below some threshold, prepare in memory and insert
126: --DBMS_RANDOM.initialize(100);
127: IF p_num_rows <= 1000000 THEN
128: fnd_oam_debug.log(1, l_ctxt, 'Using Buffer and Bulk Bind method.');
129: k := 1;
130: WHILE k <= p_num_rows LOOP
131: v1_vals(k) := k;
132: v2_vals(k) := v2;

Line 143: fnd_oam_debug.log(1, l_ctxt, 'Using Serial Insert method...');

139: END LOOP;
140: FORALL k IN 1..p_num_rows
141: EXECUTE IMMEDIATE l_stmt USING v1_vals(k), v2_vals(k), v3_vals(k), v4_vals(k), v5_vals(k);
142: ELSE
143: fnd_oam_debug.log(1, l_ctxt, 'Using Serial Insert method...');
144: --populate the table
145: k := 0;
146: WHILE k < p_num_rows LOOP
147: --v4 := SYSDATE;

Line 161: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

157: --DBMS_RANDOM.terminate;
158: RETURN TRUE;
159: EXCEPTION
160: WHEN OTHERS THEN
161: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
162: RETURN FALSE;
163: END;
164:
165: -- Private, helper to the EXECUTE_* procedures to create a test table for ensuring diagnostic-style

Line 186: fnd_oam_debug.log(1, l_ctxt, 'Creating table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');

182: l_table_def VARCHAR2(2000);
183: l_tablespace_def VARCHAR2(1000);
184: l_nologging VARCHAR2(100) := 'NOLOGGING';
185: BEGIN
186: fnd_oam_debug.log(1, l_ctxt, 'Creating table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');
187: l_table_def := 'CREATE TABLE '||p_table_name||' (C1 NUMBER NOT NULL,
188: C2 NUMBER,
189: C3 VARCHAR2(30),
190: C4 DATE,

Line 198: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');

194: BEGIN
195: EXECUTE IMMEDIATE l_table_def||' '||l_tablespace_def||' '||l_nologging;
196: EXCEPTION
197: WHEN table_exists THEN
198: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');
199: IF NOT DROP_TEST_TABLE(p_table_name,
200: p_owner) THEN
201: RETURN FALSE;
202: END IF;

Line 206: fnd_oam_debug.log(1, l_ctxt, 'Tablespace missing, using default tablespace.');

202: END IF;
203: --otherwise, try to create the table again
204: EXECUTE IMMEDIATE l_table_def||' '||l_tablespace_def||' '||l_nologging;
205: WHEN tablespace_missing THEN
206: fnd_oam_debug.log(1, l_ctxt, 'Tablespace missing, using default tablespace.');
207: BEGIN
208: EXECUTE IMMEDIATE l_table_def||' '||l_nologging;
209: EXCEPTION
210: WHEN table_exists THEN

Line 211: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');

207: BEGIN
208: EXECUTE IMMEDIATE l_table_def||' '||l_nologging;
209: EXCEPTION
210: WHEN table_exists THEN
211: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');
212: IF NOT DROP_TEST_TABLE(p_table_name,
213: p_owner) THEN
214: RETURN FALSE;
215: END IF;

Line 219: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

215: END IF;
216: --otherwise, try to create the table again
217: EXECUTE IMMEDIATE l_table_def||' '||l_nologging;
218: WHEN OTHERS THEN
219: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
220: RETURN FALSE;
221: END;
222: WHEN OTHERS THEN
223: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

Line 223: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

219: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
220: RETURN FALSE;
221: END;
222: WHEN OTHERS THEN
223: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
224: RETURN FALSE;
225: END;
226: COMMIT;
227:

Line 251: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

247: COMMIT;
248: RETURN TRUE;
249: EXCEPTION
250: WHEN OTHERS THEN
251: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
252: ROLLBACK;
253: RETURN FALSE;
254: END;
255:

Line 273: fnd_oam_debug.log(1, l_ctxt, 'Creating table: '||p_dest_owner||'.'||p_dest_table_name||' from table '||p_src_owner||'.'||p_src_table_name);

269: PRAGMA EXCEPTION_INIT(table_exists, -955);
270:
271: l_stmt VARCHAR2(2000);
272: BEGIN
273: fnd_oam_debug.log(1, l_ctxt, 'Creating table: '||p_dest_owner||'.'||p_dest_table_name||' from table '||p_src_owner||'.'||p_src_table_name);
274: l_stmt := 'CREATE TABLE '||p_dest_table_name||' (C1 NOT NULL,
275: C2,
276: C3,
277: C4,

Line 284: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');

280: BEGIN
281: EXECUTE IMMEDIATE l_stmt;
282: EXCEPTION
283: WHEN table_exists THEN
284: fnd_oam_debug.log(1, l_ctxt, 'Table already exists - dropping first.');
285: IF NOT DROP_TEST_TABLE(p_dest_table_name,
286: p_dest_owner) THEN
287: RETURN FALSE;
288: END IF;

Line 292: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

288: END IF;
289: --otherwise, try to create the table again
290: EXECUTE IMMEDIATE l_stmt;
291: WHEN OTHERS THEN
292: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
293: RETURN FALSE;
294: END;
295:
296: COMMIT;

Line 300: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

296: COMMIT;
297: RETURN TRUE;
298: EXCEPTION
299: WHEN OTHERS THEN
300: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
301: ROLLBACK;
302: RETURN FALSE;
303: END;
304:

Line 322: fnd_oam_debug.log(1, l_ctxt, 'Validating table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');

318: l_c3_bad_count NUMBER;
319: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');
320: l_c4_bad_count NUMBER;
321: BEGIN
322: fnd_oam_debug.log(1, l_ctxt, 'Validating table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');
323:
324: --check the row count
325: l_stmt := 'SELECT COUNT(ROWID) FROM '||p_owner||'.'||p_table_name;
326: BEGIN

Line 330: fnd_oam_debug.log(1, l_ctxt, 'Error selecting row count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

326: BEGIN
327: EXECUTE IMMEDIATE l_stmt INTO l_row_count;
328: EXCEPTION
329: WHEN OTHERS THEN
330: fnd_oam_debug.log(1, l_ctxt, 'Error selecting row count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
331: RETURN FALSE;
332: END;
333: IF l_row_count IS NULL OR l_row_count <> p_num_rows THEN
334: fnd_oam_debug.log(6, l_ctxt, 'Queried row count('||l_row_count||') unequal to expected row count('||p_num_rows||')');

Line 334: fnd_oam_debug.log(6, l_ctxt, 'Queried row count('||l_row_count||') unequal to expected row count('||p_num_rows||')');

330: fnd_oam_debug.log(1, l_ctxt, 'Error selecting row count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
331: RETURN FALSE;
332: END;
333: IF l_row_count IS NULL OR l_row_count <> p_num_rows THEN
334: fnd_oam_debug.log(6, l_ctxt, 'Queried row count('||l_row_count||') unequal to expected row count('||p_num_rows||')');
335: RETURN FALSE;
336: END IF;
337:
338: --check that the sum of C2 is the row count

Line 344: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C2 sum: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

340: BEGIN
341: EXECUTE IMMEDIATE l_stmt INTO l_c2_sum;
342: EXCEPTION
343: WHEN OTHERS THEN
344: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C2 sum: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
345: RETURN FALSE;
346: END;
347: IF l_c2_sum IS NULL OR l_c2_sum <> p_num_rows THEN
348: fnd_oam_debug.log(6, l_ctxt, 'Column C2 has sum('||l_c2_sum||'), should be equal to the row count('||p_num_rows||')');

Line 348: fnd_oam_debug.log(6, l_ctxt, 'Column C2 has sum('||l_c2_sum||'), should be equal to the row count('||p_num_rows||')');

344: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C2 sum: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
345: RETURN FALSE;
346: END;
347: IF l_c2_sum IS NULL OR l_c2_sum <> p_num_rows THEN
348: fnd_oam_debug.log(6, l_ctxt, 'Column C2 has sum('||l_c2_sum||'), should be equal to the row count('||p_num_rows||')');
349: RETURN FALSE;
350: END IF;
351:
352: --check that C3 has the proper setup

Line 358: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C3 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

354: BEGIN
355: EXECUTE IMMEDIATE l_stmt INTO l_c3_bad_count;
356: EXCEPTION
357: WHEN OTHERS THEN
358: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C3 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
359: RETURN FALSE;
360: END;
361: IF l_c3_bad_count IS NULL OR l_c3_bad_count <> 0 THEN
362: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C3 values.');

Line 362: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C3 values.');

358: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C3 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
359: RETURN FALSE;
360: END;
361: IF l_c3_bad_count IS NULL OR l_c3_bad_count <> 0 THEN
362: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C3 values.');
363: RETURN FALSE;
364: END IF;
365:
366: --check that C4 has the proper setup

Line 372: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C4 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

368: BEGIN
369: EXECUTE IMMEDIATE l_stmt INTO l_c4_bad_count USING l_c4;
370: EXCEPTION
371: WHEN OTHERS THEN
372: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C4 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
373: RETURN FALSE;
374: END;
375: IF l_c4_bad_count IS NULL OR l_c4_bad_count <> 0 THEN
376: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C4 values.');

Line 376: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C4 values.');

372: fnd_oam_debug.log(1, l_ctxt, 'Error selecting C4 bad count: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
373: RETURN FALSE;
374: END;
375: IF l_c4_bad_count IS NULL OR l_c4_bad_count <> 0 THEN
376: fnd_oam_debug.log(6, l_ctxt, 'Found ('||l_c3_bad_count||') rows with invalid C4 values.');
377: RETURN FALSE;
378: END IF;
379:
380: RETURN TRUE;

Line 383: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

379:
380: RETURN TRUE;
381: EXCEPTION
382: WHEN OTHERS THEN
383: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
384: RETURN FALSE;
385: END;
386:
387: -- Private, helper to the VALIDATE_* procedures to make sure diagnostic tests didn't modify the contents of

Line 410: fnd_oam_debug.log(1, l_ctxt, 'Validating Arg Values for table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');

406: l_c3_bad_count NUMBER;
407: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');
408: l_c4_bad_count NUMBER;
409: BEGIN
410: fnd_oam_debug.log(1, l_ctxt, 'Validating Arg Values for table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');
411:
412: --check the c2 value
413: BEGIN
414: IF p_using_splitting THEN

Line 426: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C2 Sum is incorrect: '||l_valid_value_flag);

422: INTO l_valid_value_flag, l_canonical_value
423: FROM fnd_oam_dscram_args_b
424: WHERE arg_id = p_c2_arg_id;
425: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
426: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C2 Sum is incorrect: '||l_valid_value_flag);
427: RETURN FALSE;
428: END IF;
429: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
430: END IF;

Line 433: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

429: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
430: END IF;
431: EXCEPTION
432: WHEN OTHERS THEN
433: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
434: RETURN FALSE;
435: END;
436: IF l_c2_sum IS NULL OR l_c2_sum <> p_c2_target_sum THEN
437: fnd_oam_debug.log(6, l_ctxt, 'C2 Sum('||l_c2_sum||') not equal to target value('||p_c2_target_sum||')');

Line 437: fnd_oam_debug.log(6, l_ctxt, 'C2 Sum('||l_c2_sum||') not equal to target value('||p_c2_target_sum||')');

433: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
434: RETURN FALSE;
435: END;
436: IF l_c2_sum IS NULL OR l_c2_sum <> p_c2_target_sum THEN
437: fnd_oam_debug.log(6, l_ctxt, 'C2 Sum('||l_c2_sum||') not equal to target value('||p_c2_target_sum||')');
438: RETURN FALSE;
439: END IF;
440:
441: --check the c3 val

Line 456: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C3 Bad Count is incorrect: '||l_valid_value_flag);

452: INTO l_valid_value_flag, l_canonical_value
453: FROM fnd_oam_dscram_args_b
454: WHERE arg_id = p_c3_arg_id;
455: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
456: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C3 Bad Count is incorrect: '||l_valid_value_flag);
457: RETURN FALSE;
458: END IF;
459: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
460: END IF;

Line 463: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C3 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

459: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
460: END IF;
461: EXCEPTION
462: WHEN OTHERS THEN
463: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C3 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
464: RETURN FALSE;
465: END;
466: IF l_c3_bad_count IS NULL OR l_c3_bad_count <> 0 THEN
467: fnd_oam_debug.log(6, l_ctxt, 'C3 Bad Count('||l_c3_bad_count||') not equal to zero.');

Line 467: fnd_oam_debug.log(6, l_ctxt, 'C3 Bad Count('||l_c3_bad_count||') not equal to zero.');

463: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C3 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
464: RETURN FALSE;
465: END;
466: IF l_c3_bad_count IS NULL OR l_c3_bad_count <> 0 THEN
467: fnd_oam_debug.log(6, l_ctxt, 'C3 Bad Count('||l_c3_bad_count||') not equal to zero.');
468: RETURN FALSE;
469: END IF;
470: END IF;
471:

Line 487: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C4 Bad Count is incorrect: '||l_valid_value_flag);

483: INTO l_valid_value_flag, l_canonical_value
484: FROM fnd_oam_dscram_args_b
485: WHERE arg_id = p_c4_arg_id;
486: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
487: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C4 Bad Count is incorrect: '||l_valid_value_flag);
488: RETURN FALSE;
489: END IF;
490: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
491: END IF;

Line 494: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C4 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

490: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
491: END IF;
492: EXCEPTION
493: WHEN OTHERS THEN
494: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C4 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
495: RETURN FALSE;
496: END;
497: IF l_c4_bad_count IS NULL OR l_c4_bad_count <> 0 THEN
498: fnd_oam_debug.log(6, l_ctxt, 'C4 Bad Count('||l_c4_bad_count||') not equal to zero.');

Line 498: fnd_oam_debug.log(6, l_ctxt, 'C4 Bad Count('||l_c4_bad_count||') not equal to zero.');

494: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for C4 bad count: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
495: RETURN FALSE;
496: END;
497: IF l_c4_bad_count IS NULL OR l_c4_bad_count <> 0 THEN
498: fnd_oam_debug.log(6, l_ctxt, 'C4 Bad Count('||l_c4_bad_count||') not equal to zero.');
499: RETURN FALSE;
500: END IF;
501: END IF;
502:

Line 506: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

502:
503: RETURN TRUE;
504: EXCEPTION
505: WHEN OTHERS THEN
506: fnd_oam_debug.log(6, l_ctxt, 'Unhandled exception: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
507: RETURN FALSE;
508: END;
509:
510: --used by the SYNC functions to coordinate on a name for the finish message pipe

Line 543: fnd_oam_debug.log(1, l_ctxt, 'Removed message from run pipe.');

539: WHILE TRUE LOOP
540: l_retval := DBMS_PIPE.RECEIVE_MESSAGE(l_run_pipe,
541: 0);
542: IF l_retval = 0 THEN
543: fnd_oam_debug.log(1, l_ctxt, 'Removed message from run pipe.');
544: ELSE
545: EXIT;
546: END IF;
547: END LOOP;

Line 552: fnd_oam_debug.log(1, l_ctxt, 'Removed message from run ack pipe.');

548: WHILE TRUE LOOP
549: l_retval := DBMS_PIPE.RECEIVE_MESSAGE(l_run_ack_pipe,
550: 0);
551: IF l_retval = 0 THEN
552: fnd_oam_debug.log(1, l_ctxt, 'Removed message from run ack pipe.');
553: ELSE
554: EXIT;
555: END IF;
556: END LOOP;

Line 561: fnd_oam_debug.log(6, l_ctxt, 'Error while cleaning pipes: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');

557:
558: RETURN TRUE;
559: EXCEPTION
560: WHEN OTHERS THEN
561: fnd_oam_debug.log(6, l_ctxt, 'Error while cleaning pipes: Error Code('||SQLCODE||'), Message: "'||SQLERRM||'"');
562: RETURN FALSE;
563: END;
564:
565: --Public

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

570: l_ids DBMS_SQL.NUMBER_TABLE;
571: k NUMBER;
572: l_retbool BOOLEAN;
573: BEGIN
574: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
575:
576: --query out all runs in the diagnostic space
577: SELECT run_id
578: BULK COLLECT INTO l_ids

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

579: FROM fnd_oam_dscram_runs_b
580: WHERE run_id between 0 and 999;
581:
582: IF SQL%NOTFOUND THEN
583: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
584: x_verdict := FND_API.G_TRUE;
585: RETURN;
586: END IF;
587:

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

598: END IF;
599: k := l_ids.NEXT(k);
600: END LOOP;
601:
602: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
603: IF l_retbool THEN
604: x_verdict := FND_API.G_TRUE;
605: ELSE
606: x_verdict := FND_API.G_FALSE;

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

606: x_verdict := FND_API.G_FALSE;
607: END IF;
608: EXCEPTION
609: WHEN OTHERS THEN
610: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
611: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
612: x_verdict := FND_API.G_FALSE;
613: RETURN;
614: END;

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

607: END IF;
608: EXCEPTION
609: WHEN OTHERS THEN
610: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
611: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
612: x_verdict := FND_API.G_FALSE;
613: RETURN;
614: END;
615:

Line 628: fnd_oam_debug.log(1, l_ctxt, 'Deleting Global Arg: '||l_arg_name);

624: BEGIN
625: k := p_global_arg_names.FIRST;
626: WHILE k IS NOT NULL LOOP
627: l_arg_name := p_global_arg_names(k);
628: fnd_oam_debug.log(1, l_ctxt, 'Deleting Global Arg: '||l_arg_name);
629: DELETE FROM fnd_oam_dscram_args_b
630: WHERE parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_GLOBAL
631: AND arg_name = l_arg_name
632: RETURNING arg_id INTO l_arg_id;

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

638: END LOOP;
639: RETURN TRUE;
640: EXCEPTION
641: WHEN OTHERS THEN
642: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
643: RETURN FALSE;
644: END;
645:
646: --after a run is finished, validate that the dml entity completed as expected.

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

657:
658: k NUMBER;
659: l_retbool BOOLEAN;
660: BEGIN
661: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
662:
663: --query out the run's final status
664: SELECT finished_ret_sts, rows_processed
665: INTO l_status, l_rows_processed

Line 671: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

667: WHERE dml_id = p_dml_id;
668:
669: --status check
670: IF l_status IS NULL OR l_status <> p_target_status THEN
671: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
672: RETURN FALSE;
673: END IF;
674:
675: --check that we processed all the rows

Line 677: fnd_oam_debug.log(6, l_ctxt, 'DML ID('||p_dml_id||'), processed '||l_rows_processed||' rows, should have been '||p_target_rows);

673: END IF;
674:
675: --check that we processed all the rows
676: IF p_target_rows >= 0 AND (l_rows_processed IS NULL OR l_rows_processed <> p_target_rows) THEN
677: fnd_oam_debug.log(6, l_ctxt, 'DML ID('||p_dml_id||'), processed '||l_rows_processed||' rows, should have been '||p_target_rows);
678: RETURN FALSE;
679: END IF;
680:
681: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

677: fnd_oam_debug.log(6, l_ctxt, 'DML ID('||p_dml_id||'), processed '||l_rows_processed||' rows, should have been '||p_target_rows);
678: RETURN FALSE;
679: END IF;
680:
681: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
682: RETURN TRUE;
683: EXCEPTION
684: WHEN NO_DATA_FOUND THEN
685: fnd_oam_debug.log(6, l_ctxt, 'DML with DML ID ('||p_dml_id||') not found.');

Line 685: fnd_oam_debug.log(6, l_ctxt, 'DML with DML ID ('||p_dml_id||') not found.');

681: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
682: RETURN TRUE;
683: EXCEPTION
684: WHEN NO_DATA_FOUND THEN
685: fnd_oam_debug.log(6, l_ctxt, 'DML with DML ID ('||p_dml_id||') not found.');
686: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
687: RETURN FALSE;
688: WHEN OTHERS THEN
689: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

682: RETURN TRUE;
683: EXCEPTION
684: WHEN NO_DATA_FOUND THEN
685: fnd_oam_debug.log(6, l_ctxt, 'DML with DML ID ('||p_dml_id||') not found.');
686: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
687: RETURN FALSE;
688: WHEN OTHERS THEN
689: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
690: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

685: fnd_oam_debug.log(6, l_ctxt, 'DML with DML ID ('||p_dml_id||') not found.');
686: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
687: RETURN FALSE;
688: WHEN OTHERS THEN
689: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
690: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
691: RETURN FALSE;
692: END;
693:

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

686: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
687: RETURN FALSE;
688: WHEN OTHERS THEN
689: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
690: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
691: RETURN FALSE;
692: END;
693:
694: --after a run is finished, validate that the dml entity completed as expected.

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

703:
704: k NUMBER;
705: l_retbool BOOLEAN;
706: BEGIN
707: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
708:
709: --query out the run's final status
710: SELECT finished_ret_sts
711: INTO l_status

Line 717: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

713: WHERE plsql_id = p_plsql_id;
714:
715: --status check
716: IF l_status IS NULL OR l_status <> p_target_status THEN
717: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
718: RETURN FALSE;
719: END IF;
720:
721: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

717: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
718: RETURN FALSE;
719: END IF;
720:
721: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
722: RETURN TRUE;
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: fnd_oam_debug.log(6, l_ctxt, 'PLSQL with PLSQL ID ('||p_plsql_id||') not found.');

Line 725: fnd_oam_debug.log(6, l_ctxt, 'PLSQL with PLSQL ID ('||p_plsql_id||') not found.');

721: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
722: RETURN TRUE;
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: fnd_oam_debug.log(6, l_ctxt, 'PLSQL with PLSQL ID ('||p_plsql_id||') not found.');
726: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
727: RETURN FALSE;
728: WHEN OTHERS THEN
729: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

722: RETURN TRUE;
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: fnd_oam_debug.log(6, l_ctxt, 'PLSQL with PLSQL ID ('||p_plsql_id||') not found.');
726: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
727: RETURN FALSE;
728: WHEN OTHERS THEN
729: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
730: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

725: fnd_oam_debug.log(6, l_ctxt, 'PLSQL with PLSQL ID ('||p_plsql_id||') not found.');
726: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
727: RETURN FALSE;
728: WHEN OTHERS THEN
729: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
730: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
731: RETURN FALSE;
732: END;
733:

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

726: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
727: RETURN FALSE;
728: WHEN OTHERS THEN
729: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
730: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
731: RETURN FALSE;
732: END;
733:
734: --after a run is finished, validate that the unit entity completed as expected.

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

743: l_workers_assigned NUMBER;
744: k NUMBER;
745: l_retbool BOOLEAN;
746: BEGIN
747: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
748:
749: --query out the run's final status
750: SELECT unit_status, workers_assigned
751: INTO l_status, l_workers_assigned

Line 760: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

756: IF (l_status IS NULL AND p_target_status IS NOT NULL) OR
757: (l_status IS NOT NULL AND p_target_status IS NULL) OR
758: l_status <> p_target_status THEN
759:
760: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
761: RETURN FALSE;
762: END IF;
763:
764: --worker check

Line 766: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);

762: END IF;
763:
764: --worker check
765: IF l_workers_assigned IS NULL OR l_workers_assigned > 0 THEN
766: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);
767: RETURN FALSE;
768: END IF;
769:
770: --check the status row

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

769:
770: --check the status row
771: --skip for now
772:
773: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
774: RETURN TRUE;
775: EXCEPTION
776: WHEN NO_DATA_FOUND THEN
777: fnd_oam_debug.log(6, l_ctxt, 'Unit with Unit ID ('||p_unit_id||') not found.');

Line 777: fnd_oam_debug.log(6, l_ctxt, 'Unit with Unit ID ('||p_unit_id||') not found.');

773: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
774: RETURN TRUE;
775: EXCEPTION
776: WHEN NO_DATA_FOUND THEN
777: fnd_oam_debug.log(6, l_ctxt, 'Unit with Unit ID ('||p_unit_id||') not found.');
778: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
779: RETURN FALSE;
780: WHEN OTHERS THEN
781: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

774: RETURN TRUE;
775: EXCEPTION
776: WHEN NO_DATA_FOUND THEN
777: fnd_oam_debug.log(6, l_ctxt, 'Unit with Unit ID ('||p_unit_id||') not found.');
778: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
779: RETURN FALSE;
780: WHEN OTHERS THEN
781: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
782: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

777: fnd_oam_debug.log(6, l_ctxt, 'Unit with Unit ID ('||p_unit_id||') not found.');
778: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
779: RETURN FALSE;
780: WHEN OTHERS THEN
781: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
782: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
783: RETURN FALSE;
784: END;
785:

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

778: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
779: RETURN FALSE;
780: WHEN OTHERS THEN
781: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
782: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
783: RETURN FALSE;
784: END;
785:
786: --after a run is finished, validate that the task entity completed as expected.

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

795: l_workers_assigned NUMBER;
796: k NUMBER;
797: l_retbool BOOLEAN;
798: BEGIN
799: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
800:
801: --query out the run's final status
802: SELECT task_status, workers_assigned
803: INTO l_status, l_workers_assigned

Line 809: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

805: WHERE task_id = p_task_id;
806:
807: --status check
808: IF l_status IS NULL OR l_status <> p_target_status THEN
809: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
810: RETURN FALSE;
811: END IF;
812:
813: --worker check

Line 815: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);

811: END IF;
812:
813: --worker check
814: IF l_workers_assigned IS NULL OR l_workers_assigned > 0 THEN
815: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);
816: RETURN FALSE;
817: END IF;
818:
819: --check the status row

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

818:
819: --check the status row
820: --skip for now
821:
822: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
823: RETURN TRUE;
824: EXCEPTION
825: WHEN NO_DATA_FOUND THEN
826: fnd_oam_debug.log(6, l_ctxt, 'Task with Task ID ('||p_task_id||') not found.');

Line 826: fnd_oam_debug.log(6, l_ctxt, 'Task with Task ID ('||p_task_id||') not found.');

822: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
823: RETURN TRUE;
824: EXCEPTION
825: WHEN NO_DATA_FOUND THEN
826: fnd_oam_debug.log(6, l_ctxt, 'Task with Task ID ('||p_task_id||') not found.');
827: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
828: RETURN FALSE;
829: WHEN OTHERS THEN
830: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

823: RETURN TRUE;
824: EXCEPTION
825: WHEN NO_DATA_FOUND THEN
826: fnd_oam_debug.log(6, l_ctxt, 'Task with Task ID ('||p_task_id||') not found.');
827: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
828: RETURN FALSE;
829: WHEN OTHERS THEN
830: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
831: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

826: fnd_oam_debug.log(6, l_ctxt, 'Task with Task ID ('||p_task_id||') not found.');
827: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
828: RETURN FALSE;
829: WHEN OTHERS THEN
830: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
831: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
832: RETURN FALSE;
833: END;
834:

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

827: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
828: RETURN FALSE;
829: WHEN OTHERS THEN
830: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
831: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
832: RETURN FALSE;
833: END;
834:
835: --after a run is finished, validate that the bundle entity completed as expected.

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

844: l_workers_assigned NUMBER;
845: k NUMBER;
846: l_retbool BOOLEAN;
847: BEGIN
848: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
849:
850: --query out the run's final status
851: SELECT bundle_status, workers_assigned
852: INTO l_status, l_workers_assigned

Line 859: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

855: AND bundle_id = p_bundle_id;
856:
857: --status check
858: IF l_status IS NULL OR l_status <> p_target_status THEN
859: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
860: RETURN FALSE;
861: END IF;
862:
863: --worker check

Line 865: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);

861: END IF;
862:
863: --worker check
864: IF l_workers_assigned IS NULL OR l_workers_assigned > 0 THEN
865: fnd_oam_debug.log(6, l_ctxt, 'Still has workers: '||l_workers_assigned);
866: RETURN FALSE;
867: END IF;
868:
869: --check the status row

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

868:
869: --check the status row
870: --skip for now
871:
872: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
873: RETURN TRUE;
874: EXCEPTION
875: WHEN NO_DATA_FOUND THEN
876: fnd_oam_debug.log(6, l_ctxt, 'Bundle with Run ID ('||p_run_id||') and Bundle ID ('||p_bundle_id||') not found.');

Line 876: fnd_oam_debug.log(6, l_ctxt, 'Bundle with Run ID ('||p_run_id||') and Bundle ID ('||p_bundle_id||') not found.');

872: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
873: RETURN TRUE;
874: EXCEPTION
875: WHEN NO_DATA_FOUND THEN
876: fnd_oam_debug.log(6, l_ctxt, 'Bundle with Run ID ('||p_run_id||') and Bundle ID ('||p_bundle_id||') not found.');
877: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
878: RETURN FALSE;
879: WHEN OTHERS THEN
880: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

873: RETURN TRUE;
874: EXCEPTION
875: WHEN NO_DATA_FOUND THEN
876: fnd_oam_debug.log(6, l_ctxt, 'Bundle with Run ID ('||p_run_id||') and Bundle ID ('||p_bundle_id||') not found.');
877: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
878: RETURN FALSE;
879: WHEN OTHERS THEN
880: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
881: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

876: fnd_oam_debug.log(6, l_ctxt, 'Bundle with Run ID ('||p_run_id||') and Bundle ID ('||p_bundle_id||') not found.');
877: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
878: RETURN FALSE;
879: WHEN OTHERS THEN
880: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
881: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
882: RETURN FALSE;
883: END;
884:

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

877: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
878: RETURN FALSE;
879: WHEN OTHERS THEN
880: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
881: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
882: RETURN FALSE;
883: END;
884:
885: --after a run is finished, validate that the run entity completed as expected. In this case

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

895: l_run_stat_id NUMBER;
896: k NUMBER;
897: l_retbool BOOLEAN;
898: BEGIN
899: --fnd_oam_debug.log(2, l_ctxt, 'ENTER');
900:
901: --query out the run's final status
902: SELECT run_status, last_run_stat_id
903: INTO l_status, l_run_stat_id

Line 909: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');

905: WHERE run_id = p_run_id;
906:
907: --status check
908: IF l_status IS NULL OR l_status <> p_target_status THEN
909: fnd_oam_debug.log(6, l_ctxt, 'Status incorrect: Current('||l_status||'), Target('||p_target_status||')');
910: RETURN FALSE;
911: END IF;
912:
913: --check the status row

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

912:
913: --check the status row
914: --skip for now
915:
916: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
917: x_run_stat_id := l_run_stat_id;
918: RETURN TRUE;
919: EXCEPTION
920: WHEN NO_DATA_FOUND THEN

Line 921: fnd_oam_debug.log(6, l_ctxt, 'Run ID ('||p_run_id||') not found.');

917: x_run_stat_id := l_run_stat_id;
918: RETURN TRUE;
919: EXCEPTION
920: WHEN NO_DATA_FOUND THEN
921: fnd_oam_debug.log(6, l_ctxt, 'Run ID ('||p_run_id||') not found.');
922: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
923: RETURN FALSE;
924: WHEN OTHERS THEN
925: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

918: RETURN TRUE;
919: EXCEPTION
920: WHEN NO_DATA_FOUND THEN
921: fnd_oam_debug.log(6, l_ctxt, 'Run ID ('||p_run_id||') not found.');
922: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
923: RETURN FALSE;
924: WHEN OTHERS THEN
925: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
926: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

921: fnd_oam_debug.log(6, l_ctxt, 'Run ID ('||p_run_id||') not found.');
922: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
923: RETURN FALSE;
924: WHEN OTHERS THEN
925: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
926: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
927: RETURN FALSE;
928: END;
929:

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

922: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
923: RETURN FALSE;
924: WHEN OTHERS THEN
925: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
926: --fnd_oam_debug.log(2, l_ctxt, 'EXIT');
927: RETURN FALSE;
928: END;
929:
930: -- Helper function to validate a single run, bundle, task.

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

947: l_id NUMBER;
948: k NUMBER;
949: l_count NUMBER;
950: BEGIN
951: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
952: fnd_oam_debug.log(1, l_ctxt, 'Unit ID: '||p_unit_id);
953:
954: --first validate the bundle
955: IF NOT VALIDATE_UNIT_SUCCESS(p_run_id,

Line 952: fnd_oam_debug.log(1, l_ctxt, 'Unit ID: '||p_unit_id);

948: k NUMBER;
949: l_count NUMBER;
950: BEGIN
951: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
952: fnd_oam_debug.log(1, l_ctxt, 'Unit ID: '||p_unit_id);
953:
954: --first validate the bundle
955: IF NOT VALIDATE_UNIT_SUCCESS(p_run_id,
956: p_unit_id,

Line 973: fnd_oam_debug.log(1, l_ctxt, 'Dml ID: '||l_ids(k));

969:
970: l_count := 0;
971: k := l_ids.FIRST;
972: WHILE k IS NOT NULL LOOP
973: fnd_oam_debug.log(1, l_ctxt, 'Dml ID: '||l_ids(k));
974: IF NOT VALIDATE_DML_SUCCESS(p_run_id,
975: l_ids(k),
976: p_dml_status,
977: p_num_dml_rows) THEN

Line 985: fnd_oam_debug.log(6, l_ctxt, 'Number of dmls found ('||l_count||') did not match the number expected ('||p_num_dmls||')');

981: k := l_ids.NEXT(k);
982: l_count := l_count + 1;
983: END LOOP;
984: IF (l_count IS NULL OR l_count <> p_num_dmls) THEN
985: fnd_oam_debug.log(6, l_ctxt, 'Number of dmls found ('||l_count||') did not match the number expected ('||p_num_dmls||')');
986: RAISE VALIDATE_FAILED;
987: END IF;
988: END IF;
989:

Line 1000: fnd_oam_debug.log(1, l_ctxt, 'Plsql ID: '||l_ids(k));

996:
997: l_count := 0;
998: k := l_ids.FIRST;
999: WHILE k IS NOT NULL LOOP
1000: fnd_oam_debug.log(1, l_ctxt, 'Plsql ID: '||l_ids(k));
1001: IF NOT VALIDATE_PLSQL_SUCCESS(p_run_id,
1002: l_ids(k),
1003: p_plsql_status) THEN
1004: RAISE VALIDATE_FAILED;

Line 1011: fnd_oam_debug.log(6, l_ctxt, 'Number of dmls found ('||l_count||') did not match the number expected ('||p_num_plsqls||')');

1007: k := l_ids.NEXT(k);
1008: l_count := l_count + 1;
1009: END LOOP;
1010: IF (l_count IS NULL OR l_count <> p_num_plsqls) THEN
1011: fnd_oam_debug.log(6, l_ctxt, 'Number of dmls found ('||l_count||') did not match the number expected ('||p_num_plsqls||')');
1012: RAISE VALIDATE_FAILED;
1013: END IF;
1014: END IF;
1015:

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

1012: RAISE VALIDATE_FAILED;
1013: END IF;
1014: END IF;
1015:
1016: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1017: RETURN TRUE;
1018: EXCEPTION
1019: WHEN VALIDATE_FAILED THEN
1020: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

1016: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1017: RETURN TRUE;
1018: EXCEPTION
1019: WHEN VALIDATE_FAILED THEN
1020: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1021: RETURN FALSE;
1022: WHEN OTHERS THEN
1023: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1024: RETURN FALSE;

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

1019: WHEN VALIDATE_FAILED THEN
1020: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1021: RETURN FALSE;
1022: WHEN OTHERS THEN
1023: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1024: RETURN FALSE;
1025: END;
1026:
1027: -- Helper function to validate a single run, bundle, task.

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

1047: l_id NUMBER;
1048: k NUMBER;
1049: l_count_units NUMBER;
1050: BEGIN
1051: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1052: fnd_oam_debug.log(1, l_ctxt, 'Task ID: '||p_task_id);
1053:
1054: --first validate the bundle
1055: IF NOT VALIDATE_TASK_SUCCESS(p_run_id,

Line 1052: fnd_oam_debug.log(1, l_ctxt, 'Task ID: '||p_task_id);

1048: k NUMBER;
1049: l_count_units NUMBER;
1050: BEGIN
1051: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1052: fnd_oam_debug.log(1, l_ctxt, 'Task ID: '||p_task_id);
1053:
1054: --first validate the bundle
1055: IF NOT VALIDATE_TASK_SUCCESS(p_run_id,
1056: p_task_id,

Line 1089: fnd_oam_debug.log(6, l_ctxt, 'Task ID('||p_task_id||'), Number of units found ('||l_count_units||') did not match the number expected ('||p_num_units||')');

1085: k := l_ids.NEXT(k);
1086: l_count_units := l_count_units + 1;
1087: END LOOP;
1088: IF p_num_units >= 0 AND (l_count_units IS NULL OR l_count_units <> p_num_units) THEN
1089: fnd_oam_debug.log(6, l_ctxt, 'Task ID('||p_task_id||'), Number of units found ('||l_count_units||') did not match the number expected ('||p_num_units||')');
1090: RAISE VALIDATE_FAILED;
1091: END IF;
1092: END IF;
1093:

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

1090: RAISE VALIDATE_FAILED;
1091: END IF;
1092: END IF;
1093:
1094: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1095: RETURN TRUE;
1096: EXCEPTION
1097: WHEN VALIDATE_FAILED THEN
1098: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

1094: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1095: RETURN TRUE;
1096: EXCEPTION
1097: WHEN VALIDATE_FAILED THEN
1098: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1099: RETURN FALSE;
1100: WHEN OTHERS THEN
1101: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1102: RETURN FALSE;

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

1097: WHEN VALIDATE_FAILED THEN
1098: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1099: RETURN FALSE;
1100: WHEN OTHERS THEN
1101: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1102: RETURN FALSE;
1103: END;
1104:
1105: -- Helper function to validate a single run, bundle, task.

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

1127: l_id NUMBER;
1128: k NUMBER;
1129: l_count_tasks NUMBER;
1130: BEGIN
1131: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1132: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);
1133:
1134: --first validate the bundle
1135: IF NOT VALIDATE_BUNDLE_SUCCESS(p_run_id,

Line 1132: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);

1128: k NUMBER;
1129: l_count_tasks NUMBER;
1130: BEGIN
1131: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1132: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);
1133:
1134: --first validate the bundle
1135: IF NOT VALIDATE_BUNDLE_SUCCESS(p_run_id,
1136: p_bundle_id,

Line 1170: fnd_oam_debug.log(6, l_ctxt, 'Bundle ID('||p_bundle_id||'), Number of tasks found ('||l_count_tasks||') did not match the number expected ('||p_num_tasks||')');

1166: k := l_ids.NEXT(k);
1167: l_count_tasks := l_count_tasks + 1;
1168: END LOOP;
1169: IF p_num_tasks >= 0 AND (l_count_tasks IS NULL OR l_count_tasks <> p_num_tasks) THEN
1170: fnd_oam_debug.log(6, l_ctxt, 'Bundle ID('||p_bundle_id||'), Number of tasks found ('||l_count_tasks||') did not match the number expected ('||p_num_tasks||')');
1171: RAISE VALIDATE_FAILED;
1172: END IF;
1173: END IF;
1174:

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

1171: RAISE VALIDATE_FAILED;
1172: END IF;
1173: END IF;
1174:
1175: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1176: RETURN TRUE;
1177: EXCEPTION
1178: WHEN VALIDATE_FAILED THEN
1179: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

1175: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1176: RETURN TRUE;
1177: EXCEPTION
1178: WHEN VALIDATE_FAILED THEN
1179: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1180: RETURN FALSE;
1181: WHEN OTHERS THEN
1182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1183: RETURN FALSE;

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

1178: WHEN VALIDATE_FAILED THEN
1179: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1180: RETURN FALSE;
1181: WHEN OTHERS THEN
1182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1183: RETURN FALSE;
1184: END;
1185:
1186: -- Helper function to validate a single run, bundle, task.

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

1207: l_id NUMBER;
1208: k NUMBER;
1209: l_count_bundles NUMBER;
1210: BEGIN
1211: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1212: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);
1213:
1214: --before doing any work, rollback the current transaction in case some state didn't get comitted.
1215: ROLLBACK;

Line 1212: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);

1208: k NUMBER;
1209: l_count_bundles NUMBER;
1210: BEGIN
1211: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1212: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);
1213:
1214: --before doing any work, rollback the current transaction in case some state didn't get comitted.
1215: ROLLBACK;
1216:

Line 1255: fnd_oam_debug.log(6, l_ctxt, 'Run ID('||p_run_id||'), Number of bundles found ('||l_count_bundles||') did not match the number expected ('||p_num_bundles||')');

1251: k := l_ids.NEXT(k);
1252: l_count_bundles := l_count_bundles + 1;
1253: END LOOP;
1254: IF p_num_bundles >= 0 AND (l_count_bundles IS NULL OR l_count_bundles <> p_num_bundles) THEN
1255: fnd_oam_debug.log(6, l_ctxt, 'Run ID('||p_run_id||'), Number of bundles found ('||l_count_bundles||') did not match the number expected ('||p_num_bundles||')');
1256: RAISE VALIDATE_FAILED;
1257: END IF;
1258: END IF;
1259:

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

1256: RAISE VALIDATE_FAILED;
1257: END IF;
1258: END IF;
1259:
1260: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1261: RETURN TRUE;
1262: EXCEPTION
1263: WHEN VALIDATE_FAILED THEN
1264: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

1260: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1261: RETURN TRUE;
1262: EXCEPTION
1263: WHEN VALIDATE_FAILED THEN
1264: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1265: RETURN FALSE;
1266: WHEN OTHERS THEN
1267: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1268: RETURN FALSE;

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

1263: WHEN VALIDATE_FAILED THEN
1264: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1265: RETURN FALSE;
1266: WHEN OTHERS THEN
1267: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1268: RETURN FALSE;
1269: END;
1270:
1271: -- create an argument entry, typically attached to a run or dml

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

1288: IS
1289: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_ARG';
1290: l_retval NUMBER;
1291: BEGIN
1292: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1293:
1294: INSERT INTO FND_OAM_DSCRAM_ARGS_B (ARG_ID,
1295: ARG_NAME,
1296: PARENT_TYPE,

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

1358: FND_GLOBAL.USER_ID,
1359: SYSDATE,
1360: FND_GLOBAL.USER_ID);
1361:
1362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1363: x_arg_id := l_retval;
1364: RETURN TRUE;
1365: EXCEPTION
1366: WHEN OTHERS THEN

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

1363: x_arg_id := l_retval;
1364: RETURN TRUE;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1368: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1369: x_arg_id := NULL;
1370: RETURN FALSE;
1371: END;

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

1364: RETURN TRUE;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1368: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1369: x_arg_id := NULL;
1370: RETURN FALSE;
1371: END;
1372:

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

1381: IS
1382: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_DML';
1383: l_retval NUMBER;
1384: BEGIN
1385: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1386:
1387: INSERT INTO FND_OAM_DSCRAM_DMLS (DML_ID,
1388: UNIT_ID,
1389: PRIORITY,

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

1409: SYSDATE,
1410: FND_GLOBAL.USER_ID)
1411: RETURNING DML_ID INTO l_retval;
1412:
1413: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1414: x_dml_id := l_retval;
1415: RETURN TRUE;
1416: EXCEPTION
1417: WHEN OTHERS THEN

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

1414: x_dml_id := l_retval;
1415: RETURN TRUE;
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1419: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1420: x_dml_id := NULL;
1421: RETURN FALSE;
1422: END;

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

1415: RETURN TRUE;
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1419: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1420: x_dml_id := NULL;
1421: RETURN FALSE;
1422: END;
1423:

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

1431: IS
1432: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_PLSQL';
1433: l_retval NUMBER;
1434: BEGIN
1435: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1436:
1437: INSERT INTO FND_OAM_DSCRAM_PLSQLS (PLSQL_ID,
1438: UNIT_ID,
1439: PRIORITY,

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

1457: SYSDATE,
1458: FND_GLOBAL.USER_ID)
1459: RETURNING PLSQL_ID INTO l_retval;
1460:
1461: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1462: x_plsql_id := l_retval;
1463: RETURN TRUE;
1464: EXCEPTION
1465: WHEN OTHERS THEN

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

1462: x_plsql_id := l_retval;
1463: RETURN TRUE;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1467: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1468: x_plsql_id := NULL;
1469: RETURN FALSE;
1470: END;

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

1463: RETURN TRUE;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1467: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1468: x_plsql_id := NULL;
1469: RETURN FALSE;
1470: END;
1471:

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

1490: IS
1491: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_UNIT';
1492: l_retval NUMBER;
1493: BEGIN
1494: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1495:
1496: INSERT INTO FND_OAM_DSCRAM_UNITS (UNIT_ID,
1497: TASK_ID,
1498: CONCURRENT_GROUP_UNIT_ID,

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

1540: SYSDATE,
1541: FND_GLOBAL.USER_ID)
1542: RETURNING UNIT_ID INTO l_retval;
1543:
1544: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1545: x_unit_id := l_retval;
1546: RETURN TRUE;
1547: EXCEPTION
1548: WHEN OTHERS THEN

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

1545: x_unit_id := l_retval;
1546: RETURN TRUE;
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1550: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1551: x_unit_id := NULL;
1552: RETURN FALSE;
1553: END;

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

1546: RETURN TRUE;
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1550: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1551: x_unit_id := NULL;
1552: RETURN FALSE;
1553: END;
1554:

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

1564: IS
1565: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_TASK';
1566: l_retval NUMBER;
1567: BEGIN
1568: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1569:
1570: INSERT INTO FND_OAM_DSCRAM_TASKS (TASK_ID,
1571: BUNDLE_ID,
1572: TASK_STATUS,

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

1592: SYSDATE,
1593: FND_GLOBAL.USER_ID)
1594: RETURNING TASK_ID INTO l_retval;
1595:
1596: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1597: x_task_id := l_retval;
1598: RETURN TRUE;
1599: EXCEPTION
1600: WHEN OTHERS THEN

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

1597: x_task_id := l_retval;
1598: RETURN TRUE;
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1602: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1603: x_task_id := NULL;
1604: RETURN FALSE;
1605: END;

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

1598: RETURN TRUE;
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1602: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1603: x_task_id := NULL;
1604: RETURN FALSE;
1605: END;
1606:

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

1616: IS
1617: l_ctxt VARCHAR2(60) := PKG_NAME||'MAKE_BUNDLE';
1618: l_batch_size NUMBER := p_batch_size;
1619: BEGIN
1620: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1621:
1622: --if batch size was given as null, default it
1623: IF p_batch_size IS NULL THEN
1624: l_batch_size := 1000;

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

1652: FND_GLOBAL.USER_ID,
1653: SYSDATE,
1654: FND_GLOBAL.USER_ID);
1655:
1656: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1657: RETURN TRUE;
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

1656: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1657: RETURN TRUE;
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1661: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1662: RETURN FALSE;
1663: END;
1664:

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

1657: RETURN TRUE;
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1661: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1662: RETURN FALSE;
1663: END;
1664:
1665: --creates a RUN

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

1678: l_run_name VARCHAR2(30) := p_name;
1679: l_return_status VARCHAR2(6);
1680: l_return_msg VARCHAR2(2048);
1681: BEGIN
1682: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1683:
1684: --default the run name if not provided
1685: IF p_name IS NULL THEN
1686: l_run_name := 'Diagnostic Test '||to_char(SYSDATE, 'MI_SS');

Line 1751: fnd_oam_debug.log(6, l_ctxt, 'Failed to create run stat entry: '||l_return_msg);

1747: x_run_stat_id => l_run_stat_id,
1748: x_return_status => l_return_status,
1749: x_return_msg => l_return_msg);
1750: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1751: fnd_oam_debug.log(6, l_ctxt, 'Failed to create run stat entry: '||l_return_msg);
1752: RETURN FALSE;
1753: END IF;
1754:
1755: --update the run with this run stat id

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

1756: UPDATE fnd_oam_dscram_runs_b
1757: SET last_run_stat_id = l_run_stat_id
1758: WHERE run_id = p_run_id;
1759:
1760: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1761: RETURN TRUE;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

1760: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1761: RETURN TRUE;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1765: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1766: RETURN FALSE;
1767: END;
1768:

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

1761: RETURN TRUE;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1765: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1766: RETURN FALSE;
1767: END;
1768:
1769: -- Helper init function to make a single run, bundle, task.

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

1778: IS
1779: l_ctxt VARCHAR2(60) := PKG_NAME||'INIT_SINGLE_TASK';
1780: l_task_id NUMBER;
1781: BEGIN
1782: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1783:
1784: --do the meat of creating a run, bundle, and task
1785: IF NOT MAKE_RUN(p_run_id,
1786: p_name => B_DIAG_RUN_NAME_PREFIX||p_testnum) THEN

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

1798: x_task_id => l_task_id) THEN
1799: RAISE INIT_FAILED;
1800: END IF;
1801:
1802: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1803: x_task_id := l_task_id;
1804: RETURN TRUE;
1805: EXCEPTION
1806: WHEN INIT_FAILED THEN

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

1803: x_task_id := l_task_id;
1804: RETURN TRUE;
1805: EXCEPTION
1806: WHEN INIT_FAILED THEN
1807: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1808: x_task_id := NULL;
1809: RETURN TRUE;
1810: WHEN OTHERS THEN
1811: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

1807: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1808: x_task_id := NULL;
1809: RETURN TRUE;
1810: WHEN OTHERS THEN
1811: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1812: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1813: x_task_id := NULL;
1814: RETURN FALSE;
1815: END;

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

1808: x_task_id := NULL;
1809: RETURN TRUE;
1810: WHEN OTHERS THEN
1811: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1812: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1813: x_task_id := NULL;
1814: RETURN FALSE;
1815: END;
1816:

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

1828: l_ctxt VARCHAR2(60) := PKG_NAME||'INIT_SINGLE_DML_UNIT';
1829: l_task_id NUMBER;
1830: l_unit_id NUMBER;
1831: BEGIN
1832: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1833:
1834: --make the run,bundle,task
1835: IF NOT INIT_SINGLE_TASK(p_run_id,
1836: p_bundle_id,

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

1846: x_unit_id => l_unit_id) THEN
1847: RAISE INIT_FAILED;
1848: END IF;
1849:
1850: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1851: x_task_id := l_task_id;
1852: x_unit_id := l_unit_id;
1853: RETURN TRUE;
1854: EXCEPTION

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

1852: x_unit_id := l_unit_id;
1853: RETURN TRUE;
1854: EXCEPTION
1855: WHEN INIT_FAILED THEN
1856: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1857: x_task_id := NULL;
1858: x_unit_id := NULL;
1859: RETURN TRUE;
1860: WHEN OTHERS THEN

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

1857: x_task_id := NULL;
1858: x_unit_id := NULL;
1859: RETURN TRUE;
1860: WHEN OTHERS THEN
1861: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1862: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1863: x_task_id := NULL;
1864: x_unit_id := NULL;
1865: RETURN FALSE;

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

1858: x_unit_id := NULL;
1859: RETURN TRUE;
1860: WHEN OTHERS THEN
1861: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1862: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1863: x_task_id := NULL;
1864: x_unit_id := NULL;
1865: RETURN FALSE;
1866: END;

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

1891: EXCEPTION
1892: WHEN NO_DATA_FOUND THEN
1893: RETURN TRUE;
1894: WHEN OTHERS THEN
1895: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1896: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1897: RETURN FALSE;
1898: END;
1899:

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

1892: WHEN NO_DATA_FOUND THEN
1893: RETURN TRUE;
1894: WHEN OTHERS THEN
1895: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1896: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1897: RETURN FALSE;
1898: END;
1899:
1900: --called by EXECUTE_TEST to sync the workers at the end of each run so that

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

1914: l_msg_count NUMBER;
1915: l_target_msg_count NUMBER;
1916: l_retbool BOOLEAN;
1917: BEGIN
1918: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1919:
1920: l_retbool := TRUE;
1921: --different behavior depending on whether we're the initializing worker or not
1922: IF p_did_init THEN

Line 1930: fnd_oam_debug.log(6, l_ctxt, 'Failed to receive message: '||l_retval);

1926: WHILE l_msg_count < l_target_msg_count LOOP
1927: l_retval := DBMS_PIPE.RECEIVE_MESSAGE(l_pipename,
1928: B_MAX_WAIT);
1929: IF l_retval <> 0 THEN
1930: fnd_oam_debug.log(6, l_ctxt, 'Failed to receive message: '||l_retval);
1931: RAISE SYNC_FAILED;
1932: END IF;
1933:
1934: --get the message, update the overall status if a worker failed

Line 1956: fnd_oam_debug.log(6, l_ctxt, 'Failed to send message: '||l_retval);

1952: END IF;
1953: l_retval := DBMS_PIPE.SEND_MESSAGE(l_pipename,
1954: B_MAX_WAIT);
1955: IF l_retval <> 0 THEN
1956: fnd_oam_debug.log(6, l_ctxt, 'Failed to send message: '||l_retval);
1957: RAISE SYNC_FAILED;
1958: END IF;
1959:
1960: --now block waiting for an ack with the final status of the test

Line 1965: fnd_oam_debug.log(6, l_ctxt, 'Failed to receive ACK: '||l_retval);

1961: l_ack_pipename := MAKE_RUN_ACK_PIPE_NAME(p_run_id);
1962: l_retval := DBMS_PIPE.RECEIVE_MESSAGE(l_ack_pipename,
1963: B_MAX_WAIT);
1964: IF l_retval <> 0 THEN
1965: fnd_oam_debug.log(6, l_ctxt, 'Failed to receive ACK: '||l_retval);
1966: RAISE SYNC_FAILED;
1967: END IF;
1968: DBMS_PIPE.UNPACK_MESSAGE(l_msg);
1969: l_retbool := (l_msg = FND_API.G_TRUE);

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

1968: DBMS_PIPE.UNPACK_MESSAGE(l_msg);
1969: l_retbool := (l_msg = FND_API.G_TRUE);
1970: END IF;
1971:
1972: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1973: RETURN l_retbool;
1974: EXCEPTION
1975: WHEN SYNC_FAILED THEN
1976: RAISE SYNC_FAILED;

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

1974: EXCEPTION
1975: WHEN SYNC_FAILED THEN
1976: RAISE SYNC_FAILED;
1977: WHEN OTHERS THEN
1978: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1979: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1980: RETURN FALSE;
1981: END;
1982:

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

1975: WHEN SYNC_FAILED THEN
1976: RAISE SYNC_FAILED;
1977: WHEN OTHERS THEN
1978: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1979: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1980: RETURN FALSE;
1981: END;
1982:
1983: --used by the initializing worker to send acks to the other workers with the final status

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

1991: l_ack_pipename VARCHAR2(30) := MAKE_RUN_ACK_PIPE_NAME(p_run_id);
1992: k NUMBER := 0;
1993: l_num_msgs NUMBER := p_num_workers - 1;
1994: BEGIN
1995: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1996:
1997: --prep the ack message
1998: IF p_final_test_success THEN
1999: l_msg := FND_API.G_TRUE;

Line 2010: fnd_oam_debug.log(6, l_ctxt, 'Failed to send ack message: '||l_retval);

2006: DBMS_PIPE.PACK_MESSAGE(l_msg);
2007: l_retval := DBMS_PIPE.SEND_MESSAGE(l_ack_pipename,
2008: B_MAX_WAIT);
2009: IF l_retval <> 0 THEN
2010: fnd_oam_debug.log(6, l_ctxt, 'Failed to send ack message: '||l_retval);
2011: RAISE SYNC_FAILED;
2012: END IF;
2013: k := k + 1;
2014: END LOOP;

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

2012: END IF;
2013: k := k + 1;
2014: END LOOP;
2015:
2016: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2017: EXCEPTION
2018: WHEN SYNC_FAILED THEN
2019: RAISE SYNC_FAILED;
2020: WHEN OTHERS THEN

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

2017: EXCEPTION
2018: WHEN SYNC_FAILED THEN
2019: RAISE SYNC_FAILED;
2020: WHEN OTHERS THEN
2021: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2022: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2023: END;
2024:
2025: --Helper to EXECUTE_TEST# functions to see if the run's been initialized yet, if it hasn't then it

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

2018: WHEN SYNC_FAILED THEN
2019: RAISE SYNC_FAILED;
2020: WHEN OTHERS THEN
2021: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2022: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2023: END;
2024:
2025: --Helper to EXECUTE_TEST# functions to see if the run's been initialized yet, if it hasn't then it
2026: --keeps the lock and returns to EXECUTE_ to do the init and release the lock.

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

2031: l_ctxt VARCHAR2(60) := PKG_NAME||'RUN_NEEDS_INIT';
2032: l_lock_handle VARCHAR2(128);
2033: l_retval NUMBER;
2034: BEGIN
2035: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2036: x_lock_handle := NULL;
2037:
2038: --lock the run
2039: IF NOT FND_OAM_DSCRAM_UTILS_PKG.LOCK_RUN(p_run_id,

Line 2041: fnd_oam_debug.log(1, l_ctxt, 'Failed to lock run.');

2037:
2038: --lock the run
2039: IF NOT FND_OAM_DSCRAM_UTILS_PKG.LOCK_RUN(p_run_id,
2040: l_lock_handle) THEN
2041: fnd_oam_debug.log(1, l_ctxt, 'Failed to lock run.');
2042: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2043: RETURN FALSE;
2044: END IF;
2045:

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

2038: --lock the run
2039: IF NOT FND_OAM_DSCRAM_UTILS_PKG.LOCK_RUN(p_run_id,
2040: l_lock_handle) THEN
2041: fnd_oam_debug.log(1, l_ctxt, 'Failed to lock run.');
2042: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2043: RETURN FALSE;
2044: END IF;
2045:
2046: --after getting the lock, see if the run's there

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

2052:
2053: --select suceeded, release and return
2054: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2055: IF l_retval <> 0 THEN
2056: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2057: END IF;
2058: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2059: RETURN FALSE;
2060: EXCEPTION

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

2054: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2055: IF l_retval <> 0 THEN
2056: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2057: END IF;
2058: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2059: RETURN FALSE;
2060: EXCEPTION
2061: WHEN NO_DATA_FOUND THEN
2062: x_lock_handle := l_lock_handle;

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

2059: RETURN FALSE;
2060: EXCEPTION
2061: WHEN NO_DATA_FOUND THEN
2062: x_lock_handle := l_lock_handle;
2063: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2064: RETURN TRUE;
2065: END;
2066:
2067: --shouldn't get here

Line 2068: fnd_oam_debug.log(1, l_ctxt, 'Bad spot?');

2064: RETURN TRUE;
2065: END;
2066:
2067: --shouldn't get here
2068: fnd_oam_debug.log(1, l_ctxt, 'Bad spot?');
2069: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2070: IF l_retval <> 0 THEN
2071: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2072: END IF;

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

2067: --shouldn't get here
2068: fnd_oam_debug.log(1, l_ctxt, 'Bad spot?');
2069: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2070: IF l_retval <> 0 THEN
2071: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2072: END IF;
2073: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2074: RETURN FALSE;
2075: EXCEPTION

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

2069: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2070: IF l_retval <> 0 THEN
2071: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2072: END IF;
2073: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2074: RETURN FALSE;
2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

2073: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2074: RETURN FALSE;
2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2078: --try to release the lock
2079: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2080: IF l_retval <> 0 THEN
2081: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);

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

2077: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2078: --try to release the lock
2079: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2080: IF l_retval <> 0 THEN
2081: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2082: END IF;
2083: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2084: RETURN FALSE;
2085: END;

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

2079: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2080: IF l_retval <> 0 THEN
2081: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2082: END IF;
2083: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2084: RETURN FALSE;
2085: END;
2086:
2087: --helper to the EXECUTE_TEST# functions

Line 2106: fnd_oam_debug.log(1, p_ctxt, 'Execute Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2102: px_worker_id => px_worker_id,
2103: x_return_status => x_return_status,
2104: x_return_msg => x_return_msg);
2105: l_end := DBMS_UTILITY.GET_TIME;
2106: fnd_oam_debug.log(1, p_ctxt, 'Execute Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2107: fnd_oam_debug.log(1, p_ctxt, 'Return Status: '||x_return_status);
2108: fnd_oam_debug.log(1, p_ctxt, 'Return Msg: "'||x_return_msg||'"');
2109:
2110: --figure out if we should return a success or failure

Line 2107: fnd_oam_debug.log(1, p_ctxt, 'Return Status: '||x_return_status);

2103: x_return_status => x_return_status,
2104: x_return_msg => x_return_msg);
2105: l_end := DBMS_UTILITY.GET_TIME;
2106: fnd_oam_debug.log(1, p_ctxt, 'Execute Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2107: fnd_oam_debug.log(1, p_ctxt, 'Return Status: '||x_return_status);
2108: fnd_oam_debug.log(1, p_ctxt, 'Return Msg: "'||x_return_msg||'"');
2109:
2110: --figure out if we should return a success or failure
2111: --allowable outputs, SUCCESS/PROCESSED

Line 2108: fnd_oam_debug.log(1, p_ctxt, 'Return Msg: "'||x_return_msg||'"');

2104: x_return_msg => x_return_msg);
2105: l_end := DBMS_UTILITY.GET_TIME;
2106: fnd_oam_debug.log(1, p_ctxt, 'Execute Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2107: fnd_oam_debug.log(1, p_ctxt, 'Return Status: '||x_return_status);
2108: fnd_oam_debug.log(1, p_ctxt, 'Return Msg: "'||x_return_msg||'"');
2109:
2110: --figure out if we should return a success or failure
2111: --allowable outputs, SUCCESS/PROCESSED
2112: RETURN x_return_status IN (FND_API.G_RET_STS_SUCCESS,

Line 2124: fnd_oam_debug.log(1, p_ctxt, 'Run ID: '||p_run_id);

2120: p_num_bundles IN NUMBER,
2121: p_num_workers IN NUMBER)
2122: IS
2123: BEGIN
2124: fnd_oam_debug.log(1, p_ctxt, 'Run ID: '||p_run_id);
2125: fnd_oam_debug.log(1, p_ctxt, 'Bundle ID: '||p_bundle_id);
2126: fnd_oam_debug.log(1, p_ctxt, 'Bundles: '||p_num_bundles);
2127: fnd_oam_debug.log(1, p_ctxt, 'Workers: '||p_num_workers);
2128: END;

Line 2125: fnd_oam_debug.log(1, p_ctxt, 'Bundle ID: '||p_bundle_id);

2121: p_num_workers IN NUMBER)
2122: IS
2123: BEGIN
2124: fnd_oam_debug.log(1, p_ctxt, 'Run ID: '||p_run_id);
2125: fnd_oam_debug.log(1, p_ctxt, 'Bundle ID: '||p_bundle_id);
2126: fnd_oam_debug.log(1, p_ctxt, 'Bundles: '||p_num_bundles);
2127: fnd_oam_debug.log(1, p_ctxt, 'Workers: '||p_num_workers);
2128: END;
2129:

Line 2126: fnd_oam_debug.log(1, p_ctxt, 'Bundles: '||p_num_bundles);

2122: IS
2123: BEGIN
2124: fnd_oam_debug.log(1, p_ctxt, 'Run ID: '||p_run_id);
2125: fnd_oam_debug.log(1, p_ctxt, 'Bundle ID: '||p_bundle_id);
2126: fnd_oam_debug.log(1, p_ctxt, 'Bundles: '||p_num_bundles);
2127: fnd_oam_debug.log(1, p_ctxt, 'Workers: '||p_num_workers);
2128: END;
2129:
2130: --Public

Line 2127: fnd_oam_debug.log(1, p_ctxt, 'Workers: '||p_num_workers);

2123: BEGIN
2124: fnd_oam_debug.log(1, p_ctxt, 'Run ID: '||p_run_id);
2125: fnd_oam_debug.log(1, p_ctxt, 'Bundle ID: '||p_bundle_id);
2126: fnd_oam_debug.log(1, p_ctxt, 'Bundles: '||p_num_bundles);
2127: fnd_oam_debug.log(1, p_ctxt, 'Workers: '||p_num_workers);
2128: END;
2129:
2130: --Public
2131: PROCEDURE EXECUTE_TEST1(p_run_id IN NUMBER DEFAULT 1,

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

2149: l_return_msg VARCHAR2(2048);
2150: l_start NUMBER;
2151: l_end NUMBER;
2152: BEGIN
2153: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2154: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
2155:
2156: ROLLBACK;
2157: -- make sure the run is initialized

Line 2161: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

2157: -- make sure the run is initialized
2158: IF RUN_NEEDS_INIT(p_run_id,
2159: l_lock_handle) THEN
2160:
2161: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2162: l_start := DBMS_UTILITY.GET_TIME;
2163:
2164: IF NOT INIT_SINGLE_TASK(p_run_id,
2165: p_bundle_id,

Line 2174: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2170: END IF;
2171:
2172: COMMIT;
2173: l_end := DBMS_UTILITY.GET_TIME;
2174: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2175: l_did_init := TRUE;
2176: END IF;
2177:
2178: --do work

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

2205: l_retbool_final := SYNC_ON_FINISH(p_run_id,
2206: l_retbool);
2207: END IF;
2208:
2209: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2210: IF l_retbool_final THEN
2211: x_verdict := FND_API.G_TRUE;
2212: ELSE
2213: x_verdict := FND_API.G_FALSE;

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

2216: WHEN INIT_FAILED THEN
2217: --release the run lock on failure just in case
2218: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2219: IF l_retval <> 0 THEN
2220: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2221: END IF;
2222: ROLLBACK;
2223: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2224: x_verdict := FND_API.G_FALSE;

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

2219: IF l_retval <> 0 THEN
2220: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2221: END IF;
2222: ROLLBACK;
2223: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2224: x_verdict := FND_API.G_FALSE;
2225: WHEN SYNC_FAILED THEN
2226: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2227: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 2226: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

2222: ROLLBACK;
2223: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2224: x_verdict := FND_API.G_FALSE;
2225: WHEN SYNC_FAILED THEN
2226: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2227: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2228: x_verdict := FND_API.G_FALSE;
2229: WHEN OTHERS THEN
2230: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

2223: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2224: x_verdict := FND_API.G_FALSE;
2225: WHEN SYNC_FAILED THEN
2226: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2227: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2228: x_verdict := FND_API.G_FALSE;
2229: WHEN OTHERS THEN
2230: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2231: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2226: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2227: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2228: x_verdict := FND_API.G_FALSE;
2229: WHEN OTHERS THEN
2230: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2231: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2232: x_verdict := FND_API.G_FALSE;
2233: END;
2234:

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

2227: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2228: x_verdict := FND_API.G_FALSE;
2229: WHEN OTHERS THEN
2230: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2231: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2232: x_verdict := FND_API.G_FALSE;
2233: END;
2234:
2235: --Public

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

2255: l_return_msg VARCHAR2(2048);
2256: l_start NUMBER;
2257: l_end NUMBER;
2258: BEGIN
2259: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2260: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
2261:
2262: ROLLBACK;
2263: IF RUN_NEEDS_INIT(p_run_id,

Line 2266: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

2262: ROLLBACK;
2263: IF RUN_NEEDS_INIT(p_run_id,
2264: l_lock_handle) THEN
2265:
2266: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2267: l_start := DBMS_UTILITY.GET_TIME;
2268:
2269: --create a single run/bundle/task
2270: IF NOT INIT_SINGLE_DML_UNIT(p_run_id,

Line 2281: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2277: END IF;
2278:
2279: COMMIT;
2280: l_end := DBMS_UTILITY.GET_TIME;
2281: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2282: l_did_init := TRUE;
2283: END IF;
2284:
2285: --do work

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

2312: l_retbool_final := SYNC_ON_FINISH(p_run_id,
2313: l_retbool);
2314: END IF;
2315:
2316: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2317: IF l_retbool_final THEN
2318: x_verdict := FND_API.G_TRUE;
2319: ELSE
2320: x_verdict := FND_API.G_FALSE;

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

2323: WHEN INIT_FAILED THEN
2324: --release the run lock on failure just in case
2325: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2326: IF l_retval <> 0 THEN
2327: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2328: END IF;
2329: ROLLBACK;
2330: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2331: x_verdict := FND_API.G_FALSE;

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

2326: IF l_retval <> 0 THEN
2327: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2328: END IF;
2329: ROLLBACK;
2330: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2331: x_verdict := FND_API.G_FALSE;
2332: WHEN SYNC_FAILED THEN
2333: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 2333: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

2329: ROLLBACK;
2330: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2331: x_verdict := FND_API.G_FALSE;
2332: WHEN SYNC_FAILED THEN
2333: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2335: x_verdict := FND_API.G_FALSE;
2336: WHEN OTHERS THEN
2337: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

2330: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2331: x_verdict := FND_API.G_FALSE;
2332: WHEN SYNC_FAILED THEN
2333: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2335: x_verdict := FND_API.G_FALSE;
2336: WHEN OTHERS THEN
2337: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2333: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2335: x_verdict := FND_API.G_FALSE;
2336: WHEN OTHERS THEN
2337: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2339: x_verdict := FND_API.G_FALSE;
2340: END;
2341:

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

2334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2335: x_verdict := FND_API.G_FALSE;
2336: WHEN OTHERS THEN
2337: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2339: x_verdict := FND_API.G_FALSE;
2340: END;
2341:
2342: --Helper to execute_test3 to remove any state that will negatively impact future tests

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

2347: IS
2348: l_ctxt VARCHAR2(60) := PKG_NAME||'CLEANUP_TEST3';
2349: l_retbool BOOLEAN;
2350: BEGIN
2351: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2352: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);
2353: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);
2354:
2355: l_retbool := DELETE_GLOBAL_ARGS(p_global_arg_names);

Line 2352: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);

2348: l_ctxt VARCHAR2(60) := PKG_NAME||'CLEANUP_TEST3';
2349: l_retbool BOOLEAN;
2350: BEGIN
2351: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2352: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);
2353: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);
2354:
2355: l_retbool := DELETE_GLOBAL_ARGS(p_global_arg_names);
2356:

Line 2353: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);

2349: l_retbool BOOLEAN;
2350: BEGIN
2351: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2352: fnd_oam_debug.log(1, l_ctxt, 'Run ID: '||p_run_id);
2353: fnd_oam_debug.log(1, l_ctxt, 'Bundle ID: '||p_bundle_id);
2354:
2355: l_retbool := DELETE_GLOBAL_ARGS(p_global_arg_names);
2356:
2357: COMMIT;

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

2355: l_retbool := DELETE_GLOBAL_ARGS(p_global_arg_names);
2356:
2357: COMMIT;
2358:
2359: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2360: RETURN l_retbool;
2361: EXCEPTION
2362: WHEN OTHERS THEN
2363: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

2359: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2360: RETURN l_retbool;
2361: EXCEPTION
2362: WHEN OTHERS THEN
2363: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2364: RETURN FALSE;
2365: END;
2366:
2367: --Public

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

2389: l_return_msg VARCHAR2(2048);
2390: l_start NUMBER;
2391: l_end NUMBER;
2392: BEGIN
2393: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2394: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
2395:
2396: ROLLBACK;
2397: IF RUN_NEEDS_INIT(p_run_id,

Line 2400: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

2396: ROLLBACK;
2397: IF RUN_NEEDS_INIT(p_run_id,
2398: l_lock_handle) THEN
2399:
2400: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2401: l_start := DBMS_UTILITY.GET_TIME;
2402:
2403: --create a single run/bundle/task
2404: IF NOT INIT_SINGLE_TASK(p_run_id,

Line 2561: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2557: END IF;
2558:
2559: COMMIT;
2560: l_end := DBMS_UTILITY.GET_TIME;
2561: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2562: l_did_init := TRUE;
2563: END IF;
2564:
2565: --do work

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

2597: l_retbool_final := SYNC_ON_FINISH(p_run_id,
2598: l_retbool);
2599: END IF;
2600:
2601: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2602: IF l_retbool_final THEN
2603: x_verdict := FND_API.G_TRUE;
2604: ELSE
2605: x_verdict := FND_API.G_FALSE;

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

2608: WHEN INIT_FAILED THEN
2609: --release the run lock on failure just in case
2610: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2611: IF l_retval <> 0 THEN
2612: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2613: END IF;
2614: ROLLBACK;
2615: l_retbool := CLEANUP_TEST3(p_run_id,
2616: p_bundle_id,

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

2614: ROLLBACK;
2615: l_retbool := CLEANUP_TEST3(p_run_id,
2616: p_bundle_id,
2617: l_global_arg_names);
2618: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2619: x_verdict := FND_API.G_FALSE;
2620: WHEN SYNC_FAILED THEN
2621: l_retbool := CLEANUP_TEST3(p_run_id,
2622: p_bundle_id,

Line 2624: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

2620: WHEN SYNC_FAILED THEN
2621: l_retbool := CLEANUP_TEST3(p_run_id,
2622: p_bundle_id,
2623: l_global_arg_names);
2624: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2625: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2626: x_verdict := FND_API.G_FALSE;
2627: WHEN OTHERS THEN
2628: l_retbool := CLEANUP_TEST3(p_run_id,

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

2621: l_retbool := CLEANUP_TEST3(p_run_id,
2622: p_bundle_id,
2623: l_global_arg_names);
2624: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2625: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2626: x_verdict := FND_API.G_FALSE;
2627: WHEN OTHERS THEN
2628: l_retbool := CLEANUP_TEST3(p_run_id,
2629: p_bundle_id,

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

2627: WHEN OTHERS THEN
2628: l_retbool := CLEANUP_TEST3(p_run_id,
2629: p_bundle_id,
2630: l_global_arg_names);
2631: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2632: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2633: x_verdict := FND_API.G_FALSE;
2634: END;
2635:

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

2628: l_retbool := CLEANUP_TEST3(p_run_id,
2629: p_bundle_id,
2630: l_global_arg_names);
2631: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2632: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2633: x_verdict := FND_API.G_FALSE;
2634: END;
2635:
2636: --helper to EXECUTE_TEST4 to validate the test succeeded

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

2652: j NUMBER;
2653: l_count NUMBER;
2654: l_ids DBMS_SQL.NUMBER_TABLE;
2655: BEGIN
2656: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2657:
2658: --first validate the run
2659: IF NOT VALIDATE_RUN_SUCCESS(p_run_id,
2660: x_run_stat_id => l_run_stat_id) THEN

Line 2691: fnd_oam_debug.log(6, l_ctxt, 'Number of tasks found ('||l_count||') did not match the number expected (5)');

2687: k := l_ids.NEXT(k);
2688: l_count := l_count + 1;
2689: END LOOP;
2690: IF l_count IS NULL OR l_count <> 5 THEN
2691: fnd_oam_debug.log(6, l_ctxt, 'Number of tasks found ('||l_count||') did not match the number expected (5)');
2692: RAISE VALIDATE_FAILED;
2693: END IF;
2694:
2695: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2691: fnd_oam_debug.log(6, l_ctxt, 'Number of tasks found ('||l_count||') did not match the number expected (5)');
2692: RAISE VALIDATE_FAILED;
2693: END IF;
2694:
2695: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2696: RETURN TRUE;
2697: EXCEPTION
2698: WHEN VALIDATE_FAILED THEN
2699: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2695: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2696: RETURN TRUE;
2697: EXCEPTION
2698: WHEN VALIDATE_FAILED THEN
2699: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2700: RETURN FALSE;
2701: WHEN OTHERS THEN
2702: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2703: RETURN FALSE;

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

2698: WHEN VALIDATE_FAILED THEN
2699: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2700: RETURN FALSE;
2701: WHEN OTHERS THEN
2702: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2703: RETURN FALSE;
2704: END;
2705:
2706: --Public

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

2728: l_end NUMBER;
2729: k NUMBER;
2730: j NUMBER;
2731: BEGIN
2732: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2733: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
2734:
2735: ROLLBACK;
2736: IF RUN_NEEDS_INIT(p_run_id,

Line 2739: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

2735: ROLLBACK;
2736: IF RUN_NEEDS_INIT(p_run_id,
2737: l_lock_handle) THEN
2738:
2739: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2740: l_start := DBMS_UTILITY.GET_TIME;
2741:
2742: --create a single run/bundle
2743: IF NOT MAKE_RUN(p_run_id,

Line 2779: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2775: END LOOP;
2776:
2777: COMMIT;
2778: l_end := DBMS_UTILITY.GET_TIME;
2779: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2780: l_did_init := TRUE;
2781: END IF;
2782:
2783: --do work

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

2808: l_retbool_final := SYNC_ON_FINISH(p_run_id,
2809: l_retbool);
2810: END IF;
2811:
2812: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2813: IF l_retbool_final THEN
2814: x_verdict := FND_API.G_TRUE;
2815: ELSE
2816: x_verdict := FND_API.G_FALSE;

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

2819: WHEN INIT_FAILED THEN
2820: --release the run lock on failure just in case
2821: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
2822: IF l_retval <> 0 THEN
2823: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2824: END IF;
2825: ROLLBACK;
2826: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2827: x_verdict := FND_API.G_FALSE;

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

2822: IF l_retval <> 0 THEN
2823: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
2824: END IF;
2825: ROLLBACK;
2826: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2827: x_verdict := FND_API.G_FALSE;
2828: WHEN SYNC_FAILED THEN
2829: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2830: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 2829: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

2825: ROLLBACK;
2826: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2827: x_verdict := FND_API.G_FALSE;
2828: WHEN SYNC_FAILED THEN
2829: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2830: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2831: x_verdict := FND_API.G_FALSE;
2832: WHEN OTHERS THEN
2833: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

2826: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2827: x_verdict := FND_API.G_FALSE;
2828: WHEN SYNC_FAILED THEN
2829: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2830: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2831: x_verdict := FND_API.G_FALSE;
2832: WHEN OTHERS THEN
2833: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2834: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2829: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
2830: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2831: x_verdict := FND_API.G_FALSE;
2832: WHEN OTHERS THEN
2833: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2834: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2835: x_verdict := FND_API.G_FALSE;
2836: END;
2837:

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

2830: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2831: x_verdict := FND_API.G_FALSE;
2832: WHEN OTHERS THEN
2833: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2834: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2835: x_verdict := FND_API.G_FALSE;
2836: END;
2837:
2838: --helper to EXECUTE_TEST5 to validate the test succeeded

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

2849: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_'||l_testnum;
2850:
2851: l_c2_target_sum NUMBER := p_test_tab_num_rows*2;
2852: BEGIN
2853: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2854:
2855: --first validate the run/bundle/task/unit
2856: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
2857: p_num_workers,

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

2877: p_test_tab_num_rows) THEN
2878: RAISE VALIDATE_FAILED;
2879: END IF;
2880:
2881: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2882: RETURN TRUE;
2883: EXCEPTION
2884: WHEN VALIDATE_FAILED THEN
2885: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

2881: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2882: RETURN TRUE;
2883: EXCEPTION
2884: WHEN VALIDATE_FAILED THEN
2885: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2886: RETURN FALSE;
2887: WHEN OTHERS THEN
2888: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2889: RETURN FALSE;

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

2884: WHEN VALIDATE_FAILED THEN
2885: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
2886: RETURN FALSE;
2887: WHEN OTHERS THEN
2888: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
2889: RETURN FALSE;
2890: END;
2891:
2892: --Public

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

2919: l_end NUMBER;
2920: k NUMBER;
2921: j NUMBER;
2922: BEGIN
2923: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2924: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
2925:
2926: ROLLBACK;
2927: IF RUN_NEEDS_INIT(p_run_id,

Line 2930: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

2926: ROLLBACK;
2927: IF RUN_NEEDS_INIT(p_run_id,
2928: l_lock_handle) THEN
2929:
2930: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
2931: l_start := DBMS_UTILITY.GET_TIME;
2932:
2933: --create a test table to work on
2934: IF NOT MAKE_TEST_TABLE(l_test_table_name,

Line 2988: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

2984: END IF;
2985:
2986: COMMIT;
2987: l_end := DBMS_UTILITY.GET_TIME;
2988: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
2989: l_did_init := TRUE;
2990: END IF;
2991:
2992: --do work

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

3021: l_retbool_final := SYNC_ON_FINISH(p_run_id,
3022: l_retbool);
3023: END IF;
3024:
3025: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3026: IF l_retbool_final THEN
3027: x_verdict := FND_API.G_TRUE;
3028: ELSE
3029: x_verdict := FND_API.G_FALSE;

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

3032: WHEN INIT_FAILED THEN
3033: --release the run lock on failure just in case
3034: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
3035: IF l_retval <> 0 THEN
3036: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3037: END IF;
3038: ROLLBACK;
3039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3040: x_verdict := FND_API.G_FALSE;

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

3035: IF l_retval <> 0 THEN
3036: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3037: END IF;
3038: ROLLBACK;
3039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3040: x_verdict := FND_API.G_FALSE;
3041: WHEN SYNC_FAILED THEN
3042: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3043: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 3042: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

3038: ROLLBACK;
3039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3040: x_verdict := FND_API.G_FALSE;
3041: WHEN SYNC_FAILED THEN
3042: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3043: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3044: x_verdict := FND_API.G_FALSE;
3045: WHEN OTHERS THEN
3046: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

3039: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3040: x_verdict := FND_API.G_FALSE;
3041: WHEN SYNC_FAILED THEN
3042: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3043: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3044: x_verdict := FND_API.G_FALSE;
3045: WHEN OTHERS THEN
3046: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3047: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3042: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3043: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3044: x_verdict := FND_API.G_FALSE;
3045: WHEN OTHERS THEN
3046: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3047: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3048: x_verdict := FND_API.G_FALSE;
3049: END;
3050:

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

3043: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3044: x_verdict := FND_API.G_FALSE;
3045: WHEN OTHERS THEN
3046: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3047: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3048: x_verdict := FND_API.G_FALSE;
3049: END;
3050:
3051: -- Public

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

3067: l_c2_run_sum NUMBER;
3068: l_valid_value_flag VARCHAR2(3);
3069: l_canonical_value VARCHAR2(4000);
3070: BEGIN
3071: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3072:
3073: --first validate the run/bundle/task/unit
3074: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
3075: p_num_workers,

Line 3108: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for final C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

3104: FROM fnd_oam_dscram_args_b
3105: WHERE arg_id = p_c2_final_arg_id;
3106: EXCEPTION
3107: WHEN OTHERS THEN
3108: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for final C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3109: RAISE VALIDATE_FAILED;
3110: END;
3111: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
3112: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of final C2 Sum for dml is incorrect: '||l_valid_value_flag);

Line 3112: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of final C2 Sum for dml is incorrect: '||l_valid_value_flag);

3108: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for final C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3109: RAISE VALIDATE_FAILED;
3110: END;
3111: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
3112: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of final C2 Sum for dml is incorrect: '||l_valid_value_flag);
3113: RAISE VALIDATE_FAILED;
3114: END IF;
3115: l_c2_final_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
3116: IF l_c2_final_sum IS NULL OR l_c2_final_sum <> p_test_tab_num_rows THEN

Line 3117: fnd_oam_debug.log(6, l_ctxt, 'Final C2 Sum('||l_c2_final_sum||') not equal to target value('||p_test_tab_num_rows||')');

3113: RAISE VALIDATE_FAILED;
3114: END IF;
3115: l_c2_final_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
3116: IF l_c2_final_sum IS NULL OR l_c2_final_sum <> p_test_tab_num_rows THEN
3117: fnd_oam_debug.log(6, l_ctxt, 'Final C2 Sum('||l_c2_final_sum||') not equal to target value('||p_test_tab_num_rows||')');
3118: RAISE VALIDATE_FAILED;
3119: END IF;
3120:
3121: --make sure that the run c2 sum also equals the # of rows.

Line 3131: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

3127: AND valid_value_flag = FND_API.G_TRUE
3128: AND rownum < 2;
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3132: RAISE VALIDATE_FAILED;
3133: END;
3134: IF l_c2_run_sum IS NULL OR l_c2_run_sum <> p_test_tab_num_rows THEN
3135: fnd_oam_debug.log(6, l_ctxt, 'Run C2 Sum('||l_c2_run_sum||') not equal to target value('||p_test_tab_num_rows||')');

Line 3135: fnd_oam_debug.log(6, l_ctxt, 'Run C2 Sum('||l_c2_run_sum||') not equal to target value('||p_test_tab_num_rows||')');

3131: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3132: RAISE VALIDATE_FAILED;
3133: END;
3134: IF l_c2_run_sum IS NULL OR l_c2_run_sum <> p_test_tab_num_rows THEN
3135: fnd_oam_debug.log(6, l_ctxt, 'Run C2 Sum('||l_c2_run_sum||') not equal to target value('||p_test_tab_num_rows||')');
3136: RAISE VALIDATE_FAILED;
3137: END IF;
3138:
3139: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3135: fnd_oam_debug.log(6, l_ctxt, 'Run C2 Sum('||l_c2_run_sum||') not equal to target value('||p_test_tab_num_rows||')');
3136: RAISE VALIDATE_FAILED;
3137: END IF;
3138:
3139: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3140: RETURN TRUE;
3141: EXCEPTION
3142: WHEN VALIDATE_FAILED THEN
3143: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3139: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3140: RETURN TRUE;
3141: EXCEPTION
3142: WHEN VALIDATE_FAILED THEN
3143: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3144: RETURN FALSE;
3145: WHEN OTHERS THEN
3146: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3147: RETURN FALSE;

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

3142: WHEN VALIDATE_FAILED THEN
3143: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3144: RETURN FALSE;
3145: WHEN OTHERS THEN
3146: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3147: RETURN FALSE;
3148: END;
3149:
3150: --Public

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

3180: l_end NUMBER;
3181: k NUMBER;
3182: j NUMBER;
3183: BEGIN
3184: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3185: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
3186:
3187: ROLLBACK;
3188: IF RUN_NEEDS_INIT(p_run_id,

Line 3191: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

3187: ROLLBACK;
3188: IF RUN_NEEDS_INIT(p_run_id,
3189: l_lock_handle) THEN
3190:
3191: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3192: l_start := DBMS_UTILITY.GET_TIME;
3193:
3194: --create a test table to work on
3195: IF NOT MAKE_TEST_TABLE(l_test_table_name,

Line 3279: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

3275: END IF;
3276:
3277: COMMIT;
3278: l_end := DBMS_UTILITY.GET_TIME;
3279: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
3280: l_did_init := TRUE;
3281: END IF;
3282:
3283: --do work

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

3313: l_retbool_final := SYNC_ON_FINISH(p_run_id,
3314: l_retbool);
3315: END IF;
3316:
3317: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3318: IF l_retbool_final THEN
3319: x_verdict := FND_API.G_TRUE;
3320: ELSE
3321: x_verdict := FND_API.G_FALSE;

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

3324: WHEN INIT_FAILED THEN
3325: --release the run lock on failure just in case
3326: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
3327: IF l_retval <> 0 THEN
3328: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3329: END IF;
3330: ROLLBACK;
3331: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3332: x_verdict := FND_API.G_FALSE;

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

3327: IF l_retval <> 0 THEN
3328: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3329: END IF;
3330: ROLLBACK;
3331: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3332: x_verdict := FND_API.G_FALSE;
3333: WHEN SYNC_FAILED THEN
3334: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3335: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 3334: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

3330: ROLLBACK;
3331: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3332: x_verdict := FND_API.G_FALSE;
3333: WHEN SYNC_FAILED THEN
3334: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3335: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3336: x_verdict := FND_API.G_FALSE;
3337: WHEN OTHERS THEN
3338: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

3331: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3332: x_verdict := FND_API.G_FALSE;
3333: WHEN SYNC_FAILED THEN
3334: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3335: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3336: x_verdict := FND_API.G_FALSE;
3337: WHEN OTHERS THEN
3338: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3339: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3334: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3335: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3336: x_verdict := FND_API.G_FALSE;
3337: WHEN OTHERS THEN
3338: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3339: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3340: x_verdict := FND_API.G_FALSE;
3341: END;
3342:

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

3335: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3336: x_verdict := FND_API.G_FALSE;
3337: WHEN OTHERS THEN
3338: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3339: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3340: x_verdict := FND_API.G_FALSE;
3341: END;
3342:
3343: -- Public

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

3360:
3361: l_valid_value_flag VARCHAR2(3);
3362: l_canonical_value VARCHAR2(4000);
3363: BEGIN
3364: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3365:
3366: --first validate the run/bundle/task/unit
3367: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
3368: p_num_workers,

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

3401: p_c4_arg_id) THEN
3402: RAISE VALIDATE_FAILED;
3403: END IF;
3404:
3405: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3406: RETURN TRUE;
3407: EXCEPTION
3408: WHEN VALIDATE_FAILED THEN
3409: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3405: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3406: RETURN TRUE;
3407: EXCEPTION
3408: WHEN VALIDATE_FAILED THEN
3409: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3410: RETURN FALSE;
3411: WHEN OTHERS THEN
3412: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3413: RETURN FALSE;

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

3408: WHEN VALIDATE_FAILED THEN
3409: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3410: RETURN FALSE;
3411: WHEN OTHERS THEN
3412: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3413: RETURN FALSE;
3414: END;
3415:
3416: --Public

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

3458: l_end NUMBER;
3459: k NUMBER;
3460: j NUMBER;
3461: BEGIN
3462: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3463: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
3464:
3465: ROLLBACK;
3466: IF RUN_NEEDS_INIT(p_run_id,

Line 3469: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

3465: ROLLBACK;
3466: IF RUN_NEEDS_INIT(p_run_id,
3467: l_lock_handle) THEN
3468:
3469: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3470: l_start := DBMS_UTILITY.GET_TIME;
3471:
3472: --create a test table to work on
3473: IF NOT MAKE_TEST_TABLE(l_test_table_name,

Line 3620: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

3616:
3617:
3618: COMMIT;
3619: l_end := DBMS_UTILITY.GET_TIME;
3620: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
3621: l_did_init := TRUE;
3622: END IF;
3623:
3624: --do work

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

3656: l_retbool_final := SYNC_ON_FINISH(p_run_id,
3657: l_retbool);
3658: END IF;
3659:
3660: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3661: IF l_retbool_final THEN
3662: x_verdict := FND_API.G_TRUE;
3663: ELSE
3664: x_verdict := FND_API.G_FALSE;

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

3667: WHEN INIT_FAILED THEN
3668: --release the run lock on failure just in case
3669: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
3670: IF l_retval <> 0 THEN
3671: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3672: END IF;
3673: ROLLBACK;
3674: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3675: x_verdict := FND_API.G_FALSE;

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

3670: IF l_retval <> 0 THEN
3671: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
3672: END IF;
3673: ROLLBACK;
3674: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3675: x_verdict := FND_API.G_FALSE;
3676: WHEN SYNC_FAILED THEN
3677: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3678: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 3677: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

3673: ROLLBACK;
3674: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3675: x_verdict := FND_API.G_FALSE;
3676: WHEN SYNC_FAILED THEN
3677: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3678: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3679: x_verdict := FND_API.G_FALSE;
3680: WHEN OTHERS THEN
3681: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

3674: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3675: x_verdict := FND_API.G_FALSE;
3676: WHEN SYNC_FAILED THEN
3677: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3678: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3679: x_verdict := FND_API.G_FALSE;
3680: WHEN OTHERS THEN
3681: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3682: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3677: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
3678: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3679: x_verdict := FND_API.G_FALSE;
3680: WHEN OTHERS THEN
3681: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3682: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3683: x_verdict := FND_API.G_FALSE;
3684: END;
3685:

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

3678: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3679: x_verdict := FND_API.G_FALSE;
3680: WHEN OTHERS THEN
3681: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3682: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3683: x_verdict := FND_API.G_FALSE;
3684: END;
3685:
3686: -- Public

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

3695:
3696: l_valid_value_flag VARCHAR2(3);
3697: l_canonical_value VARCHAR2(4000);
3698: BEGIN
3699: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3700:
3701: --first validate the run/bundle/task/unit/plsql
3702: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
3703: p_num_workers,

Line 3719: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for verdict: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

3715: FROM fnd_oam_dscram_arg_values
3716: WHERE arg_id = p_verdict_arg_id;
3717: EXCEPTION
3718: WHEN OTHERS THEN
3719: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for verdict: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3720: RAISE VALIDATE_FAILED;
3721: END;
3722: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
3723: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of verdict arg is incorrect: '||l_valid_value_flag);

Line 3723: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of verdict arg is incorrect: '||l_valid_value_flag);

3719: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for verdict: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3720: RAISE VALIDATE_FAILED;
3721: END;
3722: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
3723: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of verdict arg is incorrect: '||l_valid_value_flag);
3724: RAISE VALIDATE_FAILED;
3725: END IF;
3726: IF l_canonical_value IS NULL OR l_canonical_value <> FND_API.G_TRUE THEN
3727: fnd_oam_debug.log(6, l_ctxt, 'Verdict('||l_canonical_value||') not equal to target value('||FND_API.G_TRUE||')');

Line 3727: fnd_oam_debug.log(6, l_ctxt, 'Verdict('||l_canonical_value||') not equal to target value('||FND_API.G_TRUE||')');

3723: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of verdict arg is incorrect: '||l_valid_value_flag);
3724: RAISE VALIDATE_FAILED;
3725: END IF;
3726: IF l_canonical_value IS NULL OR l_canonical_value <> FND_API.G_TRUE THEN
3727: fnd_oam_debug.log(6, l_ctxt, 'Verdict('||l_canonical_value||') not equal to target value('||FND_API.G_TRUE||')');
3728: RAISE VALIDATE_FAILED;
3729: END IF;
3730:
3731: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3727: fnd_oam_debug.log(6, l_ctxt, 'Verdict('||l_canonical_value||') not equal to target value('||FND_API.G_TRUE||')');
3728: RAISE VALIDATE_FAILED;
3729: END IF;
3730:
3731: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3732: RETURN TRUE;
3733: EXCEPTION
3734: WHEN VALIDATE_FAILED THEN
3735: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

3731: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3732: RETURN TRUE;
3733: EXCEPTION
3734: WHEN VALIDATE_FAILED THEN
3735: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3736: RETURN FALSE;
3737: WHEN OTHERS THEN
3738: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3739: RETURN FALSE;

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

3734: WHEN VALIDATE_FAILED THEN
3735: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
3736: RETURN FALSE;
3737: WHEN OTHERS THEN
3738: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
3739: RETURN FALSE;
3740: END;
3741:
3742: -- Public

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

3957: l_end NUMBER;
3958: k NUMBER;
3959: j NUMBER;
3960: BEGIN
3961: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
3962: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
3963:
3964: ROLLBACK;
3965: IF RUN_NEEDS_INIT(p_run_id,

Line 3968: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

3964: ROLLBACK;
3965: IF RUN_NEEDS_INIT(p_run_id,
3966: l_lock_handle) THEN
3967:
3968: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
3969: l_start := DBMS_UTILITY.GET_TIME;
3970:
3971: --create a single run
3972: IF NOT MAKE_RUN(p_run_id,

Line 4286: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

4282: END IF;
4283:
4284: COMMIT;
4285: l_end := DBMS_UTILITY.GET_TIME;
4286: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
4287: l_did_init := TRUE;
4288: END IF;
4289:
4290: --do work

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

4316: l_retbool_final := SYNC_ON_FINISH(p_run_id,
4317: l_retbool);
4318: END IF;
4319:
4320: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4321: IF l_retbool_final THEN
4322: x_verdict := FND_API.G_TRUE;
4323: ELSE
4324: x_verdict := FND_API.G_FALSE;

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

4327: WHEN INIT_FAILED THEN
4328: --release the run lock on failure just in case
4329: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
4330: IF l_retval <> 0 THEN
4331: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
4332: END IF;
4333: ROLLBACK;
4334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4335: x_verdict := FND_API.G_FALSE;

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

4330: IF l_retval <> 0 THEN
4331: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
4332: END IF;
4333: ROLLBACK;
4334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4335: x_verdict := FND_API.G_FALSE;
4336: WHEN SYNC_FAILED THEN
4337: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 4337: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

4333: ROLLBACK;
4334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4335: x_verdict := FND_API.G_FALSE;
4336: WHEN SYNC_FAILED THEN
4337: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4339: x_verdict := FND_API.G_FALSE;
4340: WHEN OTHERS THEN
4341: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

4334: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4335: x_verdict := FND_API.G_FALSE;
4336: WHEN SYNC_FAILED THEN
4337: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4339: x_verdict := FND_API.G_FALSE;
4340: WHEN OTHERS THEN
4341: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4342: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

4337: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4339: x_verdict := FND_API.G_FALSE;
4340: WHEN OTHERS THEN
4341: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4342: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4343: x_verdict := FND_API.G_FALSE;
4344: END;
4345:

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

4338: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4339: x_verdict := FND_API.G_FALSE;
4340: WHEN OTHERS THEN
4341: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4342: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4343: x_verdict := FND_API.G_FALSE;
4344: END;
4345:
4346: -- Public

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

4366: l_c2_sum NUMBER;
4367: l_c2_plsql_target_sum NUMBER := 2*p_test_tab_num_rows;
4368: l_c2_dml_target_sum NUMBER := p_test_tab_num_rows*p_test_tab_num_rows + p_test_tab_num_rows;
4369: BEGIN
4370: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
4371:
4372: --first validate the run/bundle/task/unit/plsql
4373: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
4374: p_num_workers,

Line 4413: fnd_oam_debug.log(6, l_ctxt, 'Failed to query count of invalid verdicts: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

4409: AND (valid_value_flag IS NULL OR valid_value_flag <> FND_API.G_TRUE)
4410: AND (canonical_value IS NULL OR canonical_value <> FND_API.G_TRUE);
4411: EXCEPTION
4412: WHEN OTHERS THEN
4413: fnd_oam_debug.log(6, l_ctxt, 'Failed to query count of invalid verdicts: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4414: RAISE VALIDATE_FAILED;
4415: END;
4416: IF l_count IS NULL OR l_count <> 0 THEN
4417: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||p_verdict_arg_id||'), found ('||l_count||') invalid verdicts');

Line 4417: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||p_verdict_arg_id||'), found ('||l_count||') invalid verdicts');

4413: fnd_oam_debug.log(6, l_ctxt, 'Failed to query count of invalid verdicts: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4414: RAISE VALIDATE_FAILED;
4415: END;
4416: IF l_count IS NULL OR l_count <> 0 THEN
4417: fnd_oam_debug.log(6, l_ctxt, 'Arg ID('||p_verdict_arg_id||'), found ('||l_count||') invalid verdicts');
4418: RAISE VALIDATE_FAILED;
4419: END IF;
4420:
4421: --check the run arg's value

Line 4422: fnd_oam_debug.log(1, l_ctxt, 'Checking intermediate run C2 arg value...');

4418: RAISE VALIDATE_FAILED;
4419: END IF;
4420:
4421: --check the run arg's value
4422: fnd_oam_debug.log(1, l_ctxt, 'Checking intermediate run C2 arg value...');
4423: BEGIN
4424: SELECT valid_value_flag, canonical_value
4425: INTO l_valid_value_flag, l_canonical_value
4426: FROM fnd_oam_dscram_args_b

Line 4429: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of run C2 intermediate sum is incorrect: '||l_valid_value_flag);

4425: INTO l_valid_value_flag, l_canonical_value
4426: FROM fnd_oam_dscram_args_b
4427: WHERE arg_id = p_c2_run_arg_id;
4428: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
4429: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of run C2 intermediate sum is incorrect: '||l_valid_value_flag);
4430: RAISE VALIDATE_FAILED;
4431: END IF;
4432: l_c2_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);
4433: EXCEPTION

Line 4437: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 intermediate sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

4433: EXCEPTION
4434: WHEN VALIDATE_FAILED THEN
4435: RAISE;
4436: WHEN OTHERS THEN
4437: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 intermediate sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4438: RAISE VALIDATE_FAILED;
4439: END;
4440: IF l_c2_sum IS NULL OR l_c2_sum <> p_test_tab_num_rows THEN
4441: fnd_oam_debug.log(6, l_ctxt, 'Run intermediate C2 Sum('||l_c2_sum||') not equal to target value('||p_test_tab_num_rows||')');

Line 4441: fnd_oam_debug.log(6, l_ctxt, 'Run intermediate C2 Sum('||l_c2_sum||') not equal to target value('||p_test_tab_num_rows||')');

4437: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for run C2 intermediate sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4438: RAISE VALIDATE_FAILED;
4439: END;
4440: IF l_c2_sum IS NULL OR l_c2_sum <> p_test_tab_num_rows THEN
4441: fnd_oam_debug.log(6, l_ctxt, 'Run intermediate C2 Sum('||l_c2_sum||') not equal to target value('||p_test_tab_num_rows||')');
4442: RAISE VALIDATE_FAILED;
4443: END IF;
4444:
4445: --check the plsql ranged c2 sum

Line 4446: fnd_oam_debug.log(1, l_ctxt, 'Checking plsql ranged c2 sum...');

4442: RAISE VALIDATE_FAILED;
4443: END IF;
4444:
4445: --check the plsql ranged c2 sum
4446: fnd_oam_debug.log(1, l_ctxt, 'Checking plsql ranged c2 sum...');
4447: IF NOT VALIDATE_TEST_TABLE_ARG_VALUES(TRUE,
4448: p_c2_plsql_range_arg_id,
4449: l_c2_plsql_target_sum,
4450: p_test_tab_name,

Line 4456: fnd_oam_debug.log(1, l_ctxt, 'Checking dml ranged c2 sum...');

4452: RAISE VALIDATE_FAILED;
4453: END IF;
4454:
4455: --check the dml ranged c2 sum
4456: fnd_oam_debug.log(1, l_ctxt, 'Checking dml ranged c2 sum...');
4457: IF NOT VALIDATE_TEST_TABLE_ARG_VALUES(TRUE,
4458: p_c2_dml_range_arg_id,
4459: l_c2_dml_target_sum,
4460: p_test_tab_name,

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

4461: p_test_tab_num_rows) THEN
4462: RAISE VALIDATE_FAILED;
4463: END IF;
4464:
4465: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4466: RETURN TRUE;
4467: EXCEPTION
4468: WHEN VALIDATE_FAILED THEN
4469: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

4465: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4466: RETURN TRUE;
4467: EXCEPTION
4468: WHEN VALIDATE_FAILED THEN
4469: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4470: RETURN FALSE;
4471: WHEN OTHERS THEN
4472: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4473: RETURN FALSE;

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

4468: WHEN VALIDATE_FAILED THEN
4469: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4470: RETURN FALSE;
4471: WHEN OTHERS THEN
4472: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4473: RETURN FALSE;
4474: END;
4475:
4476: -- Public

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

4551: l_end NUMBER;
4552: k NUMBER;
4553: j NUMBER;
4554: BEGIN
4555: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
4556: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
4557:
4558: ROLLBACK;
4559: IF RUN_NEEDS_INIT(p_run_id,

Line 4562: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

4558: ROLLBACK;
4559: IF RUN_NEEDS_INIT(p_run_id,
4560: l_lock_handle) THEN
4561:
4562: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
4563: l_start := DBMS_UTILITY.GET_TIME;
4564:
4565: --create a test table to work on
4566: IF NOT MAKE_TEST_TABLE(l_test_table_name,

Line 4788: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

4784: END IF;
4785:
4786: COMMIT;
4787: l_end := DBMS_UTILITY.GET_TIME;
4788: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
4789: l_did_init := TRUE;
4790: END IF;
4791:
4792: --do work

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

4825: l_retbool_final := SYNC_ON_FINISH(p_run_id,
4826: l_retbool);
4827: END IF;
4828:
4829: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4830: IF l_retbool_final THEN
4831: x_verdict := FND_API.G_TRUE;
4832: ELSE
4833: x_verdict := FND_API.G_FALSE;

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

4836: WHEN INIT_FAILED THEN
4837: --release the run lock on failure just in case
4838: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
4839: IF l_retval <> 0 THEN
4840: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
4841: END IF;
4842: ROLLBACK;
4843: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4844: x_verdict := FND_API.G_FALSE;

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

4839: IF l_retval <> 0 THEN
4840: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
4841: END IF;
4842: ROLLBACK;
4843: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4844: x_verdict := FND_API.G_FALSE;
4845: WHEN SYNC_FAILED THEN
4846: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4847: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 4846: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

4842: ROLLBACK;
4843: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4844: x_verdict := FND_API.G_FALSE;
4845: WHEN SYNC_FAILED THEN
4846: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4847: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4848: x_verdict := FND_API.G_FALSE;
4849: WHEN OTHERS THEN
4850: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

4843: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4844: x_verdict := FND_API.G_FALSE;
4845: WHEN SYNC_FAILED THEN
4846: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4847: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4848: x_verdict := FND_API.G_FALSE;
4849: WHEN OTHERS THEN
4850: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4851: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

4846: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
4847: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4848: x_verdict := FND_API.G_FALSE;
4849: WHEN OTHERS THEN
4850: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4851: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4852: x_verdict := FND_API.G_FALSE;
4853: END;
4854:

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

4847: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4848: x_verdict := FND_API.G_FALSE;
4849: WHEN OTHERS THEN
4850: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4851: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4852: x_verdict := FND_API.G_FALSE;
4853: END;
4854:
4855: -- Public

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

4872: l_canonical_value VARCHAR2(4000);
4873: l_c2_sum NUMBER;
4874: l_c2_target_sum NUMBER := 51208*p_test_tab_num_rows;
4875: BEGIN
4876: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
4877:
4878: --first validate the run/bundle/task/unit/plsql
4879: IF NOT VALIDATE_RUN_RECURSIVE(p_run_id,
4880: p_num_workers,

Line 4924: fnd_oam_debug.log(1, l_ctxt, 'Checking final ranged c2 sum...');

4920: RAISE VALIDATE_FAILED;
4921: END IF;
4922:
4923: --check the plsql ranged c2 sum
4924: fnd_oam_debug.log(1, l_ctxt, 'Checking final ranged c2 sum...');
4925: IF NOT VALIDATE_TEST_TABLE_ARG_VALUES(TRUE,
4926: p_c2_final_arg_id,
4927: l_c2_target_sum,
4928: p_test_tab_name,

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

4929: p_test_tab_num_rows) THEN
4930: RAISE VALIDATE_FAILED;
4931: END IF;
4932:
4933: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4934: RETURN TRUE;
4935: EXCEPTION
4936: WHEN VALIDATE_FAILED THEN
4937: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

4933: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4934: RETURN TRUE;
4935: EXCEPTION
4936: WHEN VALIDATE_FAILED THEN
4937: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4938: RETURN FALSE;
4939: WHEN OTHERS THEN
4940: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4941: RETURN FALSE;

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

4936: WHEN VALIDATE_FAILED THEN
4937: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
4938: RETURN FALSE;
4939: WHEN OTHERS THEN
4940: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
4941: RETURN FALSE;
4942: END;
4943:
4944: -- Public

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

5074: l_end NUMBER;
5075: k NUMBER;
5076: j NUMBER;
5077: BEGIN
5078: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
5079: PRINT_TEST_ENTRY_STATE(l_ctxt, p_run_id, p_bundle_id, p_num_bundles, p_num_workers);
5080:
5081: ROLLBACK;
5082: IF RUN_NEEDS_INIT(p_run_id,

Line 5085: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');

5081: ROLLBACK;
5082: IF RUN_NEEDS_INIT(p_run_id,
5083: l_lock_handle) THEN
5084:
5085: fnd_oam_debug.log(1, l_ctxt, 'Initializing Test...');
5086: l_start := DBMS_UTILITY.GET_TIME;
5087:
5088: --create a test table to work on
5089: IF NOT MAKE_TEST_TABLE(l_test_table_name,

Line 5510: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

5506: END IF;
5507:
5508: COMMIT;
5509: l_end := DBMS_UTILITY.GET_TIME;
5510: fnd_oam_debug.log(1, l_ctxt, 'Init Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
5511: l_did_init := TRUE;
5512: END IF;
5513:
5514: --do work

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

5545: l_retbool_final := SYNC_ON_FINISH(p_run_id,
5546: l_retbool);
5547: END IF;
5548:
5549: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5550: IF l_retbool_final THEN
5551: x_verdict := FND_API.G_TRUE;
5552: ELSE
5553: x_verdict := FND_API.G_FALSE;

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

5556: WHEN INIT_FAILED THEN
5557: --release the run lock on failure just in case
5558: l_retval := DBMS_LOCK.RELEASE(l_lock_handle);
5559: IF l_retval <> 0 THEN
5560: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
5561: END IF;
5562: ROLLBACK;
5563: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5564: x_verdict := FND_API.G_FALSE;

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

5559: IF l_retval <> 0 THEN
5560: fnd_oam_debug.log(6, l_ctxt, 'Failed to release run lock: '||l_retval);
5561: END IF;
5562: ROLLBACK;
5563: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5564: x_verdict := FND_API.G_FALSE;
5565: WHEN SYNC_FAILED THEN
5566: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
5567: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 5566: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');

5562: ROLLBACK;
5563: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5564: x_verdict := FND_API.G_FALSE;
5565: WHEN SYNC_FAILED THEN
5566: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
5567: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5568: x_verdict := FND_API.G_FALSE;
5569: WHEN OTHERS THEN
5570: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

5563: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5564: x_verdict := FND_API.G_FALSE;
5565: WHEN SYNC_FAILED THEN
5566: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
5567: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5568: x_verdict := FND_API.G_FALSE;
5569: WHEN OTHERS THEN
5570: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
5571: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

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

5566: fnd_oam_debug.log(6, l_ctxt, 'Sync Failed');
5567: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5568: x_verdict := FND_API.G_FALSE;
5569: WHEN OTHERS THEN
5570: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
5571: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5572: x_verdict := FND_API.G_FALSE;
5573: END;
5574:

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

5567: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5568: x_verdict := FND_API.G_FALSE;
5569: WHEN OTHERS THEN
5570: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
5571: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5572: x_verdict := FND_API.G_FALSE;
5573: END;
5574:
5575: --Public

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

5592: l_start NUMBER;
5593: l_end NUMBER;
5594: l_verdict VARCHAR2(6);
5595: BEGIN
5596: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
5597: l_start := DBMS_UTILITY.GET_TIME;
5598:
5599: EXECUTE_TEST1(l_run_id,
5600: l_bundle_id,

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

5602: p_num_workers,
5603: l_verdict);
5604: IF l_verdict <> FND_API.G_TRUE THEN
5605: IF l_fail_fast THEN
5606: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5607: x_verdict := l_verdict;
5608: RETURN;
5609: END IF;
5610: END IF;

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

5618: p_num_workers,
5619: l_verdict);
5620: IF l_verdict <> FND_API.G_TRUE THEN
5621: IF l_fail_fast THEN
5622: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5623: x_verdict := l_verdict;
5624: RETURN;
5625: END IF;
5626: END IF;

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

5634: p_num_workers,
5635: l_verdict);
5636: IF l_verdict <> FND_API.G_TRUE THEN
5637: IF l_fail_fast THEN
5638: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5639: x_verdict := l_verdict;
5640: RETURN;
5641: END IF;
5642: END IF;

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

5650: p_num_workers,
5651: l_verdict);
5652: IF l_verdict <> FND_API.G_TRUE THEN
5653: IF l_fail_fast THEN
5654: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5655: x_verdict := l_verdict;
5656: RETURN;
5657: END IF;
5658: END IF;

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

5666: p_num_workers,
5667: l_verdict);
5668: IF l_verdict <> FND_API.G_TRUE THEN
5669: IF l_fail_fast THEN
5670: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5671: x_verdict := l_verdict;
5672: RETURN;
5673: END IF;
5674: END IF;

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

5682: p_num_workers,
5683: l_verdict);
5684: IF l_verdict <> FND_API.G_TRUE THEN
5685: IF l_fail_fast THEN
5686: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5687: x_verdict := l_verdict;
5688: RETURN;
5689: END IF;
5690: END IF;

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

5698: p_num_workers,
5699: l_verdict);
5700: IF l_verdict <> FND_API.G_TRUE THEN
5701: IF l_fail_fast THEN
5702: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5703: x_verdict := l_verdict;
5704: RETURN;
5705: END IF;
5706: END IF;

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

5714: p_num_workers,
5715: l_verdict);
5716: IF l_verdict <> FND_API.G_TRUE THEN
5717: IF l_fail_fast THEN
5718: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5719: x_verdict := l_verdict;
5720: RETURN;
5721: END IF;
5722: END IF;

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

5730: p_num_workers,
5731: l_verdict);
5732: IF l_verdict <> FND_API.G_TRUE THEN
5733: IF l_fail_fast THEN
5734: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5735: x_verdict := l_verdict;
5736: RETURN;
5737: END IF;
5738: END IF;

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

5746: p_num_workers,
5747: l_verdict);
5748: IF l_verdict <> FND_API.G_TRUE THEN
5749: IF l_fail_fast THEN
5750: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5751: x_verdict := l_verdict;
5752: RETURN;
5753: END IF;
5754: END IF;

Line 5757: fnd_oam_debug.log(1, l_ctxt, 'Done - Duration: '||(l_end - l_start)/100|| ' seconds.');

5753: END IF;
5754: END IF;
5755:
5756: l_end := DBMS_UTILITY.GET_TIME;
5757: fnd_oam_debug.log(1, l_ctxt, 'Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
5758:
5759: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5760: x_verdict := l_verdict;
5761: EXCEPTION

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

5755:
5756: l_end := DBMS_UTILITY.GET_TIME;
5757: fnd_oam_debug.log(1, l_ctxt, 'Done - Duration: '||(l_end - l_start)/100|| ' seconds.');
5758:
5759: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5760: x_verdict := l_verdict;
5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

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

5759: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5760: x_verdict := l_verdict;
5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
5764: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5765: x_verdict := FND_API.G_FALSE;
5766: END;
5767:

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

5760: x_verdict := l_verdict;
5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
5764: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
5765: x_verdict := FND_API.G_FALSE;
5766: END;
5767:
5768: END FND_OAM_DSCRAM_DIAG_PKG;