[Home] [Help]
693: l_payer_num_id NUMBER;
694: l_payer_id VARCHAR2(80);
695: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
696: l_note_payer_type VARCHAR2(100);
697: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
698: l_fun_currency VARCHAR2(80);
699: l_template_id NUMBER;
700: l_request_id number;
701: l_autofulfill varchar2(1);
1688: END IF;
1689: END LOOP;
1690:
1691: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1692: iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_NOTES_PVT.Create_Note');
1693: END IF;
1694:
1695: IEX_NOTES_PVT.Create_Note(
1696: P_API_VERSION => l_api_version,
1691: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1692: iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_NOTES_PVT.Create_Note');
1693: END IF;
1694:
1695: IEX_NOTES_PVT.Create_Note(
1696: P_API_VERSION => l_api_version,
1697: P_INIT_MSG_LIST => FND_API.G_FALSE,
1698: P_COMMIT => FND_API.G_FALSE,
1699: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1707: p_contexts_tbl => l_context_tab,
1708: x_note_id => X_PMTRESP_REC.NOTE_ID);
1709:
1710: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1711: iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
1712: iex_debug_pub.LogMessage(l_api_name || ': Status = ' || L_RETURN_STATUS);
1713: END IF;
1714:
1715: -- check for errors
1714:
1715: -- check for errors
1716: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1718: iex_debug_pub.LogMessage(l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1719: END IF;
1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722: END IF;
1804: l_payer_num_id NUMBER;
1805: l_payer_id VARCHAR2(80);
1806: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1807: l_note_payer_type VARCHAR2(100);
1808: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1809: l_pay_okl_ref_id NUMBER;
1810: l_template_id NUMBER;
1811: l_request_id number;
1812: l_autofulfill varchar2(1);
2764: END IF;
2765: END LOOP;
2766:
2767: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2768: iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_NOTES_PVT.Create_Note');
2769: END IF;
2770: IEX_NOTES_PVT.Create_Note(
2771: P_API_VERSION => l_api_version,
2772: P_INIT_MSG_LIST => FND_API.G_FALSE,
2766:
2767: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2768: iex_debug_pub.LogMessage(l_api_name || ': Before call to IEX_NOTES_PVT.Create_Note');
2769: END IF;
2770: IEX_NOTES_PVT.Create_Note(
2771: P_API_VERSION => l_api_version,
2772: P_INIT_MSG_LIST => FND_API.G_FALSE,
2773: P_COMMIT => FND_API.G_FALSE,
2774: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2781: p_notes => P_PMT_REC.NOTE,
2782: p_contexts_tbl => l_context_tab,
2783: x_note_id => X_PMTRESP_REC.NOTE_ID);
2784: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2785: iex_debug_pub.LogMessage(l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
2786: iex_debug_pub.LogMessage(l_api_name || ': Status = ' || L_RETURN_STATUS);
2787: END IF;
2788:
2789: -- check for errors
2788:
2789: -- check for errors
2790: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2791: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2792: iex_debug_pub.LogMessage(l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2793: END IF;
2794: RAISE FND_API.G_EXC_ERROR;
2795: END IF;
2796: