DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on FND_API

Line 347: 1.0, 'T', fnd_api.g_valid_level_full,

343: l_trx_rec := make_trx_rec(l_trx_id);
344: l_dist_line_tbl := make_dist_lines_tbl(l_trx_id);
345:
346: fun_trx_pvt.recipient_validate(
347: 1.0, 'T', fnd_api.g_valid_level_full,
348: l_status, l_msg_count, l_msg_data,
349: l_batch_rec, l_trx_rec, l_dist_line_tbl);
350: */
351: -- TODO

Line 916: IF(l_status = fnd_api.g_ret_sts_success) THEN

912: approverIn => l_approver_record);
913:
914: END IF;
915:
916: IF(l_status = fnd_api.g_ret_sts_success) THEN
917: resultout := wf_engine.eng_completed||':'||l_result;
918: RETURN;
919: ELSE
920: resultout := wf_engine.eng_error||':'||wf_engine.eng_null;

Line 1677: IF l_status <> FND_API.G_RET_STS_SUCCESS

1673: x_msg_data => l_msg_data,
1674: p_trx_id => l_trx_id,
1675: p_update_status_to => 'APPROVED');
1676:
1677: IF l_status <> FND_API.G_RET_STS_SUCCESS
1678: THEN
1679: resultout := wf_engine.eng_completed||':F';
1680: RETURN;
1681: END IF;

Line 2501: x_status := FND_API.G_RET_STS_SUCCESS;

2497: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'begin. p_trx_id = ' || p_trx_id);
2499: END IF;
2500:
2501: x_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: l_trx_id := p_trx_id;
2504: --Collect Iniator's info
2505:

Line 2536: x_status := FND_API.G_RET_STS_ERROR;

2532: END IF;
2533:
2534: IF l_init_count = 0 OR l_reci_count = 0
2535: THEN
2536: x_status := FND_API.G_RET_STS_ERROR;
2537: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'set x_status to ' || x_status );
2539: END IF;
2540: END IF;

Line 2631: x_status := FND_API.G_RET_STS_SUCCESS;

2627: THEN
2628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'All the lines are balanced.');
2630: END IF;
2631: x_status := FND_API.G_RET_STS_SUCCESS;
2632: RETURN;
2633: END IF;
2634: END IF;
2635:

Line 2872: IF x_status = FND_API.G_RET_STS_SUCCESS

2868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'fun_xla_tab_pkg x_msg_count = ' || x_msg_count );
2869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'fun_xla_tab_pkg x_msg_data = ' || x_msg_data );
2870: END IF;
2871:
2872: IF x_status = FND_API.G_RET_STS_SUCCESS
2873: THEN
2874: l_ccid := fun_xla_tab_pkg.g_array_xla_tab(1).target_ccid;
2875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_ccid =' || l_ccid);

Line 2881: IF l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 7559411

2877: END IF;
2878:
2879: END IF;
2880:
2881: IF l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 7559411
2882: THEN
2883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is not success or l_ccid is -1 and return');
2885: END IF;

Line 2886: x_status := FND_API.G_RET_STS_ERROR;

2882: THEN
2883: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is not success or l_ccid is -1 and return');
2885: END IF;
2886: x_status := FND_API.G_RET_STS_ERROR;
2887: RETURN;
2888: END IF;
2889:
2890: END IF;

Line 2922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);

2918: -- Hence passing it a dummy value
2919: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'calling fun_bal_utils_grp.get_intercompany_account with following parameters');
2921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_api_version = ' ||'1.0');
2922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);
2923: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_ledger_id = ' || l_init_dist_tbl(1).ledger_id);
2924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_le = ' || l_init_dist_tbl(1).initiator_le_id);
2925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_bsv = ' || l_init_bsv);
2926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_to_ledger_id = ' || l_reci_dist_tbl(1).ledger_id);

Line 2937: p_init_msg_list => FND_API.G_TRUE,

2933: END IF;
2934:
2935: fun_bal_utils_grp.get_intercompany_account
2936: (p_api_version => 1.0,
2937: p_init_msg_list => FND_API.G_TRUE,
2938: p_ledger_id => l_init_dist_tbl(1).ledger_id,
2939: p_from_le => l_init_dist_tbl(1).initiator_le_id,
2940: p_from_bsv => l_init_bsv,
2941: p_to_ledger_id => l_reci_dist_tbl(1).ledger_id,

Line 2955: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);

2951: ELSE
2952: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'calling fun_bal_utils_grp.get_intracompany_account with following parameters');
2954: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_api_version = ' ||'1.0');
2955: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);
2956: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_ledger_id = ' || l_init_dist_tbl(1).ledger_id);
2957: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_le = ' || l_init_dist_tbl(1).initiator_le_id);
2958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_source = ' || 'Global Intercompany');
2959: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_category = ' || 'Global Intercompany');

Line 2970: p_init_msg_list => FND_API.G_TRUE,

2966: END IF;
2967:
2968: fun_bal_utils_grp.get_intracompany_account
2969: (p_api_version => 1.0,
2970: p_init_msg_list => FND_API.G_TRUE,
2971: p_ledger_id => l_init_dist_tbl(1).ledger_id,
2972: p_from_le => l_init_dist_tbl(1).initiator_le_id,
2973: p_source => 'Global Intercompany',
2974: p_category => 'Global Intercompany',

Line 2987: IF l_ccid IS NULL OR l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 6969506

2983: x_reciprocal_ccid => l_reciprocal_ccid);
2984: END IF;
2985:
2986:
2987: IF l_ccid IS NULL OR l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 6969506
2988: THEN
2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is null or return status is not success and return');
2991: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'x_status = ' || x_status);

Line 2997: x_status := FND_API.G_RET_STS_ERROR;

2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'x_msg_data = ' || x_msg_data);
2994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_ccid = ' || l_ccid);
2995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_reciprocal_ccid = ' || l_reciprocal_ccid);
2996: END IF;
2997: x_status := FND_API.G_RET_STS_ERROR;
2998: RETURN;
2999: END IF;
3000:
3001:

Line 3006: x_status := FND_API.G_RET_STS_ERROR;

3002: END IF;
3003:
3004: IF (l_init_dist_tbl(1).init_amount_cr IS NULL or to_number(l_init_dist_tbl(1).init_amount_cr)=0) and (l_init_dist_tbl(1).init_amount_dr is null or to_number(l_init_dist_tbl(1).init_amount_dr)=0 ) -- Bug No : 6969506, 7013314
3005: THEN
3006: x_status := FND_API.G_RET_STS_ERROR;
3007: RETURN;
3008: END IF;
3009:
3010: -- Now build the new distribution record

Line 3262: IF x_status = FND_API.G_RET_STS_SUCCESS

3258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'fun_xla_tab_pkg x_msg_data = ' || x_msg_data );
3259: END IF;
3260:
3261:
3262: IF x_status = FND_API.G_RET_STS_SUCCESS
3263: THEN
3264: l_ccid := fun_xla_tab_pkg.g_array_xla_tab(1).target_ccid;
3265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'if fun_xla_tab_pkg returns success set ccid = ' || l_ccid);

Line 3270: IF l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 7559411

3266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'if fun_xla_tab_pkg returns success set ccid = ' || l_ccid);
3267: END IF;
3268: END IF;
3269:
3270: IF l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 7559411
3271: THEN
3272: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is not success or l_ccid is -1 and return');
3274: END IF;

Line 3275: x_status := FND_API.G_RET_STS_ERROR;

3271: THEN
3272: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is not success or l_ccid is -1 and return');
3274: END IF;
3275: x_status := FND_API.G_RET_STS_ERROR;
3276: RETURN;
3277: END IF;
3278:
3279: END IF;

Line 3294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);

3290:
3291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'calling fun_bal_utils_grp.get_intercompany_account with following parameters');
3293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_api_version = ' ||'1.0');
3294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);
3295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_ledger_id = ' || l_reci_dist_tbl(1).ledger_id);
3296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_le = ' || l_reci_dist_tbl(1).initiator_le_id);
3297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_bsv = ' || l_reci_bsv);
3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_to_ledger_id = ' || l_init_dist_tbl(1).ledger_id);

Line 3309: p_init_msg_list => FND_API.G_TRUE,

3305: END IF;
3306:
3307: fun_bal_utils_grp.get_intercompany_account
3308: (p_api_version => 1.0,
3309: p_init_msg_list => FND_API.G_TRUE,
3310: p_ledger_id => l_reci_dist_tbl(1).ledger_id,
3311: p_from_le => l_reci_dist_tbl(1).recipient_le_id,
3312: p_from_bsv => l_reci_bsv,
3313: p_to_ledger_id => l_init_dist_tbl(1).ledger_id,

Line 3328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);

3324:
3325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'calling fun_bal_utils_grp.get_intracompany_account with following parameters');
3327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_api_version = ' ||'1.0');
3328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_init_msg_list = ' || FND_API.G_TRUE);
3329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_ledger_id = ' || l_reci_dist_tbl(1).ledger_id);
3330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_from_le = ' || l_reci_dist_tbl(1).initiator_le_id);
3331: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_source = ' || 'Global Intercompany');
3332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'p_category = ' || 'Global Intercompany');

Line 3343: p_init_msg_list => FND_API.G_TRUE,

3339: END IF;
3340:
3341: fun_bal_utils_grp.get_intracompany_account
3342: (p_api_version => 1.0,
3343: p_init_msg_list => FND_API.G_TRUE,
3344: p_ledger_id => l_reci_dist_tbl(1).ledger_id,
3345: p_from_le => l_reci_dist_tbl(1).recipient_le_id,
3346: p_source => 'Global Intercompany',
3347: p_category => 'Global Intercompany',

Line 3359: IF l_ccid IS NULL OR l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 6969506

3355: x_ccid => l_ccid,
3356: x_reciprocal_ccid => l_reciprocal_ccid);
3357: END IF;
3358:
3359: IF l_ccid IS NULL OR l_ccid <=0 OR x_status <> FND_API.G_RET_STS_SUCCESS -- Bug No : 6969506
3360: THEN
3361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Error if l_ccid is null or return status is not success and return');
3363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'x_status = ' || x_status);

Line 3369: x_status := FND_API.G_RET_STS_ERROR;

3365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'x_msg_data = ' || x_msg_data);
3366: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_ccid = ' || l_ccid);
3367: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'l_reciprocal_ccid = ' || l_reciprocal_ccid);
3368: END IF;
3369: x_status := FND_API.G_RET_STS_ERROR;
3370: RETURN;
3371: END IF;
3372:
3373: END IF;

Line 3377: x_status := FND_API.G_RET_STS_ERROR;

3373: END IF;
3374:
3375: IF (l_reci_dist_tbl(1).reci_amount_cr IS NULL or to_number(l_reci_dist_tbl(1).reci_amount_cr)=0) and (l_reci_dist_tbl(1).reci_amount_dr is null OR to_number(l_reci_dist_tbl(1).reci_amount_dr)=0) -- Bug No : 6969506, 7013314
3376: THEN
3377: x_status := FND_API.G_RET_STS_ERROR;
3378: RETURN;
3379: END IF;
3380:
3381:

Line 3411: IF x_status = FND_API.G_RET_STS_SUCCESS

3407: l_new_index := l_new_index + 1;
3408:
3409:
3410:
3411: IF x_status = FND_API.G_RET_STS_SUCCESS
3412:
3413: THEN
3414: -- Delete existing intercompany account distribution lines if exists.
3415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3432: x_status := FND_API.G_RET_STS_ERROR;

3428:
3429: END IF;
3430: EXCEPTION
3431: WHEN others THEN
3432: x_status := FND_API.G_RET_STS_ERROR;
3433: END generate_interco_acct;
3434:
3435:
3436:

Line 3446: OUT : x_status -- FND_API.G_RET_STS_SUCCESS, ..UNEXP,..ERROR

3442: Function : This function is called by recipient_interco_acct
3443: to get the default ccid from SLA
3444: Parameters:
3445: IN : p_trx_id -- fun_trx_headers.trx_id
3446: OUT : x_status -- FND_API.G_RET_STS_SUCCESS, ..UNEXP,..ERROR
3447: x_msg_count -- Number of messages
3448: x_msg_data -- Message data
3449: x_ccid -- CCID
3450: Notes : None.

Line 3564: x_status := FND_API.G_RET_STS_SUCCESS;

3560: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3561: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3562:
3563: BEGIN
3564: x_status := FND_API.G_RET_STS_SUCCESS;
3565: x_ccid := -1;
3566:
3567: OPEN c_dtls;
3568: FETCH c_dtls INTO l_trx_dtl_rec;

Line 3678: IF x_status = FND_API.G_RET_STS_SUCCESS

3674: ,x_return_status => x_status
3675: ,x_msg_count => x_msg_count
3676: ,x_msg_data => x_msg_data );
3677:
3678: IF x_status = FND_API.G_RET_STS_SUCCESS
3679: THEN
3680: x_ccid := fun_xla_tab_pkg.g_array_xla_tab(1).target_ccid;
3681: END IF;
3682:

Line 3746: IF l_status <> FND_API.G_RET_STS_SUCCESS

3742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'after generate_interco_acct l_status = ' || l_status);
3744: END IF;
3745:
3746: IF l_status <> FND_API.G_RET_STS_SUCCESS
3747: THEN
3748:
3749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'if l_status not equal to ' || FND_API.G_RET_STS_SUCCESS);

Line 3750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'if l_status not equal to ' || FND_API.G_RET_STS_SUCCESS);

3746: IF l_status <> FND_API.G_RET_STS_SUCCESS
3747: THEN
3748:
3749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'if l_status not equal to ' || FND_API.G_RET_STS_SUCCESS);
3751: END IF;
3752:
3753: resultout := wf_engine.eng_completed||':F';
3754: fun_trx_pvt.update_trx_status