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.PA_TRX_IMPORT dependencies on FND_API

Line 1279: x_status := FND_API.G_RET_STS_ERROR ;

1275:
1276: pa_cc_utils.set_curr_function('validate_exp_date');
1277:
1278: IF x_err_msg_cd is not NULL THEN
1279: x_status := FND_API.G_RET_STS_ERROR ;
1280: RETURN ;
1281: END IF ;
1282:
1283: x_status := FND_API.G_RET_STS_SUCCESS;

Line 1283: x_status := FND_API.G_RET_STS_SUCCESS;

1279: x_status := FND_API.G_RET_STS_ERROR ;
1280: RETURN ;
1281: END IF ;
1282:
1283: x_status := FND_API.G_RET_STS_SUCCESS;
1284:
1285: IF PG_DEBUG = 'Y' THEN
1286: log_message('log_message: fetching project dates ' );
1287: END IF;

Line 1309: x_status := FND_API.G_RET_STS_ERROR ;

1305: close get_valid_awards ;
1306:
1307: IF p_exp_item_date < TRUNC(c_award_rec.preaward_date) THEN
1308: x_err_msg_cd := 'GMS_EXP_ITEM_DT_BEFORE_AWD_ST' ;
1309: x_status := FND_API.G_RET_STS_ERROR ;
1310: RETURN ;
1311: END IF ;
1312:
1313: IF p_exp_item_date > TRUNC(c_award_rec.end_date) THEN

Line 1315: x_status := FND_API.G_RET_STS_ERROR ;

1311: END IF ;
1312:
1313: IF p_exp_item_date > TRUNC(c_award_rec.end_date) THEN
1314: x_err_msg_cd := 'GMS_EXP_ITEM_DT_AFTER_AWD_END' ;
1315: x_status := FND_API.G_RET_STS_ERROR ;
1316: RETURN ;
1317: END IF ;
1318:
1319: IF c_award_rec.close_date < TRUNC(SYSDATE) THEN

Line 1321: x_status := FND_API.G_RET_STS_ERROR ;

1317: END IF ;
1318:
1319: IF c_award_rec.close_date < TRUNC(SYSDATE) THEN
1320: x_err_msg_cd := 'GMS_AWARD_IS_CLOSED' ;
1321: x_status := FND_API.G_RET_STS_ERROR ;
1322: RETURN ;
1323: END IF ;
1324: END IF ;
1325:

Line 1331: x_status := FND_API.G_RET_STS_ERROR ;

1327: log_message('log_message: Validating exp dates -> exp types' );
1328: END IF;
1329: IF p_exp_item_date not between c_dates_rec.et_start_date and c_dates_rec.et_end_date then
1330: x_err_msg_cd := 'EXP_TYPE_INACTIVE' ;
1331: x_status := FND_API.G_RET_STS_ERROR ;
1332: RETURN ;
1333: END IF ;
1334:
1335: IF PG_DEBUG = 'Y' THEN

Line 1340: x_status := FND_API.G_RET_STS_ERROR ;

1336: log_message('log_message: Validating exp dates -> System Linkage Function' );
1337: END IF;
1338: IF p_exp_item_date not between c_dates_rec.sl_start_date and c_dates_rec.sl_end_date THEN
1339: x_err_msg_cd := 'ETYPE_SLINK_INACTIVE' ;
1340: x_status := FND_API.G_RET_STS_ERROR ;
1341: RETURN ;
1342: END IF ;
1343:
1344: IF PG_DEBUG = 'Y' THEN

Line 1349: x_status := FND_API.G_RET_STS_ERROR ;

1345: log_message('log_message: Validating exp dates -> Project Level' );
1346: END IF;
1347: IF p_exp_item_date NOT between c_dates_rec.proj_start_date and c_dates_rec.proj_end_date THEN
1348: x_err_msg_cd := 'PA_EX_PROJECT_DATE' ;
1349: x_status := FND_API.G_RET_STS_ERROR ;
1350: RETURN ;
1351: END IF ;
1352:
1353: IF PG_DEBUG = 'Y' THEN

Line 1358: x_status := FND_API.G_RET_STS_ERROR ;

1354: log_message('log_message: Validating exp dates -> Task Level' );
1355: END IF;
1356: IF p_exp_item_date NOT between c_dates_rec.task_start_date and c_dates_rec.task_completion_date THEN
1357: x_err_msg_cd := 'PA_EXP_TASK_EFF' ;
1358: x_status := FND_API.G_RET_STS_ERROR ;
1359: RETURN ;
1360: END IF ;
1361:
1362: IF PG_DEBUG = 'Y' THEN

Line 1367: x_status := FND_API.G_RET_STS_ERROR ;

1363: log_message('log_message: Validating exp dates -> Exp Org Level' );
1364: END IF;
1365: IF pa_utils2.CheckExporg(p_incurred_by_org_id,p_exp_item_date) = 'N' then
1366: x_err_msg_cd := 'PA_EXP_ORG_NOT_ACTIVE' ;
1367: x_status := FND_API.G_RET_STS_ERROR ;
1368: RETURN ;
1369: END IF;
1370:
1371: IF PG_DEBUG = 'Y' THEN

Line 1376: x_status := FND_API.G_RET_STS_ERROR ;

1372: log_message('log_message: Validating exp dates -> Employee Level' );
1373: END IF;
1374: IF nvl(check_active_employee (p_vendor_id => p_vendor_id ,p_person_id => p_person_id ,p_ei_date => p_exp_item_date),'N') = 'N' then
1375: x_err_msg_cd := 'NO_ASSIGNMENT' ;
1376: x_status := FND_API.G_RET_STS_ERROR ;
1377: RETURN ;
1378: End if;
1379:
1380: pa_cc_utils.reset_curr_function;

Line 2500: IF X_status is not null and l_api_status = fnd_api.g_ret_sts_error then

2496: x_module,
2497: x_status,
2498: l_api_status) ;
2499:
2500: IF X_status is not null and l_api_status = fnd_api.g_ret_sts_error then
2501:
2502: --
2503: -- Bug:5502147 R12.PJ:XB9:QA:APL: ISSUES IN EI DATE VALIDATION IN PROJECTS
2504: -- Following is done to support Query by project number or task number in the transaction review form.

Line 4576: if (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) then

4572: log_message('log_message: ' || 'Recvr PA Date = ' || G_RecvrPaDate || ' Recvr PA Pd Name = ' || G_RecvrPaPeriodName);
4573: END IF;
4574: end if;
4575:
4576: if (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) then
4577: x_status := x_error_code;
4578: IF PG_DEBUG = 'Y' THEN
4579: pa_debug.G_err_stage := 'Error returned for accrual date derivation = '||x_status;
4580: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 4637: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

4633: log_message('log_message: ' || 'Recvr PA Date = ' || G_RevRecvrPaDate || ' Recvr PA Pd Name = ' || G_RevRecvrPaPdName);
4634: END IF;
4635: end if;
4636:
4637: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
4638: x_status := x_error_code;
4639: IF PG_DEBUG = 'Y' THEN
4640: pa_debug.G_err_stage := 'Error returned for reversal line accrual date derivation = '||x_status;
4641: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 4813: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

4809: log_message('log_message: ' || 'Assignment Id = ' || G_Assignment_Id || ' Work Type Id = ' || G_Work_Type_Id ||
4810: ' Tp Amt Type = ' || G_Tp_Amt_Type_Code);
4811: END IF;
4812:
4813: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
4814:
4815: IF PG_DEBUG = 'Y' THEN
4816: pa_debug.G_err_stage := 'Get Work Type and Assignment API failed';
4817: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 5278: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

5274: x_error_message_code => l_fc_error_msg,
5275: x_error_stage => l_fc_error_stage,
5276: x_return_status => l_fc_return_status);
5277:
5278: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
5279:
5280: IF PG_DEBUG = 'Y' THEN
5281: pa_debug.G_err_stage := 'Call to tr_import_funds_check did not succeed';
5282: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 5305: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

5301: x_return_status => l_fc_return_status,
5302: x_error_stage => l_fc_error_stage,
5303: x_error_msg => l_fc_error_msg) THEN
5304:
5305: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
5306:
5307: IF PG_DEBUG = 'Y' THEN
5308: pa_debug.G_err_stage := 'Call to funds check not success';
5309: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 9038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9034: p_calling_mode => X_transaction_source) ;
9035:
9036: END IF;
9037:
9038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9039:
9040: raise_application_error(-20001,'Error during Balance Update');
9041: return ;
9042:

Line 9049: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9045: if l_gms_enabled = 'Y' then
9046: gms_pa_costing_pkg.Tieback_Interface(p_request_id => g_request_id,
9047: p_status => l_return_status);
9048:
9049: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9050: raise_application_error(-20002,'Error during Grants Tieback process');
9051: return ;
9052: end if;
9053: --

Line 9062: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9058: X_batch ,
9059: X_xface_id,
9060: l_return_status) ;
9061:
9062: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9063: raise_application_error(-20002,'Error during Grants Tieback process net_zero_adjustment_flag Zero adls');
9064: return ;
9065: end if;
9066:

Line 9733: x_return_status := FND_API.G_RET_STS_SUCCESS;

9729: log_message('log_message: ' || 'Calling pa_funds_control_pkg.UPD_BDGT_ENCUM_BAL');
9730: END IF;
9731:
9732: -- set the return status to success
9733: x_return_status := FND_API.G_RET_STS_SUCCESS;
9734:
9735: pa_funds_control_pkg.UPD_BDGT_ENCUM_BAL(
9736: p_packet_id => p_packet_id,
9737: p_calling_module => 'TRXIMPORT',

Line 9742: if l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

9738: p_mode => 'R',
9739: p_packet_status => 'S',
9740: x_return_status => l_fc_return_status);
9741:
9742: if l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
9743: x_return_status := l_fc_return_status ;
9744: return;
9745: end if;
9746:

Line 9750: x_return_status := fnd_api.g_ret_sts_unexp_error;

9746:
9747:
9748: EXCEPTION
9749: WHEN OTHERS THEN
9750: x_return_status := fnd_api.g_ret_sts_unexp_error;
9751: RAISE;
9752:
9753: END Upd_Sts_Enc_Bal;
9754:

Line 9765: x_return_status := FND_API.G_RET_STS_SUCCESS;

9761: log_message('log_message: ' || pa_debug.G_err_Stage);
9762: END IF;
9763:
9764: -- set the return status to success
9765: x_return_status := FND_API.G_RET_STS_SUCCESS;
9766:
9767: IF PG_DEBUG = 'Y' THEN
9768: log_message('log_message: ' || 'p_calling_mode = ' || p_calling_mode);
9769: END IF;

Line 10153: x_return_status := fnd_api.g_ret_sts_unexp_error;

10149: pa_cc_utils.reset_curr_function;
10150:
10151: EXCEPTION
10152: WHEN OTHERS THEN
10153: x_return_status := fnd_api.g_ret_sts_unexp_error;
10154: RAISE;
10155: END tieback_fc_records;
10156:
10157: --PA-J Receipt Accrual Changes:

Line 10590: x_return_status := FND_API.G_RET_STS_SUCCESS;

10586: END IF;
10587: pa_cc_utils.reset_curr_function;
10588:
10589: -- set the return status to success
10590: x_return_status := FND_API.G_RET_STS_SUCCESS;
10591:
10592: EXCEPTION
10593: WHEN OTHERS THEN
10594: log_message('log_message: In others of tr import, packet_id = '|| l_packet_id); -- Bug 3592289

Line 10602: x_return_status := fnd_api.g_ret_sts_unexp_error;

10598: log_message('log_message: ' || sqlerrm||' Returning from funds check');
10599: log_message('log_message: x_return_status = ' || x_return_status); -- Bug 3592289
10600: log_message('log_message: x_error = ' || x_error_message_code); -- Bug 3592289
10601: END IF;
10602: x_return_status := fnd_api.g_ret_sts_unexp_error;
10603: pa_cc_utils.reset_curr_function;
10604: END tr_import_funds_check ;
10605:
10606: --2339216: Added procedure

Line 10647: x_return_status := FND_API.G_RET_STS_SUCCESS;

10643: log_message('log_message: ' || 'Returning from ap funds check');
10644: END IF;
10645:
10646: -- set the return status to success
10647: x_return_status := FND_API.G_RET_STS_SUCCESS;
10648:
10649: pa_cc_utils.reset_curr_function;
10650:
10651: EXCEPTION

Line 10662: x_return_status := fnd_api.g_ret_sts_error;

10658: --Call FC packets update API to update packets to T.
10659: --moved to tr_import_funds_check
10660: --Upd_PktSts(p_packet_id => p_packet_id);
10661:
10662: x_return_status := fnd_api.g_ret_sts_error;
10663: x_error_message_code := 'PA_FC_NDF';
10664:
10665: pa_cc_utils.reset_curr_function;
10666: RAISE;

Line 10672: x_return_status := fnd_api.g_ret_sts_unexp_error;

10668: WHEN OTHERS THEN
10669: IF PG_DEBUG = 'Y' THEN
10670: log_message('log_message: ' || sqlerrm||' Returning from ap disc funds check');
10671: END IF;
10672: x_return_status := fnd_api.g_ret_sts_unexp_error;
10673: pa_cc_utils.reset_curr_function;
10674: RAISE;
10675: END ap_disc_funds_check;
10676:

Line 10716: x_return_status := FND_API.G_RET_STS_SUCCESS;

10712: log_message('log_message: ' || 'Returning from ap funds check');
10713: END IF;
10714:
10715: -- set the return status to success
10716: x_return_status := FND_API.G_RET_STS_SUCCESS;
10717:
10718: pa_cc_utils.reset_curr_function;
10719:
10720: EXCEPTION

Line 10731: x_return_status := fnd_api.g_ret_sts_error;

10727: --Call FC packets update API to update packets to T.
10728: --moved to tr_import_funds_check
10729: --Upd_PktSts(p_packet_id => p_packet_id);
10730:
10731: x_return_status := fnd_api.g_ret_sts_error;
10732: x_error_message_code := 'PA_FC_NDF';
10733:
10734: pa_cc_utils.reset_curr_function;
10735: RAISE;

Line 10742: x_return_status := fnd_api.g_ret_sts_unexp_error;

10738: WHEN OTHERS THEN
10739: IF PG_DEBUG = 'Y' THEN
10740: log_message('log_message: ' || sqlerrm||' Returning from ap funds check');
10741: END IF;
10742: x_return_status := fnd_api.g_ret_sts_unexp_error;
10743: pa_cc_utils.reset_curr_function;
10744: RAISE;
10745: END ap_funds_check;
10746:

Line 10938: x_return_status := FND_API.G_RET_STS_SUCCESS;

10934: log_message('log_message: ' || 'Returning from po funds check');
10935: END IF;
10936:
10937: -- set the return status to success
10938: x_return_status := FND_API.G_RET_STS_SUCCESS;
10939:
10940: pa_cc_utils.reset_curr_function;
10941:
10942: EXCEPTION

Line 10953: x_return_status := fnd_api.g_ret_sts_error;

10949: --Call FC packets update API to update packets to T.
10950: --moved to tr_import_funds_check
10951: --Upd_PktSts(p_packet_id => p_packet_id);
10952:
10953: x_return_status := fnd_api.g_ret_sts_error;
10954: x_error_message_code := 'PA_FC_NDF';
10955:
10956: pa_cc_utils.reset_curr_function;
10957: RAISE;

Line 10963: x_return_status := fnd_api.g_ret_sts_unexp_error;

10959: WHEN OTHERS THEN
10960: IF PG_DEBUG = 'Y' THEN
10961: log_message('log_message: ' || sqlerrm||' Returning from po funds check');
10962: END IF;
10963: x_return_status := fnd_api.g_ret_sts_unexp_error;
10964: pa_cc_utils.reset_curr_function;
10965: RAISE;
10966: END po_funds_check;
10967:

Line 11078: x_return_status := FND_API.G_RET_STS_SUCCESS;

11074: log_message('log_message: ' || 'Returning from ap_po funds check');
11075: END IF;
11076:
11077: -- set the return status to success
11078: x_return_status := FND_API.G_RET_STS_SUCCESS;
11079:
11080: pa_cc_utils.reset_curr_function;
11081:
11082: EXCEPTION

Line 11087: x_return_status := fnd_api.g_ret_sts_unexp_error;

11083: WHEN OTHERS THEN
11084: IF PG_DEBUG = 'Y' THEN
11085: log_message('log_message: ' || sqlerrm||' Returning from ap po funds check');
11086: END IF;
11087: x_return_status := fnd_api.g_ret_sts_unexp_error;
11088: pa_cc_utils.reset_curr_function;
11089: RAISE;
11090: END ap_po_funds_check;
11091:

Line 11467: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN

11463: ' Work Type Id = ' || G_Work_Type_Id ||
11464: ' Tp Amt Type = ' || G_Tp_Amt_Type_Code);
11465: END IF;
11466:
11467: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
11468:
11469: IF PG_DEBUG = 'Y' THEN
11470: pa_debug.G_err_stage := 'Get Work Type and Assignment API failed';
11471: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 11894: x_return_status := FND_API.G_RET_STS_SUCCESS;

11890: log_message('log_message: ' || 'Returning from ap funds check');
11891: END IF;
11892:
11893: -- set the return status to success
11894: x_return_status := FND_API.G_RET_STS_SUCCESS;
11895:
11896: pa_cc_utils.reset_curr_function;
11897:
11898: EXCEPTION

Line 11910: x_return_status := fnd_api.g_ret_sts_unexp_error;

11906: WHEN OTHERS THEN
11907: IF PG_DEBUG = 'Y' THEN
11908: log_message('log_message: ' || sqlerrm||' Returning from ap funds check');
11909: END IF;
11910: x_return_status := fnd_api.g_ret_sts_unexp_error;
11911: pa_cc_utils.reset_curr_function;
11912: RAISE;
11913: END ap_cash_based_funds_check;
11914: