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.OKC_XPRT_IMPORT_RULES_PVT dependencies on FND_FILE

Line 622: fnd_file.put_line(FND_FILE.LOG,' ');

618: G_MODULE||l_api_name,
619: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
620: END IF;
621:
622: fnd_file.put_line(FND_FILE.LOG,' ');
623: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
624: fnd_file.put_line(FND_FILE.LOG,' ');
625:
626: x_return_status := G_RET_STS_ERROR ;

Line 623: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);

619: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
620: END IF;
621:
622: fnd_file.put_line(FND_FILE.LOG,' ');
623: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
624: fnd_file.put_line(FND_FILE.LOG,' ');
625:
626: x_return_status := G_RET_STS_ERROR ;
627: x_msg_data := SQLERRM;

Line 624: fnd_file.put_line(FND_FILE.LOG,' ');

620: END IF;
621:
622: fnd_file.put_line(FND_FILE.LOG,' ');
623: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
624: fnd_file.put_line(FND_FILE.LOG,' ');
625:
626: x_return_status := G_RET_STS_ERROR ;
627: x_msg_data := SQLERRM;
628:

Line 638: fnd_file.put_line(FND_FILE.LOG,' ');

634: G_MODULE||l_api_name,
635: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;
637:
638: fnd_file.put_line(FND_FILE.LOG,' ');
639: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_statement_rule '||SQLERRM);
640: fnd_file.put_line(FND_FILE.LOG,' ');
641:
642: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 639: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_statement_rule '||SQLERRM);

635: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;
637:
638: fnd_file.put_line(FND_FILE.LOG,' ');
639: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_statement_rule '||SQLERRM);
640: fnd_file.put_line(FND_FILE.LOG,' ');
641:
642: x_return_status := G_RET_STS_UNEXP_ERROR ;
643: x_msg_data := SQLERRM;

Line 640: fnd_file.put_line(FND_FILE.LOG,' ');

636: END IF;
637:
638: fnd_file.put_line(FND_FILE.LOG,' ');
639: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_statement_rule '||SQLERRM);
640: fnd_file.put_line(FND_FILE.LOG,' ');
641:
642: x_return_status := G_RET_STS_UNEXP_ERROR ;
643: x_msg_data := SQLERRM;
644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 653: fnd_file.put_line(FND_FILE.LOG,' ');

649: G_MODULE||l_api_name,
650: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
651: END IF;
652:
653: fnd_file.put_line(FND_FILE.LOG,' ');
654: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
655: fnd_file.put_line(FND_FILE.LOG,' ');
656:
657: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 654: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);

650: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
651: END IF;
652:
653: fnd_file.put_line(FND_FILE.LOG,' ');
654: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
655: fnd_file.put_line(FND_FILE.LOG,' ');
656:
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: x_msg_data := SQLERRM;

Line 655: fnd_file.put_line(FND_FILE.LOG,' ');

651: END IF;
652:
653: fnd_file.put_line(FND_FILE.LOG,' ');
654: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
655: fnd_file.put_line(FND_FILE.LOG,' ');
656:
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: x_msg_data := SQLERRM;
659: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1167: fnd_file.put_line(FND_FILE.LOG,' ');

1163: G_MODULE||l_api_name,
1164: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1165: END IF;
1166:
1167: fnd_file.put_line(FND_FILE.LOG,' ');
1168: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
1169: fnd_file.put_line(FND_FILE.LOG,' ');
1170:
1171: x_return_status := G_RET_STS_ERROR ;

Line 1168: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);

1164: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1165: END IF;
1166:
1167: fnd_file.put_line(FND_FILE.LOG,' ');
1168: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
1169: fnd_file.put_line(FND_FILE.LOG,' ');
1170:
1171: x_return_status := G_RET_STS_ERROR ;
1172: x_msg_data := SQLERRM;

Line 1169: fnd_file.put_line(FND_FILE.LOG,' ');

1165: END IF;
1166:
1167: fnd_file.put_line(FND_FILE.LOG,' ');
1168: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
1169: fnd_file.put_line(FND_FILE.LOG,' ');
1170:
1171: x_return_status := G_RET_STS_ERROR ;
1172: x_msg_data := SQLERRM;
1173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1182: fnd_file.put_line(FND_FILE.LOG,' ');

1178: G_MODULE||l_api_name,
1179: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1180: END IF;
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_and_insert_rule '||SQLERRM);
1184: fnd_file.put_line(FND_FILE.LOG,' ');
1185:
1186: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1183: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_and_insert_rule '||SQLERRM);

1179: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1180: END IF;
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_and_insert_rule '||SQLERRM);
1184: fnd_file.put_line(FND_FILE.LOG,' ');
1185:
1186: x_return_status := G_RET_STS_UNEXP_ERROR ;
1187: x_msg_data := SQLERRM;

Line 1184: fnd_file.put_line(FND_FILE.LOG,' ');

1180: END IF;
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_and_insert_rule '||SQLERRM);
1184: fnd_file.put_line(FND_FILE.LOG,' ');
1185:
1186: x_return_status := G_RET_STS_UNEXP_ERROR ;
1187: x_msg_data := SQLERRM;
1188: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1197: fnd_file.put_line(FND_FILE.LOG,' ');

1193: G_MODULE||l_api_name,
1194: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1199: fnd_file.put_line(FND_FILE.LOG,' ');
1200:
1201: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1198: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);

1194: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1199: fnd_file.put_line(FND_FILE.LOG,' ');
1200:
1201: x_return_status := G_RET_STS_UNEXP_ERROR ;
1202: x_msg_data := SQLERRM;

Line 1199: fnd_file.put_line(FND_FILE.LOG,' ');

1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1199: fnd_file.put_line(FND_FILE.LOG,' ');
1200:
1201: x_return_status := G_RET_STS_UNEXP_ERROR ;
1202: x_msg_data := SQLERRM;
1203: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1812: fnd_file.put_line(FND_FILE.LOG,' ');

1808: G_MODULE||l_api_name,
1809: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1810: END IF;
1811:
1812: fnd_file.put_line(FND_FILE.LOG,' ');
1813: fnd_file.put_line(FND_FILE.LOG,'Error in import_rule_temp_approval '||SQLERRM);
1814: fnd_file.put_line(FND_FILE.LOG,' ');
1815:
1816: x_return_status := G_RET_STS_ERROR ;

Line 1813: fnd_file.put_line(FND_FILE.LOG,'Error in import_rule_temp_approval '||SQLERRM);

1809: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1810: END IF;
1811:
1812: fnd_file.put_line(FND_FILE.LOG,' ');
1813: fnd_file.put_line(FND_FILE.LOG,'Error in import_rule_temp_approval '||SQLERRM);
1814: fnd_file.put_line(FND_FILE.LOG,' ');
1815:
1816: x_return_status := G_RET_STS_ERROR ;
1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1814: fnd_file.put_line(FND_FILE.LOG,' ');

1810: END IF;
1811:
1812: fnd_file.put_line(FND_FILE.LOG,' ');
1813: fnd_file.put_line(FND_FILE.LOG,'Error in import_rule_temp_approval '||SQLERRM);
1814: fnd_file.put_line(FND_FILE.LOG,' ');
1815:
1816: x_return_status := G_RET_STS_ERROR ;
1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:

Line 1826: fnd_file.put_line(FND_FILE.LOG,' ');

1822: G_MODULE||l_api_name,
1823: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;
1825:
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1827: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in import_rule_temp_approval '||SQLERRM);

1823: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;
1825:
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_UNEXP_ERROR ;
1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1828: fnd_file.put_line(FND_FILE.LOG,' ');

1824: END IF;
1825:
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_UNEXP_ERROR ;
1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1832:

Line 1840: fnd_file.put_line(FND_FILE.LOG,' ');

1836: G_MODULE||l_api_name,
1837: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1838: END IF;
1839:
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1842: fnd_file.put_line(FND_FILE.LOG,' ');
1843:
1844: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1841: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);

1837: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1838: END IF;
1839:
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1842: fnd_file.put_line(FND_FILE.LOG,' ');
1843:
1844: x_return_status := G_RET_STS_UNEXP_ERROR ;
1845: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1842: fnd_file.put_line(FND_FILE.LOG,' ');

1838: END IF;
1839:
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1842: fnd_file.put_line(FND_FILE.LOG,' ');
1843:
1844: x_return_status := G_RET_STS_UNEXP_ERROR ;
1845: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 2023: fnd_file.put_line(FND_FILE.LOG,' ');

2019: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2020: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2021: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2022:
2023: fnd_file.put_line(FND_FILE.LOG,' ');
2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2025: fnd_file.put_line(FND_FILE.LOG,' ');
2026:
2027: -- Insert Rule Name into cz_imp_localized_texts

Line 2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);

2020: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2021: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2022:
2023: fnd_file.put_line(FND_FILE.LOG,' ');
2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2025: fnd_file.put_line(FND_FILE.LOG,' ');
2026:
2027: -- Insert Rule Name into cz_imp_localized_texts
2028:

Line 2025: fnd_file.put_line(FND_FILE.LOG,' ');

2021: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2022:
2023: fnd_file.put_line(FND_FILE.LOG,' ');
2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2025: fnd_file.put_line(FND_FILE.LOG,' ');
2026:
2027: -- Insert Rule Name into cz_imp_localized_texts
2028:
2029: OPEN csr_installed_languages;

Line 2462: fnd_file.put_line(FND_FILE.LOG,' ');

2458: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2459: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2460: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2461:
2462: fnd_file.put_line(FND_FILE.LOG,' ');
2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2464: fnd_file.put_line(FND_FILE.LOG,' ');
2465:
2466: -- Insert Rule Name into cz_imp_localized_texts

Line 2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);

2459: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2460: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2461:
2462: fnd_file.put_line(FND_FILE.LOG,' ');
2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2464: fnd_file.put_line(FND_FILE.LOG,' ');
2465:
2466: -- Insert Rule Name into cz_imp_localized_texts
2467:

Line 2464: fnd_file.put_line(FND_FILE.LOG,' ');

2460: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2461:
2462: fnd_file.put_line(FND_FILE.LOG,' ');
2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2464: fnd_file.put_line(FND_FILE.LOG,' ');
2465:
2466: -- Insert Rule Name into cz_imp_localized_texts
2467:
2468: OPEN csr_installed_languages;