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

Line 104: x_return_status := Fnd_Api.G_Ret_Sts_Success;

100: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');
101: l_api_name := g_full_path||'.Delete_Events';
102: -- Update the calling sequence --
103: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
104: x_return_status := Fnd_Api.G_Ret_Sts_Success;
105: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
106: Fnd_Msg_Pub.Initialize;
107: END IF;
108: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Delete_Events..' );

Line 105: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

101: l_api_name := g_full_path||'.Delete_Events';
102: -- Update the calling sequence --
103: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
104: x_return_status := Fnd_Api.G_Ret_Sts_Success;
105: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
106: Fnd_Msg_Pub.Initialize;
107: END IF;
108: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Delete_Events..' );
109: psa_utils.debug_other_string(g_state_level,l_api_name, 'p_ledger_id '||p_ledger_id);

Line 192: x_return_status := Fnd_Api.G_Ret_Sts_Error;

188: );
189: IF l_return_status <> 'S' THEN
190: psa_utils.debug_other_string(g_error_level,l_api_name,
191: ' PSA_AP_BC_PVT.CREATE_EVENT Failed after calling fv_utility.delete_fv_bc_orphan!');
192: x_return_status := Fnd_Api.G_Ret_Sts_Error;
193: END IF;
194: END IF;
195: */
196: psa_utils.debug_other_string(g_state_level,l_api_name,'End of Procedure Delete_Events' );

Line 199: x_return_status := Fnd_Api.G_Ret_Sts_Error;

195: */
196: psa_utils.debug_other_string(g_state_level,l_api_name,'End of Procedure Delete_Events' );
197: EXCEPTION
198: WHEN OTHERS THEN
199: x_return_status := Fnd_Api.G_Ret_Sts_Error;
200: IF (SQLCODE <> -20001) THEN
201: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
202: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
203: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 236: p_return_status := Fnd_Api.G_Ret_Sts_Success;

232: l_event_status_code xla_events.event_status_code%TYPE;
233: l_entity_ret_code INTEGER;
234: BEGIN
235: l_path_name := g_full_path || '.delete_unprocessed_events';
236: p_return_status := Fnd_Api.G_Ret_Sts_Success;
237: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure delete_unprocessed_events ' );
238: l_curr_calling_sequence := p_calling_sequence||l_path_name;
239:
240: l_event_source_info.source_application_id := NULL;

Line 303: p_return_status := Fnd_Api.G_Ret_Sts_Error;

299: (
300: p_count => p_msg_count,
301: p_data => p_msg_data
302: );
303: p_return_status := Fnd_Api.G_Ret_Sts_Error;
304: EXIT;
305: END IF;
306:
307: UPDATE ap_invoice_distributions_all

Line 359: p_return_status := Fnd_Api.G_Ret_Sts_Error;

355: (
356: p_count => p_msg_count,
357: p_data => p_msg_data
358: );
359: p_return_status := Fnd_Api.G_Ret_Sts_Error;
360: EXIT;
361: END IF;
362: END LOOP;
363: psa_utils.debug_other_string(g_state_level,l_path_name, 'Finished Deleting Orphan Events');

Line 367: IF (p_return_status = Fnd_Api.G_Ret_Sts_Error) THEN

363: psa_utils.debug_other_string(g_state_level,l_path_name, 'Finished Deleting Orphan Events');
364: END IF;
365: l_curr_org_id := p_tab_fc_dist(i).org_id;
366: l_curr_invoice_id := p_tab_fc_dist(i).invoice_id;
367: IF (p_return_status = Fnd_Api.G_Ret_Sts_Error) THEN
368: EXIT;
369: END IF;
370: END LOOP;
371: EXCEPTION

Line 373: p_return_status := Fnd_Api.G_Ret_Sts_Error;

369: END IF;
370: END LOOP;
371: EXCEPTION
372: WHEN OTHERS THEN
373: p_return_status := Fnd_Api.G_Ret_Sts_Error;
374: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
375: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
376: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
377: FND_MESSAGE.SET_TOKEN('PARAMETERS','');

Line 416: x_init_msg_list VARCHAR2(300):= fnd_api.g_true;

412: x_rev_entity_id INTEGER;
413: x_new_event_id INTEGER;
414: x_new_entity_id INTEGER;
415: x_api_version NUMBER := 1.0;
416: x_init_msg_list VARCHAR2(300):= fnd_api.g_true;
417: x_application_id INTEGER := 200;
418: x_reversal_method VARCHAR2(300):= 'SIDE';
419: x_post_to_gl_flag VARCHAR2(300):= 'N';
420:

Line 462: p_return_status := Fnd_Api.G_Ret_Sts_Success;

458: WHERE aps.bc_event_id = xe.event_id)
459: ORDER BY xe.event_id;
460: BEGIN
461: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_Processed_Orphan_Events');
462: p_return_status := Fnd_Api.G_Ret_Sts_Success;
463: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
464: Fnd_Msg_Pub.Initialize;
465: END IF;
466:

Line 463: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

459: ORDER BY xe.event_id;
460: BEGIN
461: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_Processed_Orphan_Events');
462: p_return_status := Fnd_Api.G_Ret_Sts_Success;
463: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
464: Fnd_Msg_Pub.Initialize;
465: END IF;
466:
467: l_path_name := g_full_path|| '.delete_processed_orphan_events';

Line 579: p_return_status := Fnd_Api.G_Ret_Sts_Error;

575: orphan_event_rec.gl_transfer_status_code||' '||
576: 'Failed' );
577: IF (x_msg_data is not null) then
578: psa_utils.debug_other_string(g_state_level,l_path_name, 'Error Message: '||x_msg_data);
579: p_return_status := Fnd_Api.G_Ret_Sts_Error;
580: END IF;
581: END IF;
582:
583: END LOOP;

Line 593: p_return_status := Fnd_Api.G_Ret_Sts_Error;

589: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.delete_processed_orphan_events');
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: p_return_status := Fnd_Api.G_Ret_Sts_Error;
594: IF (SQLCODE <> -20001) THEN
595: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
596: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
597: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', p_calling_sequence);

Line 789: x_return_status := Fnd_Api.G_Ret_Sts_Success;

785: l_api_name := g_full_path||'.Create_events';
786: -- Update the calling sequence --
787: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc|| '<-'||p_calling_sequence;
788:
789: x_return_status := Fnd_Api.G_Ret_Sts_Success;
790: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
791: Fnd_Msg_Pub.Initialize;
792: END IF;
793: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Create_Events..' );

Line 790: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

786: -- Update the calling sequence --
787: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc|| '<-'||p_calling_sequence;
788:
789: x_return_status := Fnd_Api.G_Ret_Sts_Success;
790: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
791: Fnd_Msg_Pub.Initialize;
792: END IF;
793: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Create_Events..' );
794: IF p_tab_fc_dist.COUNT < 1 THEN -- no rows to be processed

Line 884: IF (x_return_status = Fnd_Api.G_Ret_Sts_Error) THEN

880: p_msg_count => x_msg_count,
881: p_msg_data => x_msg_data
882: );
883:
884: IF (x_return_status = Fnd_Api.G_Ret_Sts_Error) THEN
885: RETURN;
886: END IF;
887:
888: FOR i IN p_tab_fc_dist.FIRST..p_tab_fc_dist.LAST

Line 1174: x_return_status := Fnd_Api.G_Ret_Sts_Error;

1170: FROM ap_invoice_distributions_all aid2
1171: WHERE aid1.invoice_id = aid2.invoice_id
1172: AND isprepaydist( aid2.invoice_distribution_id,aid2.invoice_id,aid2.line_type_lookup_code)='N');
1173:
1174: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1175: psa_utils.debug_other_string(g_error_level,l_api_name, ' PSA_AP_BC_PVT.CREATE_EVENT Failed ');
1176: psa_utils.debug_other_string(g_error_level,l_api_name, 'ERROR: Wrong BC event stamped on distributions for invoice id: ' || p_tab_fc_dist(1).invoice_id );
1177: fnd_message.set_name('PSA','PSA_AP_BC_STAMPING_ERROR');
1178: fnd_message.set_token('INVOICE_ID',p_tab_fc_dist(1).invoice_id);

Line 1198: x_return_status := Fnd_Api.G_Ret_Sts_Error;

1194: END IF;
1195: -- Checking wrong bc event stamped on item/prepay distribution END
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1199: IF (SQLCODE <> -20001) THEN
1200: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1201: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1202: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 1237: x_return_status := Fnd_Api.G_Ret_Sts_Success;

1233: l_log_msg VARCHAR2(2000);
1234:
1235: BEGIN
1236: l_api_name := g_full_path || '.Get_Detailed_Results';
1237: x_return_status := Fnd_Api.G_Ret_Sts_Success;
1238: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Get_Detailed_Results' );
1239: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
1240: Fnd_Msg_Pub.Initialize;
1241: END IF;

Line 1239: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

1235: BEGIN
1236: l_api_name := g_full_path || '.Get_Detailed_Results';
1237: x_return_status := Fnd_Api.G_Ret_Sts_Success;
1238: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Get_Detailed_Results' );
1239: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
1240: Fnd_Msg_Pub.Initialize;
1241: END IF;
1242:
1243: -- Update the calling sequence --

Line 1308: x_return_status := Fnd_Api.G_Ret_Sts_Error;

1304: END LOOP;
1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1309: IF (SQLCODE <> -20001) THEN
1310: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1311: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1312: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 2086: x_return_status := Fnd_Api.G_Ret_Sts_Success;

2082: END IF; /* l_process_dist */
2083:
2084: END LOOP; --PLSQL end loop
2085:
2086: x_return_status := Fnd_Api.G_Ret_Sts_Success;
2087: IF po_api_table_t.count > 0 THEN
2088: psa_utils.debug_other_string(g_state_level,l_api_name,'po_api_table_t.count '||po_api_table_t.count);
2089: FOR i IN po_api_table_t.FIRST..po_api_table_t.LAST LOOP
2090:

Line 2097: p_commit => FND_API.G_FALSE,

2093:
2094: PO_INTG_DOCUMENT_FUNDS_GRP.reinstate_po_encumbrance
2095: (
2096: p_api_version => 1.0,
2097: p_commit => FND_API.G_FALSE,
2098: p_init_msg_list => FND_API.G_FALSE,
2099: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2100: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
2101: p_invoice_id => po_api_table_t(i).l_api_inv_id,

Line 2098: p_init_msg_list => FND_API.G_FALSE,

2094: PO_INTG_DOCUMENT_FUNDS_GRP.reinstate_po_encumbrance
2095: (
2096: p_api_version => 1.0,
2097: p_commit => FND_API.G_FALSE,
2098: p_init_msg_list => FND_API.G_FALSE,
2099: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2100: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
2101: p_invoice_id => po_api_table_t(i).l_api_inv_id,
2102: p_encumbrance_amt => po_api_table_t(i).l_api_rev_po_enc_amt,

Line 2099: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2095: (
2096: p_api_version => 1.0,
2097: p_commit => FND_API.G_FALSE,
2098: p_init_msg_list => FND_API.G_FALSE,
2099: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2100: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
2101: p_invoice_id => po_api_table_t(i).l_api_inv_id,
2102: p_encumbrance_amt => po_api_table_t(i).l_api_rev_po_enc_amt,
2103: p_qty_cancelled => po_api_table_t(i).l_api_po_qty,

Line 2118: x_return_status := Fnd_Api.G_Ret_Sts_Error;

2114:
2115: --return status
2116: IF l_return_status <> 'S' THEN
2117: psa_utils.debug_other_string(g_state_level,l_api_name,'Failed for PO distribution '||po_api_table_t(i).l_api_po_dist_id );
2118: x_return_status := Fnd_Api.G_Ret_Sts_Error;
2119: Exit;
2120: END IF;
2121:
2122: END LOOP;

Line 2131: x_return_status := Fnd_Api.G_Ret_Sts_Error;

2127: END IF;
2128:
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: x_return_status := Fnd_Api.G_Ret_Sts_Error;
2132: IF (SQLCODE <> -20001) THEN
2133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

Line 2260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: psa_utils.debug_other_string(g_excep_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));
2259: psa_utils.debug_other_string(g_excep_level,l_api_name,'Error in Get_PO_Reversed_Encumb_Amount Procedure');
2260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2261: END Get_PO_Reversed_Encumb_Amount;
2262: -------------------------------------------------------------
2263: FUNCTION isprepaydist
2264: (