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_API

Line 419: AND valid_value_flag = FND_API.G_TRUE;

415: SELECT SUM(to_number(canonical_value))
416: INTO l_c2_sum
417: FROM fnd_oam_dscram_arg_values
418: WHERE arg_id = p_c2_arg_id
419: AND valid_value_flag = FND_API.G_TRUE;
420: ELSE
421: SELECT valid_value_flag, canonical_value
422: INTO l_valid_value_flag, l_canonical_value
423: FROM fnd_oam_dscram_args_b

Line 425: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

421: SELECT valid_value_flag, canonical_value
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);

Line 449: AND valid_value_flag = FND_API.G_TRUE;

445: SELECT SUM(to_number(canonical_value))
446: INTO l_c3_bad_count
447: FROM fnd_oam_dscram_arg_values
448: WHERE arg_id = p_c3_arg_id
449: AND valid_value_flag = FND_API.G_TRUE;
450: ELSE
451: SELECT valid_value_flag, canonical_value
452: INTO l_valid_value_flag, l_canonical_value
453: FROM fnd_oam_dscram_args_b

Line 455: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

451: SELECT valid_value_flag, canonical_value
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);

Line 480: AND valid_value_flag = FND_API.G_TRUE;

476: SELECT SUM(to_number(canonical_value))
477: INTO l_c4_bad_count
478: FROM fnd_oam_dscram_arg_values
479: WHERE arg_id = p_c4_arg_id
480: AND valid_value_flag = FND_API.G_TRUE;
481: ELSE
482: SELECT valid_value_flag, canonical_value
483: INTO l_valid_value_flag, l_canonical_value
484: FROM fnd_oam_dscram_args_b

Line 486: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

482: SELECT valid_value_flag, canonical_value
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);

Line 584: x_verdict := FND_API.G_TRUE;

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:
588: --loop over ids found, nuking

Line 604: x_verdict := FND_API.G_TRUE;

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;
607: END IF;
608: EXCEPTION

Line 606: x_verdict := FND_API.G_FALSE;

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;
607: END IF;
608: EXCEPTION
609: WHEN OTHERS THEN
610: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 612: x_verdict := FND_API.G_FALSE;

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:
616: -- helper to remove a list of global arguments since these would affect later tests

Line 649: p_target_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,

645:
646: --after a run is finished, validate that the dml entity completed as expected.
647: FUNCTION VALIDATE_DML_SUCCESS(p_run_id IN NUMBER,
648: p_dml_id IN NUMBER,
649: p_target_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
650: p_target_rows IN NUMBER DEFAULT -1)
651: RETURN BOOLEAN
652: IS
653: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_DML_SUCCESS';

Line 697: p_target_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)

693:
694: --after a run is finished, validate that the dml entity completed as expected.
695: FUNCTION VALIDATE_PLSQL_SUCCESS(p_run_id IN NUMBER,
696: p_plsql_id IN NUMBER,
697: p_target_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
698: RETURN BOOLEAN
699: IS
700: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_PLSQL_SUCCESS';
701:

Line 940: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,

936: p_num_dmls IN NUMBER DEFAULT -1,
937: p_num_dml_rows IN NUMBER DEFAULT -1,
938: p_num_plsqls IN NUMBER DEFAULT -1,
939: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
940: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
941: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
942: RETURN BOOLEAN
943: IS
944: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_UNIT_RECURSIVE';

Line 941: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)

937: p_num_dml_rows IN NUMBER DEFAULT -1,
938: p_num_plsqls IN NUMBER DEFAULT -1,
939: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
940: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
941: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
942: RETURN BOOLEAN
943: IS
944: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_UNIT_RECURSIVE';
945: l_run_stat_id NUMBER;

Line 1039: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,

1035: p_num_dml_rows IN NUMBER DEFAULT -1,
1036: p_num_plsqls IN NUMBER DEFAULT -1,
1037: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1038: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1039: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1040: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1041:
1042: RETURN BOOLEAN
1043: IS

Line 1040: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)

1036: p_num_plsqls IN NUMBER DEFAULT -1,
1037: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1038: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1039: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1040: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1041:
1042: RETURN BOOLEAN
1043: IS
1044: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_TASK_RECURSIVE';

Line 1119: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,

1115: p_num_plsqls IN NUMBER DEFAULT -1,
1116: p_bundle_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1117: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1118: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1119: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1120: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1121:
1122: RETURN BOOLEAN
1123: IS

Line 1120: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)

1116: p_bundle_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1117: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1118: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1119: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1120: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1121:
1122: RETURN BOOLEAN
1123: IS
1124: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_BUNDLE_RECURSIVE';

Line 1200: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,

1196: p_run_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
1197: p_bundle_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1198: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1199: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1200: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1201: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1202: RETURN BOOLEAN
1203: IS
1204: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_RUN_RECURSIVE';

Line 1201: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)

1197: p_bundle_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1198: p_task_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1199: p_unit_status IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1200: p_dml_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS,
1201: p_plsql_status IN VARCHAR2 DEFAULT FND_API.G_RET_STS_SUCCESS)
1202: RETURN BOOLEAN
1203: IS
1204: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_RUN_RECURSIVE';
1205: l_run_stat_id NUMBER;

Line 1276: p_allow_override_source IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1272: FUNCTION MAKE_ARG(p_arg_name IN VARCHAR2,
1273: p_parent_type IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RUN,
1274: p_parent_id IN NUMBER DEFAULT NULL,
1275: p_init_success_flag IN VARCHAR2 DEFAULT NULL,
1276: p_allow_override_source IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1277: p_binding_enabled_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1278: p_permissions IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ,
1279: p_write_policy IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
1280: p_datatype IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,

Line 1277: p_binding_enabled_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1273: p_parent_type IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_RUN,
1274: p_parent_id IN NUMBER DEFAULT NULL,
1275: p_init_success_flag IN VARCHAR2 DEFAULT NULL,
1276: p_allow_override_source IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1277: p_binding_enabled_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1278: p_permissions IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ,
1279: p_write_policy IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
1280: p_datatype IN VARCHAR2 DEFAULT FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
1281: p_valid_value_flag IN VARCHAR2 DEFAULT NULL,

Line 1320: FND_API.G_TRUE,

1316: (fnd_oam_dscram_args_s.nextval,
1317: p_arg_name,
1318: p_parent_type,
1319: p_parent_id,
1320: FND_API.G_TRUE,
1321: p_init_success_flag,
1322: p_allow_override_source,
1323: p_binding_enabled_flag,
1324: p_permissions,

Line 1750: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1746: p_prestart_status => 'UNPROCESSED',
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:

Line 1936: IF l_msg <> FND_API.G_TRUE THEN

1932: END IF;
1933:
1934: --get the message, update the overall status if a worker failed
1935: DBMS_PIPE.UNPACK_MESSAGE(l_msg);
1936: IF l_msg <> FND_API.G_TRUE THEN
1937: l_retbool := FALSE;
1938: END IF;
1939:
1940: --increment the message received count

Line 1949: DBMS_PIPE.PACK_MESSAGE(FND_API.G_TRUE);

1945: l_retbool := l_retbool AND p_test_success;
1946: ELSE
1947: --if we didn't do the init, send our status on the pipe
1948: IF p_test_success THEN
1949: DBMS_PIPE.PACK_MESSAGE(FND_API.G_TRUE);
1950: ELSE
1951: DBMS_PIPE.PACK_MESSAGE(FND_API.G_FALSE);
1952: END IF;
1953: l_retval := DBMS_PIPE.SEND_MESSAGE(l_pipename,

Line 1951: DBMS_PIPE.PACK_MESSAGE(FND_API.G_FALSE);

1947: --if we didn't do the init, send our status on the pipe
1948: IF p_test_success THEN
1949: DBMS_PIPE.PACK_MESSAGE(FND_API.G_TRUE);
1950: ELSE
1951: DBMS_PIPE.PACK_MESSAGE(FND_API.G_FALSE);
1952: END IF;
1953: l_retval := DBMS_PIPE.SEND_MESSAGE(l_pipename,
1954: B_MAX_WAIT);
1955: IF l_retval <> 0 THEN

Line 1969: l_retbool := (l_msg = FND_API.G_TRUE);

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);
1970: END IF;
1971:
1972: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1973: RETURN l_retbool;

Line 1999: l_msg := FND_API.G_TRUE;

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;
2000: ELSE
2001: l_msg := FND_API.G_FALSE;
2002: END IF;
2003:

Line 2001: l_msg := FND_API.G_FALSE;

1997: --prep the ack message
1998: IF p_final_test_success THEN
1999: l_msg := FND_API.G_TRUE;
2000: ELSE
2001: l_msg := FND_API.G_FALSE;
2002: END IF;
2003:
2004: --send the messages
2005: WHILE k < l_num_msgs LOOP

Line 2112: RETURN x_return_status IN (FND_API.G_RET_STS_SUCCESS,

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,
2113: FND_OAM_DSCRAM_UTILS_PKG.G_RET_STS_PROCESSED);
2114: END;
2115:
2116: --helper to EXECUTE_TEST* to print some state on entry

Line 2211: x_verdict := FND_API.G_TRUE;

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;
2214: END IF;
2215: EXCEPTION

Line 2213: x_verdict := FND_API.G_FALSE;

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;
2214: END IF;
2215: EXCEPTION
2216: WHEN INIT_FAILED THEN
2217: --release the run lock on failure just in case

Line 2224: x_verdict := FND_API.G_FALSE;

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');
2228: x_verdict := FND_API.G_FALSE;

Line 2228: x_verdict := FND_API.G_FALSE;

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');
2232: x_verdict := FND_API.G_FALSE;

Line 2232: x_verdict := FND_API.G_FALSE;

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
2236: PROCEDURE EXECUTE_TEST2(p_run_id IN NUMBER DEFAULT 1,

Line 2318: x_verdict := FND_API.G_TRUE;

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;
2321: END IF;
2322: EXCEPTION

Line 2320: x_verdict := FND_API.G_FALSE;

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;
2321: END IF;
2322: EXCEPTION
2323: WHEN INIT_FAILED THEN
2324: --release the run lock on failure just in case

Line 2331: x_verdict := FND_API.G_FALSE;

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');
2335: x_verdict := FND_API.G_FALSE;

Line 2335: x_verdict := FND_API.G_FALSE;

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');
2339: x_verdict := FND_API.G_FALSE;

Line 2339: x_verdict := FND_API.G_FALSE;

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
2343: FUNCTION CLEANUP_TEST3(p_run_id IN NUMBER,

Line 2416: p_init_success_flag => FND_API.G_TRUE,

2412: --create a global arg
2413: l_arg_name := FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_GLOBAL_ARG1';
2414: IF NOT MAKE_ARG(p_arg_name => l_arg_name,
2415: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_GLOBAL,
2416: p_init_success_flag => FND_API.G_TRUE,
2417: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2418: p_valid_value_flag => FND_API.G_TRUE,
2419: p_canon_value => 'Value1',
2420: x_arg_id => l_retval) THEN

Line 2418: p_valid_value_flag => FND_API.G_TRUE,

2414: IF NOT MAKE_ARG(p_arg_name => l_arg_name,
2415: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_GLOBAL,
2416: p_init_success_flag => FND_API.G_TRUE,
2417: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2418: p_valid_value_flag => FND_API.G_TRUE,
2419: p_canon_value => 'Value1',
2420: x_arg_id => l_retval) THEN
2421: RAISE INIT_FAILED;
2422: END IF;

Line 2428: p_init_success_flag => FND_API.G_TRUE,

2424:
2425: --create a run arg
2426: IF NOT MAKE_ARG(p_arg_name => FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_RUN_ARG1',
2427: p_parent_id => p_run_id,
2428: p_init_success_flag => FND_API.G_TRUE,
2429: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
2430: p_valid_value_flag => FND_API.G_TRUE,
2431: p_canon_value => '123.45',
2432: x_arg_id => l_retval) THEN

Line 2430: p_valid_value_flag => FND_API.G_TRUE,

2426: IF NOT MAKE_ARG(p_arg_name => FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_RUN_ARG1',
2427: p_parent_id => p_run_id,
2428: p_init_success_flag => FND_API.G_TRUE,
2429: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
2430: p_valid_value_flag => FND_API.G_TRUE,
2431: p_canon_value => '123.45',
2432: x_arg_id => l_retval) THEN
2433: RAISE INIT_FAILED;
2434: END IF;

Line 2603: x_verdict := FND_API.G_TRUE;

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;
2606: END IF;
2607: EXCEPTION

Line 2605: x_verdict := FND_API.G_FALSE;

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;
2606: END IF;
2607: EXCEPTION
2608: WHEN INIT_FAILED THEN
2609: --release the run lock on failure just in case

Line 2619: x_verdict := FND_API.G_FALSE;

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,
2623: l_global_arg_names);

Line 2626: x_verdict := FND_API.G_FALSE;

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,
2630: l_global_arg_names);

Line 2633: x_verdict := FND_API.G_FALSE;

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
2637: FUNCTION VALIDATE_TEST4(p_run_id IN NUMBER,

Line 2814: x_verdict := FND_API.G_TRUE;

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;
2817: END IF;
2818: EXCEPTION

Line 2816: x_verdict := FND_API.G_FALSE;

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;
2817: END IF;
2818: EXCEPTION
2819: WHEN INIT_FAILED THEN
2820: --release the run lock on failure just in case

Line 2827: x_verdict := FND_API.G_FALSE;

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');
2831: x_verdict := FND_API.G_FALSE;

Line 2831: x_verdict := FND_API.G_FALSE;

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');
2835: x_verdict := FND_API.G_FALSE;

Line 2835: x_verdict := FND_API.G_FALSE;

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
2839: FUNCTION VALIDATE_TEST5(p_run_id IN NUMBER,

Line 3027: x_verdict := FND_API.G_TRUE;

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;
3030: END IF;
3031: EXCEPTION

Line 3029: x_verdict := FND_API.G_FALSE;

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;
3030: END IF;
3031: EXCEPTION
3032: WHEN INIT_FAILED THEN
3033: --release the run lock on failure just in case

Line 3040: x_verdict := FND_API.G_FALSE;

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');
3044: x_verdict := FND_API.G_FALSE;

Line 3044: x_verdict := FND_API.G_FALSE;

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');
3048: x_verdict := FND_API.G_FALSE;

Line 3048: x_verdict := FND_API.G_FALSE;

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
3052: FUNCTION VALIDATE_TEST6(p_run_id IN NUMBER,

Line 3111: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

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);
3113: RAISE VALIDATE_FAILED;
3114: END IF;
3115: l_c2_final_sum := FND_NUMBER.CANONICAL_TO_NUMBER(l_canonical_value);

Line 3127: AND valid_value_flag = FND_API.G_TRUE

3123: SELECT SUM(to_number(canonical_value))
3124: INTO l_c2_run_sum
3125: FROM fnd_oam_dscram_arg_values
3126: WHERE arg_id = p_c2_run_arg_id
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||'"))');

Line 3210: p_allow_override_source => FND_API.G_TRUE,

3206:
3207: --create a context arg to receive the final c2 sum
3208: IF NOT MAKE_ARG(p_arg_name => l_c2_final_arg_name,
3209: p_parent_id => p_run_id,
3210: p_allow_override_source => FND_API.G_TRUE,
3211: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
3212: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3213: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER,
3214: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_CONSTANT,

Line 3240: p_sug_disable_splitting => FND_API.G_FALSE,

3236: p_weight => 200,
3237: p_unit_obj_owner => B_TEST_TABLE_OWNER,
3238: p_unit_obj_name => l_test_table_name,
3239: p_batch_size => 100,
3240: p_sug_disable_splitting => FND_API.G_FALSE,
3241: x_unit_id => l_unit_id) THEN
3242: RAISE INIT_FAILED;
3243: END IF;
3244: --make a simple dml

Line 3319: x_verdict := FND_API.G_TRUE;

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;
3322: END IF;
3323: EXCEPTION

Line 3321: x_verdict := FND_API.G_FALSE;

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;
3322: END IF;
3323: EXCEPTION
3324: WHEN INIT_FAILED THEN
3325: --release the run lock on failure just in case

Line 3332: x_verdict := FND_API.G_FALSE;

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');
3336: x_verdict := FND_API.G_FALSE;

Line 3336: x_verdict := FND_API.G_FALSE;

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');
3340: x_verdict := FND_API.G_FALSE;

Line 3340: x_verdict := FND_API.G_FALSE;

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
3344: FUNCTION VALIDATE_TEST7(p_run_id IN NUMBER,

Line 3517: p_sug_disable_splitting => FND_API.G_FALSE,

3513: p_weight => 400,
3514: p_unit_obj_owner => B_TEST_TABLE_OWNER,
3515: p_unit_obj_name => l_test_table_name,
3516: p_batch_size => 100,
3517: p_sug_disable_splitting => FND_API.G_FALSE,
3518: x_unit_id => l_unit_id) THEN
3519: RAISE INIT_FAILED;
3520: END IF;
3521: --make the update dml first, but put priority such that it executes second

Line 3534: p_binding_enabled_flag => FND_API.G_TRUE,

3530: --make an input arg for the C2 arg
3531: IF NOT MAKE_ARG(p_arg_name => l_c2_arg_in_name,
3532: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
3533: p_parent_id => l_upd_dml_id,
3534: p_binding_enabled_flag => FND_API.G_TRUE,
3535: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
3536: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ,
3537: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
3538: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_CONSTANT,

Line 3559: p_binding_enabled_flag => FND_API.G_TRUE,

3555: --make an input arg for C3
3556: IF NOT MAKE_ARG(p_arg_name => l_c3_arg_in_name,
3557: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
3558: p_parent_id => l_upd_dml_id,
3559: p_binding_enabled_flag => FND_API.G_TRUE,
3560: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
3561: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3562: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER,
3563: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,

Line 3585: p_binding_enabled_flag => FND_API.G_TRUE,

3581: --make an input arg for C4
3582: IF NOT MAKE_ARG(p_arg_name => l_c4_arg_in_name,
3583: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
3584: p_parent_id => l_upd_dml_id,
3585: p_binding_enabled_flag => FND_API.G_TRUE,
3586: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE,
3587: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3588: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ALWAYS,
3589: p_src_type => NULL,

Line 3662: x_verdict := FND_API.G_TRUE;

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;
3665: END IF;
3666: EXCEPTION

Line 3664: x_verdict := FND_API.G_FALSE;

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;
3665: END IF;
3666: EXCEPTION
3667: WHEN INIT_FAILED THEN
3668: --release the run lock on failure just in case

Line 3675: x_verdict := FND_API.G_FALSE;

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');
3679: x_verdict := FND_API.G_FALSE;

Line 3679: x_verdict := FND_API.G_FALSE;

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');
3683: x_verdict := FND_API.G_FALSE;

Line 3683: x_verdict := FND_API.G_FALSE;

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
3687: FUNCTION VALIDATE_TEST8(p_run_id IN NUMBER,

Line 3722: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

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);
3724: RAISE VALIDATE_FAILED;
3725: END IF;
3726: IF l_canonical_value IS NULL OR l_canonical_value <> FND_API.G_TRUE THEN

Line 3726: IF l_canonical_value IS NULL OR l_canonical_value <> FND_API.G_TRUE THEN

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||')');
3728: RAISE VALIDATE_FAILED;
3729: END IF;
3730:

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 3776: x_verdict := FND_API.G_FALSE;

3772: l_unit_object_owner VARCHAR2(30);
3773: l_unit_object_name VARCHAR2(30);
3774: BEGIN
3775: --default to the failed status
3776: x_verdict := FND_API.G_FALSE;
3777: x_return_msg := '';
3778:
3779: --query out the run with this run_id, also validate run_mode
3780: BEGIN

Line 3854: IF l_disable_splitting IS NULL OR l_disable_splitting <> FND_API.G_TRUE THEN

3850: x_return_msg := 'Failed to query unit for task_id: '||p_task_id||', unit_id: '||p_unit_id;
3851: RETURN;
3852: END;
3853:
3854: IF l_disable_splitting IS NULL OR l_disable_splitting <> FND_API.G_TRUE THEN
3855: x_return_msg := 'Expected disable_splitting('||FND_API.G_TRUE||'), found disable_splitting('||l_disable_splitting||')';
3856: RETURN;
3857: END IF;
3858: IF p_using_splitting IS NULL OR p_using_splitting <> FND_API.G_FALSE THEN

Line 3855: x_return_msg := 'Expected disable_splitting('||FND_API.G_TRUE||'), found disable_splitting('||l_disable_splitting||')';

3851: RETURN;
3852: END;
3853:
3854: IF l_disable_splitting IS NULL OR l_disable_splitting <> FND_API.G_TRUE THEN
3855: x_return_msg := 'Expected disable_splitting('||FND_API.G_TRUE||'), found disable_splitting('||l_disable_splitting||')';
3856: RETURN;
3857: END IF;
3858: IF p_using_splitting IS NULL OR p_using_splitting <> FND_API.G_FALSE THEN
3859: x_return_msg := 'Expected using_splitting('||FND_API.G_TRUE||'), found using_splitting('||p_using_splitting||')';

Line 3858: IF p_using_splitting IS NULL OR p_using_splitting <> FND_API.G_FALSE THEN

3854: IF l_disable_splitting IS NULL OR l_disable_splitting <> FND_API.G_TRUE THEN
3855: x_return_msg := 'Expected disable_splitting('||FND_API.G_TRUE||'), found disable_splitting('||l_disable_splitting||')';
3856: RETURN;
3857: END IF;
3858: IF p_using_splitting IS NULL OR p_using_splitting <> FND_API.G_FALSE THEN
3859: x_return_msg := 'Expected using_splitting('||FND_API.G_TRUE||'), found using_splitting('||p_using_splitting||')';
3860: RETURN;
3861: END IF;
3862: IF l_workers_allowed IS NULL OR l_workers_allowed <> 1 THEN

Line 3859: x_return_msg := 'Expected using_splitting('||FND_API.G_TRUE||'), found using_splitting('||p_using_splitting||')';

3855: x_return_msg := 'Expected disable_splitting('||FND_API.G_TRUE||'), found disable_splitting('||l_disable_splitting||')';
3856: RETURN;
3857: END IF;
3858: IF p_using_splitting IS NULL OR p_using_splitting <> FND_API.G_FALSE THEN
3859: x_return_msg := 'Expected using_splitting('||FND_API.G_TRUE||'), found using_splitting('||p_using_splitting||')';
3860: RETURN;
3861: END IF;
3862: IF l_workers_allowed IS NULL OR l_workers_allowed <> 1 THEN
3863: x_return_msg := 'Expected database unit workers_allowed(1), found unit workers_allowed('||l_workers_allowed||')';

Line 3925: x_verdict := FND_API.G_TRUE;

3921: RETURN;
3922: END;
3923:
3924: --success
3925: x_verdict := FND_API.G_TRUE;
3926: EXCEPTION
3927: WHEN OTHERS THEN
3928: x_verdict := FND_API.G_FALSE;
3929: x_return_msg := SUBSTR('Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))', 1, 4000);

Line 3928: x_verdict := FND_API.G_FALSE;

3924: --success
3925: x_verdict := FND_API.G_TRUE;
3926: EXCEPTION
3927: WHEN OTHERS THEN
3928: x_verdict := FND_API.G_FALSE;
3929: x_return_msg := SUBSTR('Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))', 1, 4000);
3930: END;
3931:
3932: --Public

Line 4033: p_binding_enabled_flag => FND_API.G_TRUE,

4029: --make args for all the state variables
4030: IF NOT MAKE_ARG(p_arg_name => 'p_run_id',
4031: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4032: p_parent_id => l_plsql_id,
4033: p_binding_enabled_flag => FND_API.G_TRUE,
4034: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4035: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4036: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4037: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4045: p_binding_enabled_flag => FND_API.G_TRUE,

4041: END IF;
4042: IF NOT MAKE_ARG(p_arg_name => 'p_run_mode',
4043: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4044: p_parent_id => l_plsql_id,
4045: p_binding_enabled_flag => FND_API.G_TRUE,
4046: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4047: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4048: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4049: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4057: p_binding_enabled_flag => FND_API.G_TRUE,

4053: END IF;
4054: IF NOT MAKE_ARG(p_arg_name => 'p_bundle_id',
4055: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4056: p_parent_id => l_plsql_id,
4057: p_binding_enabled_flag => FND_API.G_TRUE,
4058: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4059: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4060: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4061: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4069: p_binding_enabled_flag => FND_API.G_TRUE,

4065: END IF;
4066: IF NOT MAKE_ARG(p_arg_name => 'p_bundle_workers_allowed',
4067: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4068: p_parent_id => l_plsql_id,
4069: p_binding_enabled_flag => FND_API.G_TRUE,
4070: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4071: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4072: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4073: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4081: p_binding_enabled_flag => FND_API.G_TRUE,

4077: END IF;
4078: IF NOT MAKE_ARG(p_arg_name => 'p_bundle_batch_size',
4079: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4080: p_parent_id => l_plsql_id,
4081: p_binding_enabled_flag => FND_API.G_TRUE,
4082: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4083: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4084: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4085: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4093: p_binding_enabled_flag => FND_API.G_TRUE,

4089: END IF;
4090: IF NOT MAKE_ARG(p_arg_name => 'p_worker_id',
4091: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4092: p_parent_id => l_plsql_id,
4093: p_binding_enabled_flag => FND_API.G_TRUE,
4094: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4095: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4096: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER,
4097: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4105: p_binding_enabled_flag => FND_API.G_TRUE,

4101: END IF;
4102: IF NOT MAKE_ARG(p_arg_name => 'p_task_id',
4103: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4104: p_parent_id => l_plsql_id,
4105: p_binding_enabled_flag => FND_API.G_TRUE,
4106: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4107: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4108: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4109: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4117: p_binding_enabled_flag => FND_API.G_TRUE,

4113: END IF;
4114: IF NOT MAKE_ARG(p_arg_name => 'p_unit_id',
4115: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4116: p_parent_id => l_plsql_id,
4117: p_binding_enabled_flag => FND_API.G_TRUE,
4118: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4119: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4120: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4121: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4129: p_binding_enabled_flag => FND_API.G_TRUE,

4125: END IF;
4126: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
4127: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4128: p_parent_id => l_plsql_id,
4129: p_binding_enabled_flag => FND_API.G_TRUE,
4130: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4131: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4132: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4133: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4141: p_binding_enabled_flag => FND_API.G_TRUE,

4137: END IF;
4138: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
4139: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4140: p_parent_id => l_plsql_id,
4141: p_binding_enabled_flag => FND_API.G_TRUE,
4142: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
4143: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4144: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4145: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4153: p_binding_enabled_flag => FND_API.G_TRUE,

4149: END IF;
4150: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
4151: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4152: p_parent_id => l_plsql_id,
4153: p_binding_enabled_flag => FND_API.G_TRUE,
4154: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
4155: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4156: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4157: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4165: p_binding_enabled_flag => FND_API.G_TRUE,

4161: END IF;
4162: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
4163: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4164: p_parent_id => l_plsql_id,
4165: p_binding_enabled_flag => FND_API.G_TRUE,
4166: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4167: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4168: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4169: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4177: p_binding_enabled_flag => FND_API.G_TRUE,

4173: END IF;
4174: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
4175: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4176: p_parent_id => l_plsql_id,
4177: p_binding_enabled_flag => FND_API.G_TRUE,
4178: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4179: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4180: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4181: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4189: p_binding_enabled_flag => FND_API.G_TRUE,

4185: END IF;
4186: IF NOT MAKE_ARG(p_arg_name => 'p_unit_workers_allowed',
4187: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4188: p_parent_id => l_plsql_id,
4189: p_binding_enabled_flag => FND_API.G_TRUE,
4190: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4191: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4192: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4193: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4201: p_binding_enabled_flag => FND_API.G_TRUE,

4197: END IF;
4198: IF NOT MAKE_ARG(p_arg_name => 'p_unit_batch_size',
4199: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4200: p_parent_id => l_plsql_id,
4201: p_binding_enabled_flag => FND_API.G_TRUE,
4202: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4203: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4204: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4205: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4213: p_binding_enabled_flag => FND_API.G_TRUE,

4209: END IF;
4210: IF NOT MAKE_ARG(p_arg_name => 'p_plsql_id',
4211: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4212: p_parent_id => l_plsql_id,
4213: p_binding_enabled_flag => FND_API.G_TRUE,
4214: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4215: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4216: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4217: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4225: p_binding_enabled_flag => FND_API.G_TRUE,

4221: END IF;
4222: IF NOT MAKE_ARG(p_arg_name => 'p_arg_id',
4223: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4224: p_parent_id => l_plsql_id,
4225: p_binding_enabled_flag => FND_API.G_TRUE,
4226: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4227: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4228: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4229: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4237: p_binding_enabled_flag => FND_API.G_TRUE,

4233: END IF;
4234: IF NOT MAKE_ARG(p_arg_name => 'p_workers_allowed',
4235: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4236: p_parent_id => l_plsql_id,
4237: p_binding_enabled_flag => FND_API.G_TRUE,
4238: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4239: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4240: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4241: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4249: p_binding_enabled_flag => FND_API.G_TRUE,

4245: END IF;
4246: IF NOT MAKE_ARG(p_arg_name => 'p_batch_size',
4247: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4248: p_parent_id => l_plsql_id,
4249: p_binding_enabled_flag => FND_API.G_TRUE,
4250: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4251: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4252: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4253: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4263: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also

4259: --make the return message var
4260: IF NOT MAKE_ARG(p_arg_name => 'x_return_msg',
4261: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4262: p_parent_id => l_plsql_id,
4263: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also
4264: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4265: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_WRITE,
4266: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4267: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_EXECUTION_CURSOR,

Line 4275: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also

4271: --make the verdict output arg
4272: IF NOT MAKE_ARG(p_arg_name => 'x_verdict',
4273: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4274: p_parent_id => l_plsql_id,
4275: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also
4276: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4277: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_WRITE,
4278: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4279: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_EXECUTION_CURSOR,

Line 4322: x_verdict := FND_API.G_TRUE;

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;
4325: END IF;
4326: EXCEPTION

Line 4324: x_verdict := FND_API.G_FALSE;

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;
4325: END IF;
4326: EXCEPTION
4327: WHEN INIT_FAILED THEN
4328: --release the run lock on failure just in case

Line 4335: x_verdict := FND_API.G_FALSE;

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');
4339: x_verdict := FND_API.G_FALSE;

Line 4339: x_verdict := FND_API.G_FALSE;

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');
4343: x_verdict := FND_API.G_FALSE;

Line 4343: x_verdict := FND_API.G_FALSE;

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
4347: FUNCTION VALIDATE_TEST9(p_run_id IN NUMBER,

Line 4409: AND (valid_value_flag IS NULL OR valid_value_flag <> FND_API.G_TRUE)

4405: SELECT COUNT(ROWID)
4406: INTO l_count
4407: FROM fnd_oam_dscram_arg_values
4408: WHERE arg_id = p_verdict_arg_id
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||'"))');

Line 4410: AND (canonical_value IS NULL OR canonical_value <> FND_API.G_TRUE);

4406: INTO l_count
4407: FROM fnd_oam_dscram_arg_values
4408: WHERE arg_id = p_verdict_arg_id
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;

Line 4428: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN

4424: SELECT valid_value_flag, canonical_value
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);

Line 4488: x_verdict := FND_API.G_FALSE;

4484: IS
4485: l_stmt VARCHAR2(4000);
4486: BEGIN
4487: --default to the failed status
4488: x_verdict := FND_API.G_FALSE;
4489: x_return_msg := '';
4490:
4491: --make sure we're splitting
4492: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

Line 4492: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

4488: x_verdict := FND_API.G_FALSE;
4489: x_return_msg := '';
4490:
4491: --make sure we're splitting
4492: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
4493: x_return_msg := 'Procedure expects splitting to be enabled, has value: '||p_using_splitting;
4494: RETURN;
4495: END IF;
4496:

Line 4508: x_verdict := FND_API.G_TRUE;

4504: RETURN;
4505: END;
4506:
4507: --success
4508: x_verdict := FND_API.G_TRUE;
4509: EXCEPTION
4510: WHEN OTHERS THEN
4511: x_verdict := FND_API.G_FALSE;
4512: x_return_msg := SUBSTR('Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))',1,4000);

Line 4511: x_verdict := FND_API.G_FALSE;

4507: --success
4508: x_verdict := FND_API.G_TRUE;
4509: EXCEPTION
4510: WHEN OTHERS THEN
4511: x_verdict := FND_API.G_FALSE;
4512: x_return_msg := SUBSTR('Unexpected Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))',1,4000);
4513: END;
4514:
4515: --Public

Line 4581: p_allow_override_source => FND_API.G_TRUE,

4577:
4578: --create a context arg to receive the final c2 sum
4579: IF NOT MAKE_ARG(p_arg_name => l_c2_inter_arg_name,
4580: p_parent_id => p_run_id,
4581: p_allow_override_source => FND_API.G_TRUE,
4582: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4583: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4584: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE, --can't be always, otherwise it won't use unit1's cached val
4585: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE, --shouldn't be used beyond print_context

Line 4633: p_binding_enabled_flag => FND_API.G_TRUE,

4629: END IF;
4630: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
4631: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4632: p_parent_id => l_plsql_id,
4633: p_binding_enabled_flag => FND_API.G_TRUE,
4634: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4635: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4636: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4637: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4645: p_binding_enabled_flag => FND_API.G_TRUE,

4641: END IF;
4642: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
4643: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4644: p_parent_id => l_plsql_id,
4645: p_binding_enabled_flag => FND_API.G_TRUE,
4646: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
4647: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4648: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4649: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4657: p_binding_enabled_flag => FND_API.G_TRUE,

4653: END IF;
4654: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
4655: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4656: p_parent_id => l_plsql_id,
4657: p_binding_enabled_flag => FND_API.G_TRUE,
4658: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
4659: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4660: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4661: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4669: p_binding_enabled_flag => FND_API.G_TRUE,

4665: END IF;
4666: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
4667: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4668: p_parent_id => l_plsql_id,
4669: p_binding_enabled_flag => FND_API.G_TRUE,
4670: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4671: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4672: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4673: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4681: p_binding_enabled_flag => FND_API.G_TRUE,

4677: END IF;
4678: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
4679: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4680: p_parent_id => l_plsql_id,
4681: p_binding_enabled_flag => FND_API.G_TRUE,
4682: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4683: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4684: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4685: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 4695: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also

4691: --make the return message var
4692: IF NOT MAKE_ARG(p_arg_name => 'x_return_msg',
4693: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4694: p_parent_id => l_plsql_id,
4695: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also
4696: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4697: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_WRITE,
4698: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4699: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_EXECUTION_CURSOR,

Line 4707: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also

4703: --make the verdict output arg
4704: IF NOT MAKE_ARG(p_arg_name => 'x_verdict',
4705: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
4706: p_parent_id => l_plsql_id,
4707: p_binding_enabled_flag => FND_API.G_TRUE, --outputs must be bound also
4708: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
4709: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_WRITE,
4710: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
4711: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_EXECUTION_CURSOR,

Line 4764: p_binding_enabled_flag => FND_API.G_TRUE,

4760: --make an input arg for the dml to fetch the sum from the first unit
4761: IF NOT MAKE_ARG(p_arg_name => l_c2_inter_arg_name,
4762: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
4763: p_parent_id => l_dml_id,
4764: p_binding_enabled_flag => FND_API.G_TRUE,
4765: p_allow_override_source => FND_API.G_TRUE,
4766: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4767: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4768: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,

Line 4765: p_allow_override_source => FND_API.G_TRUE,

4761: IF NOT MAKE_ARG(p_arg_name => l_c2_inter_arg_name,
4762: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
4763: p_parent_id => l_dml_id,
4764: p_binding_enabled_flag => FND_API.G_TRUE,
4765: p_allow_override_source => FND_API.G_TRUE,
4766: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER,
4767: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
4768: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
4769: p_src_type => NULL,

Line 4831: x_verdict := FND_API.G_TRUE;

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;
4834: END IF;
4835: EXCEPTION

Line 4833: x_verdict := FND_API.G_FALSE;

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;
4834: END IF;
4835: EXCEPTION
4836: WHEN INIT_FAILED THEN
4837: --release the run lock on failure just in case

Line 4844: x_verdict := FND_API.G_FALSE;

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');
4848: x_verdict := FND_API.G_FALSE;

Line 4848: x_verdict := FND_API.G_FALSE;

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');
4852: x_verdict := FND_API.G_FALSE;

Line 4852: x_verdict := FND_API.G_FALSE;

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
4856: FUNCTION VALIDATE_TEST10(p_run_id IN NUMBER,

Line 4954: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

4950: IS
4951: l_stmt VARCHAR2(4000);
4952: BEGIN
4953: --make sure we're splitting
4954: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
4955: RAISE VALUE_ERROR;
4956: END IF;
4957:
4958: -- set up the simple update statement

Line 4973: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

4969: IS
4970: l_stmt VARCHAR2(4000);
4971: BEGIN
4972: --make sure we're splitting
4973: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
4974: RAISE VALUE_ERROR;
4975: END IF;
4976:
4977: -- set up the simple update statement

Line 4994: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

4990: l_stmt VARCHAR2(4000);
4991: l_count NUMBER;
4992: BEGIN
4993: --make sure we're splitting
4994: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
4995: RAISE VALUE_ERROR;
4996: END IF;
4997:
4998: -- set up the simple update statement

Line 5014: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

5010: IS
5011: l_stmt VARCHAR2(4000);
5012: BEGIN
5013: --make sure we're splitting
5014: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
5015: RAISE VALUE_ERROR;
5016: END IF;
5017:
5018: -- set up the simple update statement

Line 5033: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN

5029: IS
5030: l_stmt VARCHAR2(4000);
5031: BEGIN
5032: --make sure we're splitting
5033: IF p_using_splitting IS NULL or p_using_splitting <> FND_API.G_TRUE THEN
5034: RAISE VALUE_ERROR;
5035: END IF;
5036:
5037: -- set up the simple update statement

Line 5151: p_binding_enabled_flag => FND_API.G_TRUE,

5147: END IF;
5148: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
5149: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5150: p_parent_id => l_plsql_id,
5151: p_binding_enabled_flag => FND_API.G_TRUE,
5152: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5153: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5154: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5155: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5163: p_binding_enabled_flag => FND_API.G_TRUE,

5159: END IF;
5160: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
5161: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5162: p_parent_id => l_plsql_id,
5163: p_binding_enabled_flag => FND_API.G_TRUE,
5164: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5165: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5166: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5167: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5175: p_binding_enabled_flag => FND_API.G_TRUE,

5171: END IF;
5172: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
5173: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5174: p_parent_id => l_plsql_id,
5175: p_binding_enabled_flag => FND_API.G_TRUE,
5176: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5177: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5178: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5179: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5187: p_binding_enabled_flag => FND_API.G_TRUE,

5183: END IF;
5184: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
5185: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5186: p_parent_id => l_plsql_id,
5187: p_binding_enabled_flag => FND_API.G_TRUE,
5188: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5189: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5190: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5191: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5199: p_binding_enabled_flag => FND_API.G_TRUE,

5195: END IF;
5196: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
5197: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5198: p_parent_id => l_plsql_id,
5199: p_binding_enabled_flag => FND_API.G_TRUE,
5200: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5201: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5202: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5203: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5223: p_binding_enabled_flag => FND_API.G_TRUE,

5219: END IF;
5220: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
5221: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5222: p_parent_id => l_plsql_id,
5223: p_binding_enabled_flag => FND_API.G_TRUE,
5224: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5225: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5226: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5227: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5235: p_binding_enabled_flag => FND_API.G_TRUE,

5231: END IF;
5232: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
5233: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5234: p_parent_id => l_plsql_id,
5235: p_binding_enabled_flag => FND_API.G_TRUE,
5236: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5237: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5238: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5239: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5247: p_binding_enabled_flag => FND_API.G_TRUE,

5243: END IF;
5244: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
5245: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5246: p_parent_id => l_plsql_id,
5247: p_binding_enabled_flag => FND_API.G_TRUE,
5248: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5249: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5250: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5251: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5259: p_binding_enabled_flag => FND_API.G_TRUE,

5255: END IF;
5256: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
5257: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5258: p_parent_id => l_plsql_id,
5259: p_binding_enabled_flag => FND_API.G_TRUE,
5260: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5261: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5262: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5263: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5271: p_binding_enabled_flag => FND_API.G_TRUE,

5267: END IF;
5268: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
5269: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5270: p_parent_id => l_plsql_id,
5271: p_binding_enabled_flag => FND_API.G_TRUE,
5272: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5273: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5274: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5275: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5329: p_binding_enabled_flag => FND_API.G_TRUE,

5325: END IF;
5326: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
5327: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
5328: p_parent_id => l_dml_id,
5329: p_binding_enabled_flag => FND_API.G_TRUE,
5330: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5331: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5332: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5333: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5341: p_binding_enabled_flag => FND_API.G_TRUE,

5337: END IF;
5338: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
5339: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
5340: p_parent_id => l_dml_id,
5341: p_binding_enabled_flag => FND_API.G_TRUE,
5342: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5343: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5344: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5345: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5378: p_binding_enabled_flag => FND_API.G_TRUE,

5374: END IF;
5375: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
5376: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5377: p_parent_id => l_plsql_id,
5378: p_binding_enabled_flag => FND_API.G_TRUE,
5379: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5380: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5381: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5382: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5390: p_binding_enabled_flag => FND_API.G_TRUE,

5386: END IF;
5387: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
5388: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5389: p_parent_id => l_plsql_id,
5390: p_binding_enabled_flag => FND_API.G_TRUE,
5391: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5392: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5393: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5394: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5402: p_binding_enabled_flag => FND_API.G_TRUE,

5398: END IF;
5399: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
5400: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5401: p_parent_id => l_plsql_id,
5402: p_binding_enabled_flag => FND_API.G_TRUE,
5403: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5404: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5405: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5406: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5414: p_binding_enabled_flag => FND_API.G_TRUE,

5410: END IF;
5411: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
5412: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5413: p_parent_id => l_plsql_id,
5414: p_binding_enabled_flag => FND_API.G_TRUE,
5415: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5416: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5417: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5418: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5426: p_binding_enabled_flag => FND_API.G_TRUE,

5422: END IF;
5423: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
5424: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5425: p_parent_id => l_plsql_id,
5426: p_binding_enabled_flag => FND_API.G_TRUE,
5427: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5428: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5429: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5430: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5450: p_binding_enabled_flag => FND_API.G_TRUE,

5446: END IF;
5447: IF NOT MAKE_ARG(p_arg_name => 'p_using_splitting',
5448: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5449: p_parent_id => l_plsql_id,
5450: p_binding_enabled_flag => FND_API.G_TRUE,
5451: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5452: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5453: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5454: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5462: p_binding_enabled_flag => FND_API.G_TRUE,

5458: END IF;
5459: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_lbound',
5460: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5461: p_parent_id => l_plsql_id,
5462: p_binding_enabled_flag => FND_API.G_TRUE,
5463: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5464: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5465: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5466: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5474: p_binding_enabled_flag => FND_API.G_TRUE,

5470: END IF;
5471: IF NOT MAKE_ARG(p_arg_name => 'p_rowid_ubound',
5472: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5473: p_parent_id => l_plsql_id,
5474: p_binding_enabled_flag => FND_API.G_TRUE,
5475: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
5476: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5477: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
5478: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5486: p_binding_enabled_flag => FND_API.G_TRUE,

5482: END IF;
5483: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_owner',
5484: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5485: p_parent_id => l_plsql_id,
5486: p_binding_enabled_flag => FND_API.G_TRUE,
5487: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5488: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5489: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5490: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5498: p_binding_enabled_flag => FND_API.G_TRUE,

5494: END IF;
5495: IF NOT MAKE_ARG(p_arg_name => 'p_unit_object_name',
5496: p_parent_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
5497: p_parent_id => l_plsql_id,
5498: p_binding_enabled_flag => FND_API.G_TRUE,
5499: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
5500: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
5501: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
5502: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_STATE,

Line 5551: x_verdict := FND_API.G_TRUE;

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;
5554: END IF;
5555: EXCEPTION

Line 5553: x_verdict := FND_API.G_FALSE;

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;
5554: END IF;
5555: EXCEPTION
5556: WHEN INIT_FAILED THEN
5557: --release the run lock on failure just in case

Line 5564: x_verdict := FND_API.G_FALSE;

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');
5568: x_verdict := FND_API.G_FALSE;

Line 5568: x_verdict := FND_API.G_FALSE;

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');
5572: x_verdict := FND_API.G_FALSE;

Line 5572: x_verdict := FND_API.G_FALSE;

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
5576: PROCEDURE EXECUTE_ALL_TESTS(p_run_id IN NUMBER,

Line 5604: IF l_verdict <> FND_API.G_TRUE THEN

5600: l_bundle_id,
5601: p_num_bundles,
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;

Line 5620: IF l_verdict <> FND_API.G_TRUE THEN

5616: l_bundle_id,
5617: p_num_bundles,
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;

Line 5636: IF l_verdict <> FND_API.G_TRUE THEN

5632: l_bundle_id,
5633: p_num_bundles,
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;

Line 5652: IF l_verdict <> FND_API.G_TRUE THEN

5648: l_bundle_id,
5649: p_num_bundles,
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;

Line 5668: IF l_verdict <> FND_API.G_TRUE THEN

5664: l_bundle_id,
5665: p_num_bundles,
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;

Line 5684: IF l_verdict <> FND_API.G_TRUE THEN

5680: l_bundle_id,
5681: p_num_bundles,
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;

Line 5700: IF l_verdict <> FND_API.G_TRUE THEN

5696: l_bundle_id,
5697: p_num_bundles,
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;

Line 5716: IF l_verdict <> FND_API.G_TRUE THEN

5712: l_bundle_id,
5713: p_num_bundles,
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;

Line 5732: IF l_verdict <> FND_API.G_TRUE THEN

5728: l_bundle_id,
5729: p_num_bundles,
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;

Line 5748: IF l_verdict <> FND_API.G_TRUE THEN

5744: l_bundle_id,
5745: p_num_bundles,
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;

Line 5765: x_verdict := FND_API.G_FALSE;

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;