APPS.IEX_WRITEOFFS_PVT dependencies on FND_LOG

Line 17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13:
14:
15: -- Hint: Primary key needs to be returned.
16: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18:
19: PROCEDURE Create_writeoffs(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

40:
41: Cursor c2 is SELECT IEX_WRITEOFFS_S.nextval from dual;
42: BEGIN
43: -- IF PG_DEBUG < 10 THEN
44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
45: IEX_DEBUG_PUB.LogMessage ('Create_writeoffs: ' || '********* start of Procedure =>'||
46: 'IEX_WRITEOFFS_PVT.create_WRITEOFFS ******** ');
47: END IF;
48:

Line 88: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

84: END IF;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: -- IF PG_DEBUG < 10 THEN
88: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
89: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After Global user Check');
90: END IF;
91:
92: --object version Number

Line 97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

93: v_object_version_number :=1;
94: --Active_flag
95: v_active_flag :='Y';
96: -- IF PG_DEBUG < 10 THEN
97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
98: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'Active Flag is '|| v_active_flag);
99: END IF;
100:
101: OPEN C2;

Line 105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

101: OPEN C2;
102: FETCH C2 INTO v_writeoff_id;
103: CLOSE C2;
104: -- IF PG_DEBUG < 10 THEN
105: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
106: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_id Check and writeoff_id is =>'||
107: v_writeoff_id);
108: END IF;
109:

Line 119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

115: fnd_msg_pub.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
120: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_type Check ');
121: END IF;
122:
123: IF (p_writeoffs_rec.writeoff_reason IS NULL) OR

Line 132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

128: fnd_msg_pub.add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131:
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After writeoff_reason Check ');
134: END IF;
135:
136: IF (p_writeoffs_rec.party_id IS NULL) OR

Line 144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

140: fnd_message.set_token('MISSING_PARAM', 'party_id');
141: fnd_msg_pub.add;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
145: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After party_id Check ');
146: END IF;
147:
148:

Line 218: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

214:
215:
216: x_WRITEOFF_ID := v_WRITEOFF_ID;
217: -- IF PG_DEBUG < 10 THEN
218: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
219: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After Calling IEX_WRITEOFFS_PKG.'||
220: 'Insert_Row and WRITEOFF_ID is => '||x_WRITEOFF_ID);
221: END IF;
222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

240: ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: -- IF PG_DEBUG < 10 THEN
244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
245: IEX_DEBUG_PUB.LogMessage ('Create_writeoffs: ' || '********* end of Procedure =>'||
246: 'IEX_WRITEOFFS_PVT.create_WRITEOFFS ******** ');
247: END IF;
248:

Line 305: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

301: :=p_writeoffs_Rec.object_version_number;
302: */
303: BEGIN
304: -- IF PG_DEBUG < 10 THEN
305: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
306: IEX_DEBUG_PUB.LogMessage ('Update_writeoffs: ' || '********* start of Procedure =>'||
307: 'IEX_WRITEOFFS_PVT.update_WRITEOFFS ******** ');
308: END IF;
309: -- Standard Start of API savepoint

Line 345: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

341: P_WRITEOFFS_Rec.writeoff_id,
342: l_object_version_number
343: );
344: */
345: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
346: IEX_DEBUG_PUB.LogMessage ('IEX_WRITEOFFS_PVT.update_WRITEOFFS, before calling IEX_WRITEOFFS_PKG.Update_Row');
347: END IF;
348:
349: -- Invoke table handler(IEX_WRITEOFFS_PKG.Update_Row)

Line 415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

411:
412: --
413: -- End of API body.
414: --
415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
416: IEX_DEBUG_PUB.LogMessage ('IEX_WRITEOFFS_PVT.update_WRITEOFFS is successfull');
417: END IF;
418: -- Standard check for p_commit
419: IF FND_API.to_Boolean( p_commit )

Line 431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

427: p_data => x_msg_data
428: );
429:
430: -- IF PG_DEBUG < 10 THEN
431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
432: IEX_DEBUG_PUB.LogMessage ('Update_writeoffs: ' || '********* END of Procedure =>'||
433: 'IEX_WRITEOFFS_PVT.update_WRITEOFFS ******** ');
434: END IF;
435:

Line 489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

485: l_api_version_number CONSTANT NUMBER := 2.0;
486:
487: BEGIN
488: -- IF PG_DEBUG < 10 THEN
489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
490: IEX_DEBUG_PUB.LogMessage ('Delete_writeoffs: ' || '********* Start of Procedure =>'||
491: 'IEX_WRITEOFFS_PVT.DELETE_WRITEOFFS ******** ');
492: END IF;
493:

Line 538: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

534: END IF;
535:
536:
537: -- IF PG_DEBUG < 10 THEN
538: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
539: IEX_DEBUG_PUB.LogMessage ('Delete_writeoffs: ' || '********* End of Procedure =>'||
540: 'IEX_WRITEOFFS_PVT.DELETE_WRITEOFFS ******** ');
541: END IF;
542: