DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on FND_API

Line 91: x_return_status := Fnd_Api.G_Ret_Sts_Success;

87: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');
88: l_api_name := g_full_path||'.Delete_Events';
89: -- Update the calling sequence --
90: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
91: x_return_status := Fnd_Api.G_Ret_Sts_Success;
92: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
93: Fnd_Msg_Pub.Initialize;
94: END IF;
95: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Delete_Events..' );

Line 92: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

88: l_api_name := g_full_path||'.Delete_Events';
89: -- Update the calling sequence --
90: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||'<-'||p_calling_sequence;
91: x_return_status := Fnd_Api.G_Ret_Sts_Success;
92: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
93: Fnd_Msg_Pub.Initialize;
94: END IF;
95: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Delete_Events..' );
96: psa_utils.debug_other_string(g_state_level,l_api_name, 'p_ledger_id '||p_ledger_id);

Line 165: x_return_status := Fnd_Api.G_Ret_Sts_Error;

161: fnd_file.put_line(fnd_file.log ,'<< PSA_AP_BC_PVT.Delete_EVENTS');
162: psa_utils.debug_other_string(g_state_level,l_api_name,'End of Procedure Delete_Events' );
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_return_status := Fnd_Api.G_Ret_Sts_Error;
166: IF (SQLCODE <> -20001) THEN
167: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
168: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
169: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 295: x_return_status := Fnd_Api.G_Ret_Sts_Success;

291: -- Update the calling sequence --
292: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||
293: '<-'||p_calling_sequence;
294:
295: x_return_status := Fnd_Api.G_Ret_Sts_Success;
296: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
297: Fnd_Msg_Pub.Initialize;
298: END IF;
299: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Create_Events..' );

Line 296: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

292: l_curr_calling_sequence := 'PSA_AP_BC_PVT.'||l_debug_loc||
293: '<-'||p_calling_sequence;
294:
295: x_return_status := Fnd_Api.G_Ret_Sts_Success;
296: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
297: Fnd_Msg_Pub.Initialize;
298: END IF;
299: psa_utils.debug_other_string(g_state_level,l_api_name, 'BEGIN of procedure Create_Events..' );
300: IF p_tab_fc_dist.COUNT < 1 THEN -- no rows to be processed

Line 697: x_return_status := Fnd_Api.G_Ret_Sts_Error;

693: AND isprepaydist( aid2.invoice_distribution_id
694: ,aid2.invoice_id
695: ,aid2.line_type_lookup_code)='N');
696:
697: x_return_status := Fnd_Api.G_Ret_Sts_Error;
698: psa_utils.debug_other_string(g_error_level,l_api_name, ' PSA_AP_BC_PVT.CREATE_EVENT Failed ');
699: psa_utils.debug_other_string(g_error_level,l_api_name,
700: 'ERROR: Wrong BC event stamped on distributions for invoice id: '
701: || p_tab_fc_dist(1).invoice_id );

Line 712: x_return_status := Fnd_Api.G_Ret_Sts_Error;

708: -- Checking wrong bc event stamped on item/prepay distribution END
709:
710: EXCEPTION
711: WHEN OTHERS THEN
712: x_return_status := Fnd_Api.G_Ret_Sts_Error;
713: IF (SQLCODE <> -20001) THEN
714: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 752: x_return_status := Fnd_Api.G_Ret_Sts_Success;

748: l_log_msg VARCHAR2(2000);
749:
750: BEGIN
751: l_api_name := g_full_path || '.Get_Detailed_Results';
752: x_return_status := Fnd_Api.G_Ret_Sts_Success;
753: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Get_Detailed_Results' );
754: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
755:
756: Fnd_Msg_Pub.Initialize;

Line 754: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

750: BEGIN
751: l_api_name := g_full_path || '.Get_Detailed_Results';
752: x_return_status := Fnd_Api.G_Ret_Sts_Success;
753: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Get_Detailed_Results' );
754: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
755:
756: Fnd_Msg_Pub.Initialize;
757:
758: END IF;

Line 820: x_return_status := Fnd_Api.G_Ret_Sts_Error;

816: END LOOP;
817:
818: EXCEPTION
819: WHEN OTHERS THEN
820: x_return_status := Fnd_Api.G_Ret_Sts_Error;
821: IF (SQLCODE <> -20001) THEN
822: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
823: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
824: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

Line 1584: x_return_status := Fnd_Api.G_Ret_Sts_Success;

1580: END IF; /* l_process_dist */
1581:
1582: END LOOP; --PLSQL end loop
1583:
1584: x_return_status := Fnd_Api.G_Ret_Sts_Success;
1585: IF po_api_table_t.count > 0 THEN
1586: psa_utils.debug_other_string(g_state_level,l_api_name,'po_api_table_t.count '||po_api_table_t.count);
1587: FOR i IN po_api_table_t.FIRST..po_api_table_t.LAST
1588: LOOP

Line 1595: p_commit => FND_API.G_FALSE,

1591:
1592:
1593: PO_INTG_DOCUMENT_FUNDS_GRP.reinstate_po_encumbrance(
1594: p_api_version => 1.0,
1595: p_commit => FND_API.G_FALSE,
1596: p_init_msg_list => FND_API.G_FALSE,
1597: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1598: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
1599: p_invoice_id => po_api_table_t(i).l_api_inv_id,

Line 1596: p_init_msg_list => FND_API.G_FALSE,

1592:
1593: PO_INTG_DOCUMENT_FUNDS_GRP.reinstate_po_encumbrance(
1594: p_api_version => 1.0,
1595: p_commit => FND_API.G_FALSE,
1596: p_init_msg_list => FND_API.G_FALSE,
1597: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1598: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
1599: p_invoice_id => po_api_table_t(i).l_api_inv_id,
1600: p_encumbrance_amt => po_api_table_t(i).l_api_rev_po_enc_amt,

Line 1597: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1593: PO_INTG_DOCUMENT_FUNDS_GRP.reinstate_po_encumbrance(
1594: p_api_version => 1.0,
1595: p_commit => FND_API.G_FALSE,
1596: p_init_msg_list => FND_API.G_FALSE,
1597: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1598: p_distribution_id => po_api_table_t(i).l_api_po_dist_id,
1599: p_invoice_id => po_api_table_t(i).l_api_inv_id,
1600: p_encumbrance_amt => po_api_table_t(i).l_api_rev_po_enc_amt,
1601: p_qty_cancelled => po_api_table_t(i).l_api_po_qty,

Line 1615: x_return_status := Fnd_Api.G_Ret_Sts_Error;

1611:
1612: --return status
1613: IF l_return_status <> 'S' THEN
1614: 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 );
1615: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1616: Exit;
1617: END IF;
1618:
1619: END LOOP;

Line 1631: x_return_status := Fnd_Api.G_Ret_Sts_Error;

1627: END IF;
1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1632: IF (SQLCODE <> -20001) THEN
1633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1782:
1783: psa_utils.debug_other_string(g_excep_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));
1784: psa_utils.debug_other_string(g_excep_level,l_api_name,'Error in Get_PO_Reversed_Encumb_Amount Procedure');
1785:
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END Get_PO_Reversed_Encumb_Amount;
1788: -------------------------------------------------------------
1789: FUNCTION isprepaydist
1790: ( p_inv_dist_id IN NUMBER,