400: name => 'JAI_GENERIC_MSG'
401: );
402:
403: fnd_message.set_token ( token => 'MSG_TEXT',
404: value => 'Exception Occured in ' || ' Object = JAI_OM_WDD_PROCESSING_PKG.DELIVER_DETAILS'||fnd_global.local_chr(10)||SQLERRM
405: );
406:
407: app_exception.raise_exception;
408:
2250: NULL,
2251: v_currency_code,
2252: NULL,
2253: sysdate,
2254: FND_GLOBAL.user_id,
2255: sysdate,
2256: fnd_global.user_id,
2257: fnd_global.login_id);
2258:
2252: NULL,
2253: sysdate,
2254: FND_GLOBAL.user_id,
2255: sysdate,
2256: fnd_global.user_id,
2257: fnd_global.login_id);
2258:
2259: -- pass a/c entry for 'credit rg23d account'
2260: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2253: sysdate,
2254: FND_GLOBAL.user_id,
2255: sysdate,
2256: fnd_global.user_id,
2257: fnd_global.login_id);
2258:
2259: -- pass a/c entry for 'credit rg23d account'
2260: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2261: p_currency_code => v_currency_code,
2318: NULL,
2319: v_currency_code,
2320: NULL,
2321: sysdate,
2322: FND_GLOBAL.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id);
2326:
2320: NULL,
2321: sysdate,
2322: FND_GLOBAL.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id);
2326:
2327: ELSE
2328: -- pass a/c entry for 'debit excise paid/payable account'
2321: sysdate,
2322: FND_GLOBAL.user_id,
2323: sysdate,
2324: fnd_global.user_id,
2325: fnd_global.login_id);
2326:
2327: ELSE
2328: -- pass a/c entry for 'debit excise paid/payable account'
2329: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2387: NULL,
2388: v_currency_code,
2389: NULL,
2390: sysdate,
2391: FND_GLOBAL.user_id,
2392: sysdate,
2393: fnd_global.user_id,
2394: fnd_global.login_id);
2395:
2389: NULL,
2390: sysdate,
2391: FND_GLOBAL.user_id,
2392: sysdate,
2393: fnd_global.user_id,
2394: fnd_global.login_id);
2395:
2396: -- pass a/c entry for 'debit cess paid/payable account'
2397: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2390: sysdate,
2391: FND_GLOBAL.user_id,
2392: sysdate,
2393: fnd_global.user_id,
2394: fnd_global.login_id);
2395:
2396: -- pass a/c entry for 'debit cess paid/payable account'
2397: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2398: p_currency_code => v_currency_code,
2455: NULL,
2456: v_currency_code,
2457: NULL,
2458: sysdate,
2459: FND_GLOBAL.user_id,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.login_id);
2463:
2457: NULL,
2458: sysdate,
2459: FND_GLOBAL.user_id,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.login_id);
2463:
2464: -- pass a/c entry for 'debit sh cess paid/payable account'
2465: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2458: sysdate,
2459: FND_GLOBAL.user_id,
2460: sysdate,
2461: fnd_global.user_id,
2462: fnd_global.login_id);
2463:
2464: -- pass a/c entry for 'debit sh cess paid/payable account'
2465: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2466: p_currency_code => v_currency_code,
2523: NULL,
2524: v_currency_code,
2525: NULL,
2526: sysdate,
2527: FND_GLOBAL.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id);
2531:
2525: NULL,
2526: sysdate,
2527: FND_GLOBAL.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id);
2531:
2532: -- pass a/c entry for 'credit rg23d account'
2533: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2526: sysdate,
2527: FND_GLOBAL.user_id,
2528: sysdate,
2529: fnd_global.user_id,
2530: fnd_global.login_id);
2531:
2532: -- pass a/c entry for 'credit rg23d account'
2533: jai_cmn_gl_pkg.create_gl_entry(p_organization_id => pr_trig_row.organization_id,
2534: p_currency_code => v_currency_code,
2591: NULL,
2592: v_currency_code,
2593: NULL,
2594: sysdate,
2595: FND_GLOBAL.user_id,
2596: sysdate,
2597: fnd_global.user_id,
2598: fnd_global.login_id);
2599:
2593: NULL,
2594: sysdate,
2595: FND_GLOBAL.user_id,
2596: sysdate,
2597: fnd_global.user_id,
2598: fnd_global.login_id);
2599:
2600: END IF;
2601: ELSE
2594: sysdate,
2595: FND_GLOBAL.user_id,
2596: sysdate,
2597: fnd_global.user_id,
2598: fnd_global.login_id);
2599:
2600: END IF;
2601: ELSE
2602: RETURN;
4053: p_exp_msg(l_exp_msg_index).EXCEPTION_ENTITY,
4054: p_exp_msg(l_exp_msg_index).EXCEPTION_NAME,
4055: p_exp_msg(l_exp_msg_index).ERROR_MESSAGE,
4056: sysdate,
4057: fnd_global.user_id,
4058: sysdate,
4059: fnd_global.login_id,
4060: fnd_global.user_id);
4061: END LOOP;
4055: p_exp_msg(l_exp_msg_index).ERROR_MESSAGE,
4056: sysdate,
4057: fnd_global.user_id,
4058: sysdate,
4059: fnd_global.login_id,
4060: fnd_global.user_id);
4061: END LOOP;
4062:
4063: commit;
4056: sysdate,
4057: fnd_global.user_id,
4058: sysdate,
4059: fnd_global.login_id,
4060: fnd_global.user_id);
4061: END LOOP;
4062:
4063: commit;
4064: