DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on FND_FILE

Line 1111: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRuleExecPkgs');

1107: , p_pkg_type => 'B'
1108: );
1109:
1110: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
1111: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRuleExecPkgs');
1112: ELSE
1113: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRuleExecPkgs:');
1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error
1115: retcode := 1;

Line 1113: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRuleExecPkgs:');

1109:
1110: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
1111: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRuleExecPkgs');
1112: ELSE
1113: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRuleExecPkgs:');
1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error
1115: retcode := 1;
1116:
1117: FOR i IN 1 .. l_msg_count LOOP

Line 1118: --fnd_file.put_line(fnd_file.LOG, 'Error:');

1114: X_RETURN_STATUS := fnd_api.g_ret_sts_error; -- Expected Error
1115: retcode := 1;
1116:
1117: FOR i IN 1 .. l_msg_count LOOP
1118: --fnd_file.put_line(fnd_file.LOG, 'Error:');
1119: l_error_string := fnd_message.get;
1120: --fnd_file.put_line(fnd_file.LOG, l_error_string);
1121: errbuf := errbuf || ' Error: GenerateRuleExecPkgs ' || l_error_string;
1122: END LOOP;

Line 1120: --fnd_file.put_line(fnd_file.LOG, l_error_string);

1116:
1117: FOR i IN 1 .. l_msg_count LOOP
1118: --fnd_file.put_line(fnd_file.LOG, 'Error:');
1119: l_error_string := fnd_message.get;
1120: --fnd_file.put_line(fnd_file.LOG, l_error_string);
1121: errbuf := errbuf || ' Error: GenerateRuleExecPkgs ' || l_error_string;
1122: END LOOP;
1123: END IF;
1124: EXCEPTION

Line 1133: --fnd_file.put_line(fnd_file.LOG, 'Exception');

1129: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BuildRulePkg');
1130: END IF;
1131:
1132: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1133: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1134: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
1135: errbuf := errbuf || 'Error in BuildRulesPkg:' || l_msg_data;
1136: END buildrulespkg;
1137:

Line 1134: --fnd_file.put_line(fnd_file.LOG, l_msg_data);

1130: END IF;
1131:
1132: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1133: --fnd_file.put_line(fnd_file.LOG, 'Exception');
1134: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
1135: errbuf := errbuf || 'Error in BuildRulesPkg:' || l_msg_data;
1136: END buildrulespkg;
1137:
1138: --

Line 14910: --fnd_file.put_names('genall.log', 'genall.out', '/home/jcearley/work/');

14906: FROM wms_rules_b
14907: WHERE enabled_flag = 'Y'
14908: ORDER BY rule_id;
14909: BEGIN
14910: --fnd_file.put_names('genall.log', 'genall.out', '/home/jcearley/work/');
14911: retcode := 0;
14912: --fnd_file.put_line(fnd_file.LOG, '===Compiling All Rule Packages===');
14913: OPEN l_enabled_rules;
14914:

Line 14912: --fnd_file.put_line(fnd_file.LOG, '===Compiling All Rule Packages===');

14908: ORDER BY rule_id;
14909: BEGIN
14910: --fnd_file.put_names('genall.log', 'genall.out', '/home/jcearley/work/');
14911: retcode := 0;
14912: --fnd_file.put_line(fnd_file.LOG, '===Compiling All Rule Packages===');
14913: OPEN l_enabled_rules;
14914:
14915: LOOP
14916: FETCH l_enabled_rules INTO l_rule_id;

Line 14918: --fnd_file.put_line(fnd_file.LOG, 'Compiling Rule ID= ' || l_rule_id);

14914:
14915: LOOP
14916: FETCH l_enabled_rules INTO l_rule_id;
14917: EXIT WHEN l_enabled_rules%NOTFOUND;
14918: --fnd_file.put_line(fnd_file.LOG, 'Compiling Rule ID= ' || l_rule_id);
14919: wms_rule_pvt.generaterulepackage(
14920: p_api_version => 1.0
14921: , p_init_msg_list => fnd_api.g_true
14922: , p_validation_level => fnd_api.g_valid_level_full

Line 14935: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRulePackage');

14931: -- Used FND APIs to check the return status of the called procedure
14932: -- instead of using hard coded values.
14933: --
14934: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14935: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRulePackage');
14936: ELSE
14937: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRulePackage:');
14938: retcode := 1;
14939:

Line 14937: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRulePackage:');

14933: --
14934: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14935: FND_FILE.put_line(FND_FILE.LOG, 'Success from GenerateRulePackage');
14936: ELSE
14937: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRulePackage:');
14938: retcode := 1;
14939:
14940: FOR i IN 1 .. l_msg_count LOOP
14941: --fnd_file.put_line(fnd_file.LOG, 'Error:');

Line 14941: --fnd_file.put_line(fnd_file.LOG, 'Error:');

14937: FND_FILE.put_line(FND_FILE.LOG, 'Error from GenerateRulePackage:');
14938: retcode := 1;
14939:
14940: FOR i IN 1 .. l_msg_count LOOP
14941: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14942: l_error_string := fnd_message.get;
14943: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14944: errbuf := errbuf || ' Error: Rule ' || l_rule_id || '
14945: ' || l_error_string;

Line 14943: --fnd_file.put_line(fnd_file.LOG, l_error_string);

14939:
14940: FOR i IN 1 .. l_msg_count LOOP
14941: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14942: l_error_string := fnd_message.get;
14943: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14944: errbuf := errbuf || ' Error: Rule ' || l_rule_id || '
14945: ' || l_error_string;
14946: END LOOP;
14947: END IF;

Line 14955: FND_FILE.put_line(FND_FILE.LOG, 'Success from BuildRulesPkg');

14951: --- this package should be called stand alone .
14952: buildrulespkg(l_errbuf, l_return_code, l_return_status);
14953:
14954: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14955: FND_FILE.put_line(FND_FILE.LOG, 'Success from BuildRulesPkg');
14956: ELSE
14957: FND_FILE.put_line(FND_FILE.LOG, 'Error from BuildRulesPkg:');
14958: retcode := 1;
14959:

Line 14957: FND_FILE.put_line(FND_FILE.LOG, 'Error from BuildRulesPkg:');

14953:
14954: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
14955: FND_FILE.put_line(FND_FILE.LOG, 'Success from BuildRulesPkg');
14956: ELSE
14957: FND_FILE.put_line(FND_FILE.LOG, 'Error from BuildRulesPkg:');
14958: retcode := 1;
14959:
14960: FOR i IN 1 .. l_msg_count LOOP
14961: --fnd_file.put_line(fnd_file.LOG, 'Error:');

Line 14961: --fnd_file.put_line(fnd_file.LOG, 'Error:');

14957: FND_FILE.put_line(FND_FILE.LOG, 'Error from BuildRulesPkg:');
14958: retcode := 1;
14959:
14960: FOR i IN 1 .. l_msg_count LOOP
14961: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14962: l_error_string := fnd_message.get;
14963: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14964: errbuf := errbuf || ' Error: Creating WMS Rule List Package ' || l_error_string;
14965: END LOOP;

Line 14963: --fnd_file.put_line(fnd_file.LOG, l_error_string);

14959:
14960: FOR i IN 1 .. l_msg_count LOOP
14961: --fnd_file.put_line(fnd_file.LOG, 'Error:');
14962: l_error_string := fnd_message.get;
14963: --fnd_file.put_line(fnd_file.LOG, l_error_string);
14964: errbuf := errbuf || ' Error: Creating WMS Rule List Package ' || l_error_string;
14965: END LOOP;
14966: END IF;
14967: EXCEPTION

Line 14975: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');

14971: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Compile All Rule Packages');
14972: END IF;
14973:
14974: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
14975: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
14976: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
14977: errbuf := errbuf || 'Error: ' || l_msg_data;
14978: END compile_all_rule_packages;
14979:

Line 14976: --fnd_file.put_line(fnd_file.LOG, l_msg_data);

14972: END IF;
14973:
14974: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
14975: --fnd_file.put_line(fnd_file.LOG, 'Exception in compile_all_rule_packages');
14976: --fnd_file.put_line(fnd_file.LOG, l_msg_data);
14977: errbuf := errbuf || 'Error: ' || l_msg_data;
14978: END compile_all_rule_packages;
14979:
14980: --