7974: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7975: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||
7976: 'Error :'||SQLERRM);
7977: FND_MSG_PUB.ADD;
7978: APP_EXCEPTION.RAISE_EXCEPTION;
7979: END extract;
7980:
7981: --Old extract for testing purposes
7982: PROCEDURE extract(p_accounting_mode IN VARCHAR2) IS
8217: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8218: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||
8219: 'Error :'||SQLERRM);
8220: FND_MSG_PUB.ADD;
8221: APP_EXCEPTION.RAISE_EXCEPTION;
8222: END postprocessing;
8223:
8224:
8225:
8396: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8397: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||
8398: 'Error :'||SQLERRM);
8399: FND_MSG_PUB.ADD;
8400: APP_EXCEPTION.RAISE_EXCEPTION;
8401: END preaccounting;
8402:
8403:
8404: -- This routine is no longer usefull
8436: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8437: 'Procedure:arp_xla_extract_main_pkg.lock_documents_for_xla
8438: Error:'||SQLERRM);
8439: FND_MSG_PUB.ADD;
8440: -- APP_EXCEPTION.RAISE_EXCEPTION;
8441: RETURN 'ERROR';
8442: END locking_status;
8443:
8444:
8473: 'Procedure:arp_xla_extract_main_pkg.extract
8474: Mode:'||l_mode||'
8475: Error:'||SQLERRM);
8476: FND_MSG_PUB.ADD;
8477: -- APP_EXCEPTION.RAISE_EXCEPTION;
8478: RETURN 'ERROR';
8479: END extract_status;
8480:
8481:
8517: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8518: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
8519: Error: accounting is '||l_mode||' - mode should be D (Draft) or F (Final)');
8520: FND_MSG_PUB.ADD;
8521: -- APP_EXCEPTION.RAISE_EXCEPTION;
8522: RETURN 'ERROR';
8523: WHEN OTHERS THEN
8524: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8525: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8526: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
8527: Mode:'||l_mode||'
8528: Error:'||SQLERRM);
8529: FND_MSG_PUB.ADD;
8530: APP_EXCEPTION.RAISE_EXCEPTION;
8531: RETURN 'ERROR';
8532: END posting_ctl_status;
8533:
8534: