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 1373: x_status := FND_API.G_RET_STS_ERROR ;

1369:
1370: pa_cc_utils.set_curr_function('validate_exp_date');
1371:
1372: IF x_err_msg_cd is not NULL THEN
1373: x_status := FND_API.G_RET_STS_ERROR ;
1374: RETURN ;
1375: END IF ;
1376:
1377: x_status := FND_API.G_RET_STS_SUCCESS;

Line 1377: x_status := FND_API.G_RET_STS_SUCCESS;

1373: x_status := FND_API.G_RET_STS_ERROR ;
1374: RETURN ;
1375: END IF ;
1376:
1377: x_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: IF PG_DEBUG = 'Y' THEN
1380: log_message('log_message: fetching project dates ' );
1381: END IF;

Line 1403: x_status := FND_API.G_RET_STS_ERROR ;

1399: close get_valid_awards ;
1400:
1401: IF p_exp_item_date < TRUNC(c_award_rec.preaward_date) THEN
1402: x_err_msg_cd := 'GMS_EXP_ITEM_DT_BEFORE_AWD_ST' ;
1403: x_status := FND_API.G_RET_STS_ERROR ;
1404: RETURN ;
1405: END IF ;
1406:
1407: IF p_exp_item_date > TRUNC(c_award_rec.end_date) THEN

Line 1409: x_status := FND_API.G_RET_STS_ERROR ;

1405: END IF ;
1406:
1407: IF p_exp_item_date > TRUNC(c_award_rec.end_date) THEN
1408: x_err_msg_cd := 'GMS_EXP_ITEM_DT_AFTER_AWD_END' ;
1409: x_status := FND_API.G_RET_STS_ERROR ;
1410: RETURN ;
1411: END IF ;
1412:
1413: IF c_award_rec.close_date < TRUNC(SYSDATE) THEN

Line 1415: x_status := FND_API.G_RET_STS_ERROR ;

1411: END IF ;
1412:
1413: IF c_award_rec.close_date < TRUNC(SYSDATE) THEN
1414: x_err_msg_cd := 'GMS_AWARD_IS_CLOSED' ;
1415: x_status := FND_API.G_RET_STS_ERROR ;
1416: RETURN ;
1417: END IF ;
1418: END IF ;
1419:

Line 1427: x_status := FND_API.G_RET_STS_ERROR ;

1423: /* IF p_exp_item_date not between c_dates_rec.et_start_date and c_dates_rec.et_end_date then */
1424: -- Bug 11063869 --Added trunc for the dates in the below if condition.
1425: IF trunc(p_exp_item_date) not between trunc(c_dates_rec.et_start_date) and trunc(c_dates_rec.et_end_date) then
1426: x_err_msg_cd := 'EXP_TYPE_INACTIVE' ;
1427: x_status := FND_API.G_RET_STS_ERROR ;
1428: RETURN ;
1429: END IF ;
1430:
1431: IF PG_DEBUG = 'Y' THEN

Line 1438: x_status := FND_API.G_RET_STS_ERROR ;

1434: /* IF p_exp_item_date not between c_dates_rec.sl_start_date and c_dates_rec.sl_end_date THEN */
1435: -- Bug 11063869--Added trunc for the dates in the below if condition.
1436: IF trunc(p_exp_item_date) not between trunc(c_dates_rec.sl_start_date) and trunc(c_dates_rec.sl_end_date) THEN
1437: x_err_msg_cd := 'ETYPE_SLINK_INACTIVE' ;
1438: x_status := FND_API.G_RET_STS_ERROR ;
1439: RETURN ;
1440: END IF ;
1441:
1442: IF PG_DEBUG = 'Y' THEN

Line 1449: x_status := FND_API.G_RET_STS_ERROR ;

1445: /* IF p_exp_item_date NOT between c_dates_rec.proj_start_date and c_dates_rec.proj_end_date THEN */
1446: -- Bug 11063869--Added trunc for the dates in the below if condition.
1447: IF trunc(p_exp_item_date) NOT between trunc(c_dates_rec.proj_start_date) and trunc(c_dates_rec.proj_end_date) THEN
1448: x_err_msg_cd := 'PA_EX_PROJECT_DATE' ;
1449: x_status := FND_API.G_RET_STS_ERROR ;
1450: RETURN ;
1451: END IF ;
1452:
1453: IF PG_DEBUG = 'Y' THEN

Line 1458: x_status := FND_API.G_RET_STS_ERROR ;

1454: log_message('log_message: Validating exp dates -> Task Level' );
1455: END IF;
1456: IF trunc( p_exp_item_date) NOT between trunc( c_dates_rec.task_start_date) and trunc (c_dates_rec.task_completion_date) THEN
1457: x_err_msg_cd := 'PA_EXP_TASK_EFF' ;
1458: x_status := FND_API.G_RET_STS_ERROR ;
1459: RETURN ;
1460: END IF ;
1461:
1462: IF PG_DEBUG = 'Y' THEN

Line 1467: x_status := FND_API.G_RET_STS_ERROR ;

1463: log_message('log_message: Validating exp dates -> Exp Org Level' );
1464: END IF;
1465: IF pa_utils2.CheckExporg(p_incurred_by_org_id,p_exp_item_date) = 'N' then
1466: x_err_msg_cd := 'PA_EXP_ORG_NOT_ACTIVE' ;
1467: x_status := FND_API.G_RET_STS_ERROR ;
1468: RETURN ;
1469: END IF;
1470:
1471: IF PG_DEBUG = 'Y' THEN

Line 1477: x_status := FND_API.G_RET_STS_ERROR ;

1473: END IF;
1474: /*Start chnages for bug#15857341 */
1475: /*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
1476: x_err_msg_cd := 'NO_ASSIGNMENT' ;
1477: x_status := FND_API.G_RET_STS_ERROR ;
1478: RETURN ;
1479: End if;*/
1480:
1481: pa_cc_utils.reset_curr_function;

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

2759: x_module,
2760: x_status,
2761: l_api_status) ;
2762:
2763: IF X_status is not null and l_api_status = fnd_api.g_ret_sts_error then
2764:
2765: --
2766: -- Bug:5502147 R12.PJ:XB9:QA:APL: ISSUES IN EI DATE VALIDATION IN PROJECTS
2767: -- Following is done to support Query by project number or task number in the transaction review form.

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

5006: log_message('log_message: ' || 'Recvr PA Date = ' || G_RecvrPaDate || ' Recvr PA Pd Name = ' || G_RecvrPaPeriodName);
5007: END IF;
5008: end if;
5009:
5010: if (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) then
5011: x_status := x_error_code;
5012: IF PG_DEBUG = 'Y' THEN
5013: pa_debug.G_err_stage := 'Error returned for accrual date derivation = '||x_status;
5014: log_message('log_message: ' || pa_debug.G_err_Stage);

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

5067: log_message('log_message: ' || 'Recvr PA Date = ' || G_RevRecvrPaDate || ' Recvr PA Pd Name = ' || G_RevRecvrPaPdName);
5068: END IF;
5069: end if;
5070:
5071: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
5072: x_status := x_error_code;
5073: IF PG_DEBUG = 'Y' THEN
5074: pa_debug.G_err_stage := 'Error returned for reversal line accrual date derivation = '||x_status;
5075: log_message('log_message: ' || pa_debug.G_err_Stage);

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

5245: log_message('log_message: ' || 'Assignment Id = ' || G_Assignment_Id || ' Work Type Id = ' || G_Work_Type_Id ||
5246: ' Tp Amt Type = ' || G_Tp_Amt_Type_Code);
5247: END IF;
5248:
5249: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
5250:
5251: IF PG_DEBUG = 'Y' THEN
5252: pa_debug.G_err_stage := 'Get Work Type and Assignment API failed';
5253: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 5734: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

5730: log_message('log_message: Value of l_fc_error_stage='||l_fc_error_stage);
5731: log_message('log_message: Value of l_fc_return_status='||l_fc_return_status);
5732: END IF;
5733:
5734: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
5735:
5736: IF PG_DEBUG = 'Y' THEN
5737: pa_debug.G_err_stage := 'Call to tr_import_funds_check did not succeed';
5738: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 5769: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

5765: log_message('log_message: Value of l_fc_error_stage='||l_fc_error_stage);
5766: log_message('log_message: Value of l_fc_error_msg='||l_fc_error_msg);
5767: END IF;
5768:
5769: IF l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
5770:
5771: IF PG_DEBUG = 'Y' THEN
5772: pa_debug.G_err_stage := 'Call to funds check not success';
5773: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 9828: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9824: p_calling_mode => X_transaction_source) ;
9825:
9826: END IF;
9827:
9828: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9829:
9830: raise_application_error(-20001,'Error during Balance Update');
9831: return ;
9832:

Line 9839: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9835: if l_gms_enabled = 'Y' then
9836: gms_pa_costing_pkg.Tieback_Interface(p_request_id => g_request_id,
9837: p_status => l_return_status);
9838:
9839: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9840: raise_application_error(-20002,'Error during Grants Tieback process');
9841: return ;
9842: end if;
9843: --

Line 9852: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

9848: X_batch ,
9849: X_xface_id,
9850: l_return_status) ;
9851:
9852: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9853: raise_application_error(-20002,'Error during Grants Tieback process net_zero_adjustment_flag Zero adls');
9854: return ;
9855: end if;
9856:

Line 10551: x_return_status := FND_API.G_RET_STS_SUCCESS;

10547: log_message('log_message: ' || 'Calling pa_funds_control_pkg.UPD_BDGT_ENCUM_BAL');
10548: END IF;
10549:
10550: -- set the return status to success
10551: x_return_status := FND_API.G_RET_STS_SUCCESS;
10552:
10553: pa_funds_control_pkg.UPD_BDGT_ENCUM_BAL(
10554: p_packet_id => p_packet_id,
10555: p_calling_module => 'TRXIMPORT',

Line 10560: if l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then

10556: p_mode => 'R',
10557: p_packet_status => 'S',
10558: x_return_status => l_fc_return_status);
10559:
10560: if l_fc_return_status <> FND_API.G_RET_STS_SUCCESS then
10561: x_return_status := l_fc_return_status ;
10562: return;
10563: end if;
10564:

Line 10568: x_return_status := fnd_api.g_ret_sts_unexp_error;

10564:
10565:
10566: EXCEPTION
10567: WHEN OTHERS THEN
10568: x_return_status := fnd_api.g_ret_sts_unexp_error;
10569: RAISE;
10570:
10571: END Upd_Sts_Enc_Bal;
10572:

Line 10583: x_return_status := FND_API.G_RET_STS_SUCCESS;

10579: log_message('log_message: ' || pa_debug.G_err_Stage);
10580: END IF;
10581:
10582: -- set the return status to success
10583: x_return_status := FND_API.G_RET_STS_SUCCESS;
10584:
10585: IF PG_DEBUG = 'Y' THEN
10586: log_message('log_message: ' || 'p_calling_mode = ' || p_calling_mode);
10587: END IF;

Line 10971: x_return_status := fnd_api.g_ret_sts_unexp_error;

10967: pa_cc_utils.reset_curr_function;
10968:
10969: EXCEPTION
10970: WHEN OTHERS THEN
10971: x_return_status := fnd_api.g_ret_sts_unexp_error;
10972: RAISE;
10973: END tieback_fc_records;
10974:
10975: --PA-J Receipt Accrual Changes:

Line 11452: x_return_status := FND_API.G_RET_STS_SUCCESS;

11448: END IF;
11449: pa_cc_utils.reset_curr_function;
11450:
11451: -- set the return status to success
11452: x_return_status := FND_API.G_RET_STS_SUCCESS;
11453:
11454: EXCEPTION
11455: WHEN OTHERS THEN
11456: log_message('log_message: In others of tr import, packet_id = '|| l_packet_id); -- Bug 3592289

Line 11464: x_return_status := fnd_api.g_ret_sts_unexp_error;

11460: log_message('log_message: ' || sqlerrm||' Returning from funds check');
11461: log_message('log_message: x_return_status = ' || x_return_status); -- Bug 3592289
11462: log_message('log_message: x_error = ' || x_error_message_code); -- Bug 3592289
11463: END IF;
11464: x_return_status := fnd_api.g_ret_sts_unexp_error;
11465: pa_cc_utils.reset_curr_function;
11466: END tr_import_funds_check ;
11467:
11468: --2339216: Added procedure

Line 11510: x_return_status := FND_API.G_RET_STS_SUCCESS;

11506: log_message('log_message: After calling insert_ap_bc_packets api');
11507: END IF;
11508:
11509: -- set the return status to success
11510: x_return_status := FND_API.G_RET_STS_SUCCESS;
11511:
11512: pa_cc_utils.reset_curr_function;
11513:
11514: EXCEPTION

Line 11525: x_return_status := fnd_api.g_ret_sts_error;

11521: --Call FC packets update API to update packets to T.
11522: --moved to tr_import_funds_check
11523: --Upd_PktSts(p_packet_id => p_packet_id);
11524:
11525: x_return_status := fnd_api.g_ret_sts_error;
11526: x_error_message_code := 'PA_FC_NDF';
11527:
11528: pa_cc_utils.reset_curr_function;
11529: RAISE;

Line 11535: x_return_status := fnd_api.g_ret_sts_unexp_error;

11531: WHEN OTHERS THEN
11532: IF PG_DEBUG = 'Y' THEN
11533: log_message('log_message: ' || sqlerrm||' Returning from ap disc funds check');
11534: END IF;
11535: x_return_status := fnd_api.g_ret_sts_unexp_error;
11536: pa_cc_utils.reset_curr_function;
11537: RAISE;
11538: END ap_disc_funds_check;
11539:

Line 11580: x_return_status := FND_API.G_RET_STS_SUCCESS;

11576: log_message('log_message: ' || 'Returning from ap funds check');
11577: END IF;
11578:
11579: -- set the return status to success
11580: x_return_status := FND_API.G_RET_STS_SUCCESS;
11581:
11582: pa_cc_utils.reset_curr_function;
11583:
11584: EXCEPTION

Line 11595: x_return_status := fnd_api.g_ret_sts_error;

11591: --Call FC packets update API to update packets to T.
11592: --moved to tr_import_funds_check
11593: --Upd_PktSts(p_packet_id => p_packet_id);
11594:
11595: x_return_status := fnd_api.g_ret_sts_error;
11596: x_error_message_code := 'PA_FC_NDF';
11597:
11598: pa_cc_utils.reset_curr_function;
11599: RAISE;

Line 11606: x_return_status := fnd_api.g_ret_sts_unexp_error;

11602: WHEN OTHERS THEN
11603: IF PG_DEBUG = 'Y' THEN
11604: log_message('log_message: ' || sqlerrm||' Returning from ap funds check');
11605: END IF;
11606: x_return_status := fnd_api.g_ret_sts_unexp_error;
11607: pa_cc_utils.reset_curr_function;
11608: RAISE;
11609: END ap_funds_check;
11610:

Line 11803: x_return_status := FND_API.G_RET_STS_SUCCESS;

11799: log_message('log_message: ' || 'Returning from po funds check');
11800: END IF;
11801:
11802: -- set the return status to success
11803: x_return_status := FND_API.G_RET_STS_SUCCESS;
11804:
11805: pa_cc_utils.reset_curr_function;
11806:
11807: EXCEPTION

Line 11818: x_return_status := fnd_api.g_ret_sts_error;

11814: --Call FC packets update API to update packets to T.
11815: --moved to tr_import_funds_check
11816: --Upd_PktSts(p_packet_id => p_packet_id);
11817:
11818: x_return_status := fnd_api.g_ret_sts_error;
11819: x_error_message_code := 'PA_FC_NDF';
11820:
11821: pa_cc_utils.reset_curr_function;
11822: RAISE;

Line 11828: x_return_status := fnd_api.g_ret_sts_unexp_error;

11824: WHEN OTHERS THEN
11825: IF PG_DEBUG = 'Y' THEN
11826: log_message('log_message: ' || sqlerrm||' Returning from po funds check');
11827: END IF;
11828: x_return_status := fnd_api.g_ret_sts_unexp_error;
11829: pa_cc_utils.reset_curr_function;
11830: RAISE;
11831: END po_funds_check;
11832:

Line 11959: x_return_status := FND_API.G_RET_STS_SUCCESS;

11955: log_message('log_message: ' || 'Returning from ap_po funds check');
11956: END IF;
11957:
11958: -- set the return status to success
11959: x_return_status := FND_API.G_RET_STS_SUCCESS;
11960:
11961: pa_cc_utils.reset_curr_function;
11962:
11963: EXCEPTION

Line 11968: x_return_status := fnd_api.g_ret_sts_unexp_error;

11964: WHEN OTHERS THEN
11965: IF PG_DEBUG = 'Y' THEN
11966: log_message('log_message: ' || sqlerrm||' Returning from ap po funds check');
11967: END IF;
11968: x_return_status := fnd_api.g_ret_sts_unexp_error;
11969: pa_cc_utils.reset_curr_function;
11970: RAISE;
11971: END ap_po_funds_check;
11972:

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

12348: ' Work Type Id = ' || G_Work_Type_Id ||
12349: ' Tp Amt Type = ' || G_Tp_Amt_Type_Code);
12350: END IF;
12351:
12352: IF (l_asgn_work_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
12353:
12354: IF PG_DEBUG = 'Y' THEN
12355: pa_debug.G_err_stage := 'Get Work Type and Assignment API failed';
12356: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 12792: x_return_status := FND_API.G_RET_STS_SUCCESS;

12788: log_message('log_message: ' || 'After calling insert_cash_ap_bc_packets');
12789: END IF;
12790:
12791: -- set the return status to success
12792: x_return_status := FND_API.G_RET_STS_SUCCESS;
12793:
12794: pa_cc_utils.reset_curr_function;
12795:
12796: EXCEPTION

Line 12808: x_return_status := fnd_api.g_ret_sts_unexp_error;

12804: WHEN OTHERS THEN
12805: IF PG_DEBUG = 'Y' THEN
12806: log_message('log_message: ' || sqlerrm||' Returning from ap funds check');
12807: END IF;
12808: x_return_status := fnd_api.g_ret_sts_unexp_error;
12809: pa_cc_utils.reset_curr_function;
12810: RAISE;
12811: END ap_cash_based_funds_check;
12812: