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 636: fnd_file.put_line(FND_FILE.LOG,' ');

632: G_MODULE||l_api_name,
633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
634: END IF;
635:
636: fnd_file.put_line(FND_FILE.LOG,' ');
637: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
638: fnd_file.put_line(FND_FILE.LOG,' ');
639:
640: x_return_status := G_RET_STS_ERROR ;

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

633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
634: END IF;
635:
636: fnd_file.put_line(FND_FILE.LOG,' ');
637: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
638: fnd_file.put_line(FND_FILE.LOG,' ');
639:
640: x_return_status := G_RET_STS_ERROR ;
641: x_msg_data := SQLERRM;

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

634: END IF;
635:
636: fnd_file.put_line(FND_FILE.LOG,' ');
637: fnd_file.put_line(FND_FILE.LOG,'Error in build_statement_rule '||SQLERRM);
638: fnd_file.put_line(FND_FILE.LOG,' ');
639:
640: x_return_status := G_RET_STS_ERROR ;
641: x_msg_data := SQLERRM;
642:

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

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

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

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

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

650: END IF;
651:
652: fnd_file.put_line(FND_FILE.LOG,' ');
653: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_statement_rule '||SQLERRM);
654: fnd_file.put_line(FND_FILE.LOG,' ');
655:
656: x_return_status := G_RET_STS_UNEXP_ERROR ;
657: x_msg_data := SQLERRM;
658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

663: G_MODULE||l_api_name,
664: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
665: END IF;
666:
667: fnd_file.put_line(FND_FILE.LOG,' ');
668: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
669: fnd_file.put_line(FND_FILE.LOG,' ');
670:
671: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

664: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
665: END IF;
666:
667: fnd_file.put_line(FND_FILE.LOG,' ');
668: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
669: fnd_file.put_line(FND_FILE.LOG,' ');
670:
671: x_return_status := G_RET_STS_UNEXP_ERROR ;
672: x_msg_data := SQLERRM;

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

665: END IF;
666:
667: fnd_file.put_line(FND_FILE.LOG,' ');
668: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
669: fnd_file.put_line(FND_FILE.LOG,' ');
670:
671: x_return_status := G_RET_STS_UNEXP_ERROR ;
672: x_msg_data := SQLERRM;
673: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1177: G_MODULE||l_api_name,
1178: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1179: END IF;
1180:
1181: fnd_file.put_line(FND_FILE.LOG,' ');
1182: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
1183: fnd_file.put_line(FND_FILE.LOG,' ');
1184:
1185: x_return_status := G_RET_STS_ERROR ;

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

1178: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1179: END IF;
1180:
1181: fnd_file.put_line(FND_FILE.LOG,' ');
1182: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_statement_rule '||SQLERRM);
1183: fnd_file.put_line(FND_FILE.LOG,' ');
1184:
1185: x_return_status := G_RET_STS_ERROR ;
1186: x_msg_data := SQLERRM;

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

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

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

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

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

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

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

1194: END IF;
1195:
1196: fnd_file.put_line(FND_FILE.LOG,' ');
1197: fnd_file.put_line(FND_FILE.LOG,'Unexpected Error in build_and_insert_rule '||SQLERRM);
1198: fnd_file.put_line(FND_FILE.LOG,' ');
1199:
1200: x_return_status := G_RET_STS_UNEXP_ERROR ;
1201: x_msg_data := SQLERRM;
1202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1207: G_MODULE||l_api_name,
1208: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1209: END IF;
1210:
1211: fnd_file.put_line(FND_FILE.LOG,' ');
1212: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1213: fnd_file.put_line(FND_FILE.LOG,' ');
1214:
1215: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1208: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1209: END IF;
1210:
1211: fnd_file.put_line(FND_FILE.LOG,' ');
1212: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1213: fnd_file.put_line(FND_FILE.LOG,' ');
1214:
1215: x_return_status := G_RET_STS_UNEXP_ERROR ;
1216: x_msg_data := SQLERRM;

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

1209: END IF;
1210:
1211: fnd_file.put_line(FND_FILE.LOG,' ');
1212: fnd_file.put_line(FND_FILE.LOG,'Other Error in build_and_insert_rule '||SQLERRM);
1213: fnd_file.put_line(FND_FILE.LOG,' ');
1214:
1215: x_return_status := G_RET_STS_UNEXP_ERROR ;
1216: x_msg_data := SQLERRM;
1217: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1822: G_MODULE||l_api_name,
1823: '2000: 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,'Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_ERROR ;

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

1823: '2000: 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,'Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_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,'Error in import_rule_temp_approval '||SQLERRM);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: x_return_status := G_RET_STS_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: '3000: 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,'Unexpected 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,'Unexpected Error in import_rule_temp_approval '||SQLERRM);

1837: '3000: 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,'Unexpected 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: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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,'Unexpected 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: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1846:

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

1850: G_MODULE||l_api_name,
1851: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1852: END IF;
1853:
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1856: fnd_file.put_line(FND_FILE.LOG,' ');
1857:
1858: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1851: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1852: END IF;
1853:
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1856: fnd_file.put_line(FND_FILE.LOG,' ');
1857:
1858: x_return_status := G_RET_STS_UNEXP_ERROR ;
1859: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1852: END IF;
1853:
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855: fnd_file.put_line(FND_FILE.LOG,'Other Error in import_rule_temp_approval '||SQLERRM);
1856: fnd_file.put_line(FND_FILE.LOG,' ');
1857:
1858: x_return_status := G_RET_STS_UNEXP_ERROR ;
1859: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1860: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

2033: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2034: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2035: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2036:
2037: fnd_file.put_line(FND_FILE.LOG,' ');
2038: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2039: fnd_file.put_line(FND_FILE.LOG,' ');
2040:
2041: -- Insert Rule Name into cz_imp_localized_texts

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

2034: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2035: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2036:
2037: fnd_file.put_line(FND_FILE.LOG,' ');
2038: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2039: fnd_file.put_line(FND_FILE.LOG,' ');
2040:
2041: -- Insert Rule Name into cz_imp_localized_texts
2042:

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

2035: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2036:
2037: fnd_file.put_line(FND_FILE.LOG,' ');
2038: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2039: fnd_file.put_line(FND_FILE.LOG,' ');
2040:
2041: -- Insert Rule Name into cz_imp_localized_texts
2042:
2043: OPEN csr_installed_languages;

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

2472: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2473: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2474: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2475:
2476: fnd_file.put_line(FND_FILE.LOG,' ');
2477: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2478: fnd_file.put_line(FND_FILE.LOG,' ');
2479:
2480: -- Insert Rule Name into cz_imp_localized_texts

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

2473: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2474: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2475:
2476: fnd_file.put_line(FND_FILE.LOG,' ');
2477: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2478: fnd_file.put_line(FND_FILE.LOG,' ');
2479:
2480: -- Insert Rule Name into cz_imp_localized_texts
2481:

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

2474: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2475:
2476: fnd_file.put_line(FND_FILE.LOG,' ');
2477: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2478: fnd_file.put_line(FND_FILE.LOG,' ');
2479:
2480: -- Insert Rule Name into cz_imp_localized_texts
2481:
2482: OPEN csr_installed_languages;