DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on IEX_NOTES_PVT

Line 1087: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

1083: l_payer_num_id NUMBER;
1084: l_payer_id VARCHAR2(80);
1085: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1086: l_note_payer_type VARCHAR2(100);
1087: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1088: l_note_id NUMBER;
1089: l_org_id number; --Added for bug 7237026 barathsr 17-Nov-2008
1090:
1091:

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

1332: END IF;
1333: END LOOP;
1334:
1335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1336: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1337: END IF;
1338:
1339: IEX_NOTES_PVT.Create_Note(
1340: P_API_VERSION => 1.0,

Line 1339: IEX_NOTES_PVT.Create_Note(

1335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1336: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1337: END IF;
1338:
1339: IEX_NOTES_PVT.Create_Note(
1340: P_API_VERSION => 1.0,
1341: P_INIT_MSG_LIST => 'F',
1342: P_COMMIT => 'F',
1343: P_VALIDATION_LEVEL => 100,

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

1353:
1354: X_PRORESP_REC.NOTE_ID := l_note_id;
1355:
1356: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1357: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
1358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1359: END IF;
1360:
1361: -- check for errors

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

1360:
1361: -- check for errors
1362: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1364: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1365: END IF;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: else

Line 1735: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

1731: l_payer_num_id NUMBER;
1732: l_payer_id VARCHAR2(80);
1733: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
1734: l_note_payer_type VARCHAR2(100);
1735: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
1736: l_note_id NUMBER;
1737: l_cust_id number;
1738: l_SQL VARCHAR2(1000);
1739: Type refCur is Ref Cursor;

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

1905: END IF;
1906: END LOOP;
1907:
1908: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1909: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1910: END IF;
1911:
1912: IEX_NOTES_PVT.Create_Note(
1913: P_API_VERSION => 1.0,

Line 1912: IEX_NOTES_PVT.Create_Note(

1908: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1909: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
1910: END IF;
1911:
1912: IEX_NOTES_PVT.Create_Note(
1913: P_API_VERSION => 1.0,
1914: P_INIT_MSG_LIST => 'F',
1915: P_COMMIT => 'F',
1916: P_VALIDATION_LEVEL => 100,

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

1926:
1927: X_PRORESP_REC.NOTE_ID := l_note_id;
1928:
1929: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1930: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
1931: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1932: END IF;
1933:
1934: -- check for errors

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

1933:
1934: -- check for errors
1935: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1936: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1937: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1938: END IF;
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941: else

Line 2065: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

2061: l_payer_num_id NUMBER;
2062: l_payer_id VARCHAR2(80);
2063: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2064: l_note_payer_type VARCHAR2(100);
2065: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2066: l_note_id NUMBER;
2067: l_cust_id number;
2068: l_SQL VARCHAR2(1000);
2069: Type refCur is Ref Cursor;

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

2223: END IF;
2224: END LOOP;
2225:
2226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2227: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2228: END IF;
2229:
2230: IEX_NOTES_PVT.Create_Note(
2231: P_API_VERSION => 1.0,

Line 2230: IEX_NOTES_PVT.Create_Note(

2226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2227: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2228: END IF;
2229:
2230: IEX_NOTES_PVT.Create_Note(
2231: P_API_VERSION => 1.0,
2232: P_INIT_MSG_LIST => 'F',
2233: P_COMMIT => 'F',
2234: P_VALIDATION_LEVEL => 100,

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

2244:
2245: X_PRORESP_REC.NOTE_ID := l_note_id;
2246:
2247: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2248: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
2249: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2250: END IF;
2251:
2252: -- check for errors

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

2251:
2252: -- check for errors
2253: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2256: END IF;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259: else

Line 2482: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;

2478: l_payer_num_id NUMBER;
2479: l_payer_id VARCHAR2(80);
2480: l_payer_name HZ_PARTIES.PARTY_NAME%TYPE; --Changed the datatype for bug#5652085 by ehuh 2/28/07
2481: l_note_payer_type VARCHAR2(100);
2482: l_context_tab IEX_NOTES_PVT.CONTEXTS_TBL_TYPE;
2483: l_note_id NUMBER;
2484: l_SQL VARCHAR2(1000);
2485: Type refCur is Ref Cursor;
2486: l_cursor refCur;

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

2903: END IF;
2904: END LOOP;
2905:
2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2907: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2908: END IF;
2909: IEX_NOTES_PVT.Create_Note(
2910: P_API_VERSION => 1.0,
2911: P_INIT_MSG_LIST => 'F',

Line 2909: IEX_NOTES_PVT.Create_Note(

2905:
2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2907: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_NOTES_PVT.Create_Note...');
2908: END IF;
2909: IEX_NOTES_PVT.Create_Note(
2910: P_API_VERSION => 1.0,
2911: P_INIT_MSG_LIST => 'F',
2912: P_COMMIT => 'F',
2913: P_VALIDATION_LEVEL => 100,

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

2921: p_contexts_tbl => l_context_tab,
2922: x_note_id => l_note_id);
2923:
2924: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2925: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_NOTES_PVT.Create_Note');
2926: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2927: END IF;
2928:
2929: -- check for errors

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

2928:
2929: -- check for errors
2930: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2931: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2933: END IF;
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;
2936: