144: --debug
145: xnb_debug.log('gen_item_batch_file','After construct_sql function returns');
146:
147: --The location of the Output File is set in the profile.
148: fnd_profile.get('XNB_ITEM_FILE_LOCATION', l_output_loc);
149: --debug
150: xnb_debug.log('gen_item_batch_file','After getting File Location'||l_output_loc);
151:
152: IF l_output_loc is null then
849: --1. .CSV or
850: --2. .XML
851: -----------------------------------------------------------------------
852:
853: fnd_profile.get('XNB_MSG_TYPE',l_msg_type);
854:
855: --debug
856: xnb_debug.log('publish_item','Value of Message Type '||l_msg_type);
857: