DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on IEX_NOTES_PVT

Line 1072: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

1068: l_payer_num_id NUMBER;
1069: l_payer_id VARCHAR2(80);
1070: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1071: l_note_payer_type VARCHAR2(100);
1072: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1073: l_note_id NUMBER;
1074: l_org_id number; --Added for bug 7237026 barathsr 17-Nov-2008
1075:
1076:

Line 1297: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');

1293: END IF;
1294: END LOOP;
1295:
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1298: END IF;
1299:
1300: IEX_NOTES_PVT.Create_Note(
1301: P_API_VERSION => 1.0,

Line 1300: IEX_NOTES_PVT.Create_Note(

1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1298: END IF;
1299:
1300: IEX_NOTES_PVT.Create_Note(
1301: P_API_VERSION => 1.0,
1302: P_INIT_MSG_LIST => 'F',
1303: P_COMMIT => 'F',
1304: P_VALIDATION_LEVEL => 100,

Line 1318: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');

1314:
1315: X_PRORESP_REC.NOTE_ID := l_note_id;
1316:
1317: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1318: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
1319: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1320: END IF;
1321:
1322: -- check for errors

Line 1325: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');

1321:
1322: -- check for errors
1323: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1325: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1326: END IF;
1327: RAISE FND_API.G_EXC_ERROR;
1328: END IF;
1329: else

Line 1696: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

1692: l_payer_num_id NUMBER;
1693: l_payer_id VARCHAR2(80);
1694: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1695: l_note_payer_type VARCHAR2(100);
1696: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1697: l_note_id NUMBER;
1698: l_cust_id number;
1699: l_SQL VARCHAR2(1000);
1700: Type refCur is Ref Cursor;

Line 1847: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');

1843: END IF;
1844: END LOOP;
1845:
1846: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1847: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1848: END IF;
1849:
1850: IEX_NOTES_PVT.Create_Note(
1851: P_API_VERSION => 1.0,

Line 1850: IEX_NOTES_PVT.Create_Note(

1846: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1847: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1848: END IF;
1849:
1850: IEX_NOTES_PVT.Create_Note(
1851: P_API_VERSION => 1.0,
1852: P_INIT_MSG_LIST => 'F',
1853: P_COMMIT => 'F',
1854: P_VALIDATION_LEVEL => 100,

Line 1868: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');

1864:
1865: X_PRORESP_REC.NOTE_ID := l_note_id;
1866:
1867: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1868: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
1869: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1870: END IF;
1871:
1872: -- check for errors

Line 1875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');

1871:
1872: -- check for errors
1873: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1874: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1876: END IF;
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF;
1879: else

Line 2003: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

1999: l_payer_num_id NUMBER;
2000: l_payer_id VARCHAR2(80);
2001: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2002: l_note_payer_type VARCHAR2(100);
2003: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2004: l_note_id NUMBER;
2005: l_cust_id number;
2006: l_SQL VARCHAR2(1000);
2007: Type refCur is Ref Cursor;

Line 2126: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');

2122: END IF;
2123: END LOOP;
2124:
2125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2126: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2127: END IF;
2128:
2129: IEX_NOTES_PVT.Create_Note(
2130: P_API_VERSION => 1.0,

Line 2129: IEX_NOTES_PVT.Create_Note(

2125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2126: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2127: END IF;
2128:
2129: IEX_NOTES_PVT.Create_Note(
2130: P_API_VERSION => 1.0,
2131: P_INIT_MSG_LIST => 'F',
2132: P_COMMIT => 'F',
2133: P_VALIDATION_LEVEL => 100,

Line 2147: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');

2143:
2144: X_PRORESP_REC.NOTE_ID := l_note_id;
2145:
2146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2147: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
2148: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2149: END IF;
2150:
2151: -- check for errors

Line 2154: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');

2150:
2151: -- check for errors
2152: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2154: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2155: END IF;
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158: else

Line 2381: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

2377: l_payer_num_id NUMBER;
2378: l_payer_id VARCHAR2(80);
2379: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2380: l_note_payer_type VARCHAR2(100);
2381: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2382: l_note_id NUMBER;
2383: l_SQL VARCHAR2(1000);
2384: Type refCur is Ref Cursor;
2385: l_cursor refCur;

Line 2758: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');

2754: END IF;
2755: END LOOP;
2756:
2757: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2758: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2759: END IF;
2760: IEX_NOTES_PVT.Create_Note(
2761: P_API_VERSION => 1.0,
2762: P_INIT_MSG_LIST => 'F',

Line 2760: IEX_NOTES_PVT.Create_Note(

2756:
2757: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2758: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2759: END IF;
2760: IEX_NOTES_PVT.Create_Note(
2761: P_API_VERSION => 1.0,
2762: P_INIT_MSG_LIST => 'F',
2763: P_COMMIT => 'F',
2764: P_VALIDATION_LEVEL => 100,

Line 2776: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');

2772: p_contexts_tbl => l_context_tab,
2773: x_note_id => l_note_id);
2774:
2775: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2776: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
2777: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2778: END IF;
2779:
2780: -- check for errors

Line 2783: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');

2779:
2780: -- check for errors
2781: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2782: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2783: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2784: END IF;
2785: RAISE FND_API.G_EXC_ERROR;
2786: END IF;
2787: