DBA Data[Home] [Help]

APPS.EC_CODE_CONVERSION_PVT dependencies on EC_DEBUG

Line 150: if EC_DEBUG.G_debug_level >= 2 then

146: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
147: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
148:
149: BEGIN
150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');

147: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
148:
149: BEGIN
150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

148:
149: BEGIN
150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

149: BEGIN
150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);

Line 154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

150: if EC_DEBUG.G_debug_level >= 2 then
151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);

Line 155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

151: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);

Line 156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

152: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);

Line 157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);

153: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);

Line 158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);

154: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);

Line 159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);

155: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);

Line 160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);

156: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);

Line 161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);

157: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);

Line 162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);

158: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);

Line 163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);

159: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);
167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);

Line 164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);

160: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);
167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);
168: end if;

Line 165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);

161: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);
167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);
168: end if;
169: -- Standard Start of API savepoint

Line 166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);

162: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);
167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);
168: end if;
169: -- Standard Start of API savepoint
170: -- SAVEPOINT Convert_from_ext_to_int_PVT;

Line 167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);

163: EC_DEBUG.PL(3, 'p_Ext_val1: ',p_Ext_val1);
164: EC_DEBUG.PL(3, 'p_Ext_val2: ',p_Ext_val2);
165: EC_DEBUG.PL(3, 'p_Ext_val3: ',p_Ext_val3);
166: EC_DEBUG.PL(3, 'p_Ext_val4: ',p_Ext_val4);
167: EC_DEBUG.PL(3, 'p_Ext_val5: ',p_Ext_val5);
168: end if;
169: -- Standard Start of API savepoint
170: -- SAVEPOINT Convert_from_ext_to_int_PVT;
171:

Line 304: if EC_DEBUG.G_debug_level >= 3 then

300: END IF;
301: CLOSE match_2;
302: END IF;
303: CLOSE match_3;
304: if EC_DEBUG.G_debug_level >= 3 then
305: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);
306: end if;
307: -- *******************************************************
308: -- Two (2) keys are supplied

Line 305: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);

301: CLOSE match_2;
302: END IF;
303: CLOSE match_3;
304: if EC_DEBUG.G_debug_level >= 3 then
305: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);
306: end if;
307: -- *******************************************************
308: -- Two (2) keys are supplied
309: -- *******************************************************

Line 370: if EC_DEBUG.G_debug_level = 3 then

366: -- If it can't find the value, then simply copy the external
367: -- value1 to internal value instead of giving out an error message.
368: p_Int_val := p_Ext_val1;
369: else
370: if EC_DEBUG.G_debug_level = 3 then
371: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);
372: end if;
373: p_Int_val := l_Int_val;
374:

Line 371: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);

367: -- value1 to internal value instead of giving out an error message.
368: p_Int_val := p_Ext_val1;
369: else
370: if EC_DEBUG.G_debug_level = 3 then
371: EC_DEBUG.PL(3, 'l_Int_val :', l_Int_val);
372: end if;
373: p_Int_val := l_Int_val;
374:
375: end if;

Line 382: if EC_DEBUG.G_debug_level >= 2 then

378: -- Standard call to get message count and if count is 1, get message info.
379: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
380: p_data => p_msg_data);
381:
382: if EC_DEBUG.G_debug_level >= 2 then
383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
384: end if;
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN

Line 383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');

379: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
380: p_data => p_msg_data);
381:
382: if EC_DEBUG.G_debug_level >= 2 then
383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');
384: end if;
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: -- ROLLBACK TO Convert_from_ext_to_int_PVT;

Line 397: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

393: p_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
395: p_data => p_msg_data);
396: WHEN OTHERS THEN
397: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
399: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

394: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
395: p_data => p_msg_data);
396: WHEN OTHERS THEN
397: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
399: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

Line 560: if EC_DEBUG.G_debug_level >= 2 then

556: (DIRECTION = 'OUT' or DIRECTION = 'BOTH');
557:
558: BEGIN
559:
560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');

557:
558: BEGIN
559:
560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

558: BEGIN
559:
560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

559:
560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);

Line 564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

560: if EC_DEBUG.G_debug_level >= 2 then
561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);

Line 565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

561: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);

Line 566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

562: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);

Line 567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);

563: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);

Line 568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);

564: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);

Line 569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);

565: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);

Line 570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);

566: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);
574: end if;

Line 571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);

567: EC_DEBUG.PL(3, 'p_Category: ',p_Category);
568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);
574: end if;
575: -- Standard Start of API savepoint

Line 572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);

568: EC_DEBUG.PL(3, 'p_Key1: ',p_Key1);
569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);
574: end if;
575: -- Standard Start of API savepoint
576: -- SAVEPOINT Convert_from_int_to_ext_PVT;

Line 573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);

569: EC_DEBUG.PL(3, 'p_Key2: ',p_Key2);
570: EC_DEBUG.PL(3, 'p_Key3: ',p_Key3);
571: EC_DEBUG.PL(3, 'p_Key4: ',p_Key4);
572: EC_DEBUG.PL(3, 'p_Key5: ',p_Key5);
573: EC_DEBUG.PL(3, 'p_Int_val: ',p_Int_val);
574: end if;
575: -- Standard Start of API savepoint
576: -- SAVEPOINT Convert_from_int_to_ext_PVT;
577:

Line 794: if EC_DEBUG.G_debug_level = 3 then

790: p_Ext_val2 := l_Ext_val2;
791: p_Ext_val3 := l_Ext_val3;
792: p_Ext_val4 := l_Ext_val4;
793: p_Ext_val5 := l_Ext_val5;
794: if EC_DEBUG.G_debug_level = 3 then
795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);

Line 795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);

791: p_Ext_val3 := l_Ext_val3;
792: p_Ext_val4 := l_Ext_val4;
793: p_Ext_val5 := l_Ext_val5;
794: if EC_DEBUG.G_debug_level = 3 then
795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);
799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);

Line 796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);

792: p_Ext_val4 := l_Ext_val4;
793: p_Ext_val5 := l_Ext_val5;
794: if EC_DEBUG.G_debug_level = 3 then
795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);
799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);
800: end if;

Line 797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);

793: p_Ext_val5 := l_Ext_val5;
794: if EC_DEBUG.G_debug_level = 3 then
795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);
799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);
800: end if;
801: end if;

Line 798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);

794: if EC_DEBUG.G_debug_level = 3 then
795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);
799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);
800: end if;
801: end if;
802:

Line 799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);

795: EC_DEBUG.PL(3, 'l_Ext_val1: ',l_Ext_val1);
796: EC_DEBUG.PL(3, 'l_Ext_val2: ',l_Ext_val2);
797: EC_DEBUG.PL(3, 'l_Ext_val3: ',l_Ext_val3);
798: EC_DEBUG.PL(3, 'l_Ext_val4: ',l_Ext_val4);
799: EC_DEBUG.PL(3, 'l_Ext_val5: ',l_Ext_val5);
800: end if;
801: end if;
802:
803: -- *******************************************************

Line 816: if EC_DEBUG.G_debug_level >= 2 then

812: */
813: -- Standard call to get message count and if count is 1, get message info.
814: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,p_data => p_msg_data);
815:
816: if EC_DEBUG.G_debug_level >= 2 then
817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
818: end if;
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN

Line 817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');

813: -- Standard call to get message count and if count is 1, get message info.
814: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,p_data => p_msg_data);
815:
816: if EC_DEBUG.G_debug_level >= 2 then
817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
818: end if;
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: -- ROLLBACK TO Convert_from_int_to_ext_PVT;

Line 831: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

827: p_return_status := FND_API.G_RET_STS_ERROR;
828: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
829: p_data => p_msg_data);
830: WHEN OTHERS THEN
831: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
833: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
834: p_return_status := FND_API.G_RET_STS_ERROR;
835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

828: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
829: p_data => p_msg_data);
830: WHEN OTHERS THEN
831: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
833: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
834: p_return_status := FND_API.G_RET_STS_ERROR;
835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
836: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

Line 903: if EC_DEBUG.G_debug_level >= 2 then

899: b_xref_data_found BOOLEAN;
900:
901: BEGIN
902:
903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

900:
901: BEGIN
902:
903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

901: BEGIN
902:
903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

902:
903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
910: end if;

Line 907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

903: if EC_DEBUG.G_debug_level >= 2 then
904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
910: end if;
911: -- Standard Start of API savepoint

Line 908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

904: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
910: end if;
911: -- Standard Start of API savepoint
912: SAVEPOINT populate_plsql_tbl_PVT;

Line 909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

905: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
906: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
907: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
908: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
909: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
910: end if;
911: -- Standard Start of API savepoint
912: SAVEPOINT populate_plsql_tbl_PVT;
913:

Line 964: if EC_DEBUG.G_debug_level >= 3 then

960: FOR j IN 1..p_key_tbl.count LOOP
961: IF p_tbl(i).xref_key1_source_column =
962: p_key_tbl(j).interface_column_name THEN
963: key1 := p_key_tbl(j).value;
964: if EC_DEBUG.G_debug_level >= 3 then
965: EC_DEBUG.PL(3, 'key1 :', key1);
966: end if;
967: EXIT;
968: END IF;

Line 965: EC_DEBUG.PL(3, 'key1 :', key1);

961: IF p_tbl(i).xref_key1_source_column =
962: p_key_tbl(j).interface_column_name THEN
963: key1 := p_key_tbl(j).value;
964: if EC_DEBUG.G_debug_level >= 3 then
965: EC_DEBUG.PL(3, 'key1 :', key1);
966: end if;
967: EXIT;
968: END IF;
969: END LOOP;

Line 979: if EC_DEBUG.G_debug_level >= 3 then

975: FOR j IN 1..p_key_tbl.count LOOP
976: IF p_tbl(i).xref_key2_source_column =
977: p_key_tbl(j).interface_column_name THEN
978: key2 := p_key_tbl(j).value;
979: if EC_DEBUG.G_debug_level >= 3 then
980: EC_DEBUG.PL(3, 'key2 :', key2);
981: end if;
982: EXIT;
983: END IF;

Line 980: EC_DEBUG.PL(3, 'key2 :', key2);

976: IF p_tbl(i).xref_key2_source_column =
977: p_key_tbl(j).interface_column_name THEN
978: key2 := p_key_tbl(j).value;
979: if EC_DEBUG.G_debug_level >= 3 then
980: EC_DEBUG.PL(3, 'key2 :', key2);
981: end if;
982: EXIT;
983: END IF;
984: END LOOP;

Line 993: if EC_DEBUG.G_debug_level >= 3 then

989: FOR j in 1..p_key_tbl.count LOOP
990: IF p_tbl(i).xref_key3_source_column =
991: p_key_tbl(j).interface_column_name THEN
992: key3 := p_key_tbl(j).value;
993: if EC_DEBUG.G_debug_level >= 3 then
994: EC_DEBUG.PL(3, 'key3 :', key3);
995: end if;
996: EXIT;
997: END IF;

Line 994: EC_DEBUG.PL(3, 'key3 :', key3);

990: IF p_tbl(i).xref_key3_source_column =
991: p_key_tbl(j).interface_column_name THEN
992: key3 := p_key_tbl(j).value;
993: if EC_DEBUG.G_debug_level >= 3 then
994: EC_DEBUG.PL(3, 'key3 :', key3);
995: end if;
996: EXIT;
997: END IF;
998: END LOOP;

Line 1007: if EC_DEBUG.G_debug_level >= 3 then

1003: FOR j IN 1..p_key_tbl.count LOOP
1004: IF p_tbl(i).xref_key4_source_column =
1005: p_key_tbl(j).interface_column_name THEN
1006: key4 := p_key_tbl(j).value;
1007: if EC_DEBUG.G_debug_level >= 3 then
1008: EC_DEBUG.PL(3, 'key4 :', key4);
1009: end if;
1010: EXIT;
1011: END IF;

Line 1008: EC_DEBUG.PL(3, 'key4 :', key4);

1004: IF p_tbl(i).xref_key4_source_column =
1005: p_key_tbl(j).interface_column_name THEN
1006: key4 := p_key_tbl(j).value;
1007: if EC_DEBUG.G_debug_level >= 3 then
1008: EC_DEBUG.PL(3, 'key4 :', key4);
1009: end if;
1010: EXIT;
1011: END IF;
1012: END LOOP;

Line 1021: if EC_DEBUG.G_debug_level >= 3 then

1017: FOR j IN 1..p_key_tbl.count LOOP
1018: IF p_tbl(i).xref_key5_source_column =
1019: p_key_tbl(j).interface_column_name THEN
1020: key5 := p_key_tbl(j).value;
1021: if EC_DEBUG.G_debug_level >= 3 then
1022: EC_DEBUG.PL(3, 'key5 :', key5);
1023: end if;
1024: EXIT;
1025: END IF;

Line 1022: EC_DEBUG.PL(3, 'key5 :', key5);

1018: IF p_tbl(i).xref_key5_source_column =
1019: p_key_tbl(j).interface_column_name THEN
1020: key5 := p_key_tbl(j).value;
1021: if EC_DEBUG.G_debug_level >= 3 then
1022: EC_DEBUG.PL(3, 'key5 :', key5);
1023: end if;
1024: EXIT;
1025: END IF;
1026: END LOOP;

Line 1070: if EC_DEBUG.G_debug_level = 3 then

1066: -- ******************************
1067:
1068: IF ext1 is NOT NULL
1069: THEN
1070: if EC_DEBUG.G_debug_level = 3 then
1071: EC_DEBUG.PL(3, 'ext1 :', ext1);
1072: end if;
1073: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1074: (p_gateway_tbl => p_tbl,

Line 1071: EC_DEBUG.PL(3, 'ext1 :', ext1);

1067:
1068: IF ext1 is NOT NULL
1069: THEN
1070: if EC_DEBUG.G_debug_level = 3 then
1071: EC_DEBUG.PL(3, 'ext1 :', ext1);
1072: end if;
1073: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1074: (p_gateway_tbl => p_tbl,
1075: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1086: if EC_DEBUG.G_debug_level = 3 then

1082: END IF;
1083:
1084: IF ext2 is NOT NULL
1085: THEN
1086: if EC_DEBUG.G_debug_level = 3 then
1087: EC_DEBUG.PL(3, 'ext2 :', ext2);
1088: end if;
1089: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1090: (p_gateway_tbl => p_tbl,

Line 1087: EC_DEBUG.PL(3, 'ext2 :', ext2);

1083:
1084: IF ext2 is NOT NULL
1085: THEN
1086: if EC_DEBUG.G_debug_level = 3 then
1087: EC_DEBUG.PL(3, 'ext2 :', ext2);
1088: end if;
1089: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1090: (p_gateway_tbl => p_tbl,
1091: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1102: if EC_DEBUG.G_debug_level = 3 then

1098: END IF;
1099:
1100: IF ext3 is NOT NULL
1101: THEN
1102: if EC_DEBUG.G_debug_level = 3 then
1103: EC_DEBUG.PL(3, 'ext3 :', ext3);
1104: end if;
1105: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1106: (p_gateway_tbl => p_tbl,

Line 1103: EC_DEBUG.PL(3, 'ext3 :', ext3);

1099:
1100: IF ext3 is NOT NULL
1101: THEN
1102: if EC_DEBUG.G_debug_level = 3 then
1103: EC_DEBUG.PL(3, 'ext3 :', ext3);
1104: end if;
1105: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1106: (p_gateway_tbl => p_tbl,
1107: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1118: if EC_DEBUG.G_debug_level = 3 then

1114: END IF;
1115:
1116: IF ext4 is NOT NULL
1117: THEN
1118: if EC_DEBUG.G_debug_level = 3 then
1119: EC_DEBUG.PL(3, 'ext4 :', ext4);
1120: end if;
1121: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1122: (p_gateway_tbl => p_tbl,

Line 1119: EC_DEBUG.PL(3, 'ext4 :', ext4);

1115:
1116: IF ext4 is NOT NULL
1117: THEN
1118: if EC_DEBUG.G_debug_level = 3 then
1119: EC_DEBUG.PL(3, 'ext4 :', ext4);
1120: end if;
1121: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1122: (p_gateway_tbl => p_tbl,
1123: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1134: if EC_DEBUG.G_debug_level = 3 then

1130: END IF;
1131:
1132: IF ext5 is NOT NULL
1133: THEN
1134: if EC_DEBUG.G_debug_level = 3 then
1135: EC_DEBUG.PL(3, 'ext5 :', ext5);
1136: end if;
1137: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1138: (p_gateway_tbl => p_tbl,

Line 1135: EC_DEBUG.PL(3, 'ext5 :', ext5);

1131:
1132: IF ext5 is NOT NULL
1133: THEN
1134: if EC_DEBUG.G_debug_level = 3 then
1135: EC_DEBUG.PL(3, 'ext5 :', ext5);
1136: end if;
1137: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1138: (p_gateway_tbl => p_tbl,
1139: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1185: if EC_DEBUG.G_debug_level >= 2 then

1181: then
1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1183: end if;
1184:
1185: if EC_DEBUG.G_debug_level >= 2 then
1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1187: end if;
1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN

Line 1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1182: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1183: end if;
1184:
1185: if EC_DEBUG.G_debug_level >= 2 then
1186: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1187: end if;
1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1200: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1196: p_return_status := FND_API.G_RET_STS_ERROR;
1197: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1198: p_data => p_msg_data);
1199: WHEN OTHERS THEN
1200: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: ROLLBACK TO populate_plsql_tbl_PVT;
1203: p_return_status := FND_API.G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1197: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1198: p_data => p_msg_data);
1199: WHEN OTHERS THEN
1200: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: ROLLBACK TO populate_plsql_tbl_PVT;
1203: p_return_status := FND_API.G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1205: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

Line 1272: if EC_DEBUG.G_debug_level >= 2 then

1268: b_xref_data_found BOOLEAN;
1269:
1270: BEGIN
1271:
1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1269:
1270: BEGIN
1271:
1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

1270: BEGIN
1271:
1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

1271:
1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1279: end if;

Line 1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

1272: if EC_DEBUG.G_debug_level >= 2 then
1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1279: end if;
1280: -- Standard Start of API savepoint

Line 1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

1273: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1279: end if;
1280: -- Standard Start of API savepoint
1281: SAVEPOINT populate_plsql_tbl_PVT;

Line 1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

1274: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1275: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1276: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1277: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1278: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1279: end if;
1280: -- Standard Start of API savepoint
1281: SAVEPOINT populate_plsql_tbl_PVT;
1282:

Line 1415: IF EC_DEBUG.G_debug_level = 3 then

1411: END IF;
1412: END LOOP;
1413: END IF;
1414:
1415: IF EC_DEBUG.G_debug_level = 3 then
1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);

Line 1416: EC_DEBUG.PL(3, 'key1 :', key1);

1412: END LOOP;
1413: END IF;
1414:
1415: IF EC_DEBUG.G_debug_level = 3 then
1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);
1420: EC_DEBUG.PL(3, 'key5 :', key5);

Line 1417: EC_DEBUG.PL(3, 'key2 :', key2);

1413: END IF;
1414:
1415: IF EC_DEBUG.G_debug_level = 3 then
1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);
1420: EC_DEBUG.PL(3, 'key5 :', key5);
1421: END IF;

Line 1418: EC_DEBUG.PL(3, 'key3 :', key3);

1414:
1415: IF EC_DEBUG.G_debug_level = 3 then
1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);
1420: EC_DEBUG.PL(3, 'key5 :', key5);
1421: END IF;
1422: -- Now we know the int_value, the actual value of the key1-5,

Line 1419: EC_DEBUG.PL(3, 'key4 :', key4);

1415: IF EC_DEBUG.G_debug_level = 3 then
1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);
1420: EC_DEBUG.PL(3, 'key5 :', key5);
1421: END IF;
1422: -- Now we know the int_value, the actual value of the key1-5,
1423: -- so we just need to call int_2_ext APIs to get the

Line 1420: EC_DEBUG.PL(3, 'key5 :', key5);

1416: EC_DEBUG.PL(3, 'key1 :', key1);
1417: EC_DEBUG.PL(3, 'key2 :', key2);
1418: EC_DEBUG.PL(3, 'key3 :', key3);
1419: EC_DEBUG.PL(3, 'key4 :', key4);
1420: EC_DEBUG.PL(3, 'key5 :', key5);
1421: END IF;
1422: -- Now we know the int_value, the actual value of the key1-5,
1423: -- so we just need to call int_2_ext APIs to get the
1424: -- the ext1-5 value

Line 1463: if EC_DEBUG.G_debug_level = 3 then

1459: -- ******************************
1460:
1461: IF ext1 is NOT NULL
1462: THEN
1463: if EC_DEBUG.G_debug_level = 3 then
1464: EC_DEBUG.PL(3, 'ext1 :', ext1);
1465: end if;
1466: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1467: (p_level => p_level,

Line 1464: EC_DEBUG.PL(3, 'ext1 :', ext1);

1460:
1461: IF ext1 is NOT NULL
1462: THEN
1463: if EC_DEBUG.G_debug_level = 3 then
1464: EC_DEBUG.PL(3, 'ext1 :', ext1);
1465: end if;
1466: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1467: (p_level => p_level,
1468: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1479: if EC_DEBUG.G_debug_level = 3 then

1475: END IF;
1476:
1477: IF ext2 is NOT NULL
1478: THEN
1479: if EC_DEBUG.G_debug_level = 3 then
1480: EC_DEBUG.PL(3, 'ext2 :', ext2);
1481: end if;
1482: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1483: (p_level => p_level,

Line 1480: EC_DEBUG.PL(3, 'ext2 :', ext2);

1476:
1477: IF ext2 is NOT NULL
1478: THEN
1479: if EC_DEBUG.G_debug_level = 3 then
1480: EC_DEBUG.PL(3, 'ext2 :', ext2);
1481: end if;
1482: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1483: (p_level => p_level,
1484: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1495: if EC_DEBUG.G_debug_level = 3 then

1491: END IF;
1492:
1493: IF ext3 is NOT NULL
1494: THEN
1495: if EC_DEBUG.G_debug_level = 3 then
1496: EC_DEBUG.PL(3, 'ext3 :', ext3);
1497: end if;
1498: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1499: (p_level => p_level,

Line 1496: EC_DEBUG.PL(3, 'ext3 :', ext3);

1492:
1493: IF ext3 is NOT NULL
1494: THEN
1495: if EC_DEBUG.G_debug_level = 3 then
1496: EC_DEBUG.PL(3, 'ext3 :', ext3);
1497: end if;
1498: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1499: (p_level => p_level,
1500: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1511: if EC_DEBUG.G_debug_level = 3 then

1507: END IF;
1508:
1509: IF ext4 is NOT NULL
1510: THEN
1511: if EC_DEBUG.G_debug_level = 3 then
1512: EC_DEBUG.PL(3, 'ext4 :', ext4);
1513: end if;
1514: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1515: (p_level => p_level,

Line 1512: EC_DEBUG.PL(3, 'ext4 :', ext4);

1508:
1509: IF ext4 is NOT NULL
1510: THEN
1511: if EC_DEBUG.G_debug_level = 3 then
1512: EC_DEBUG.PL(3, 'ext4 :', ext4);
1513: end if;
1514: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1515: (p_level => p_level,
1516: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1527: if EC_DEBUG.G_debug_level = 3 then

1523: END IF;
1524:
1525: IF ext5 is NOT NULL
1526: THEN
1527: if EC_DEBUG.G_debug_level = 3 then
1528: EC_DEBUG.PL(3, 'ext5 :', ext5);
1529: end if;
1530: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1531: (p_level => p_level,

Line 1528: EC_DEBUG.PL(3, 'ext5 :', ext5);

1524:
1525: IF ext5 is NOT NULL
1526: THEN
1527: if EC_DEBUG.G_debug_level = 3 then
1528: EC_DEBUG.PL(3, 'ext5 :', ext5);
1529: end if;
1530: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
1531: (p_level => p_level,
1532: p_conversion_group => p_tbl(i).conversion_group_id,

Line 1578: if EC_DEBUG.G_debug_level >= 2 then

1574: then
1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1576: end if;
1577:
1578: if EC_DEBUG.G_debug_level >= 2 then
1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1580: end if;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN

Line 1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');

1575: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
1576: end if;
1577:
1578: if EC_DEBUG.G_debug_level >= 2 then
1579: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_extval');
1580: end if;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1593: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1589: p_return_status := FND_API.G_RET_STS_ERROR;
1590: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1591: p_data => p_msg_data);
1592: WHEN OTHERS THEN
1593: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1595: ROLLBACK TO populate_plsql_tbl_PVT;
1596: p_return_status := FND_API.G_RET_STS_ERROR;
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1590: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1591: p_data => p_msg_data);
1592: WHEN OTHERS THEN
1593: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1595: ROLLBACK TO populate_plsql_tbl_PVT;
1596: p_return_status := FND_API.G_RET_STS_ERROR;
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

Line 1668: if EC_DEBUG.G_debug_level >= 2 then

1664: j INTEGER := 1;
1665: k INTEGER;
1666:
1667: BEGIN
1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

1665: k INTEGER;
1666:
1667: BEGIN
1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

1666:
1667: BEGIN
1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

1667: BEGIN
1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1675: end if;

Line 1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

1668: if EC_DEBUG.G_debug_level >= 2 then
1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1675: end if;
1676: -- Standard Start of API savepoint

Line 1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

1669: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1675: end if;
1676: -- Standard Start of API savepoint
1677: SAVEPOINT populate_plsql_tbl_PVT;

Line 1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

1670: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
1671: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
1672: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
1673: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
1674: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
1675: end if;
1676: -- Standard Start of API savepoint
1677: SAVEPOINT populate_plsql_tbl_PVT;
1678:

Line 1718: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1714: '- Apps col= ' || p_apps_tbl(j).base_column_name ||
1715: '- val= '|| p_apps_tbl(j).value);
1716: EXCEPTION
1717: WHEN OTHERS THEN
1718: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1719: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1720: END;
1721: */
1722:

Line 1719: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1715: '- val= '|| p_apps_tbl(j).value);
1716: EXCEPTION
1717: WHEN OTHERS THEN
1718: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1719: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1720: END;
1721: */
1722:
1723: -- *******************************************************

Line 1750: if EC_DEBUG.G_debug_level >= 3 then

1746: p_Pos => l_int_data_loc_pos);
1747:
1748: IF b_xref_data_found THEN
1749: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
1750: if EC_DEBUG.G_debug_level >= 3 then
1751: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
1752: end if;
1753: END IF;
1754:

Line 1751: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);

1747:
1748: IF b_xref_data_found THEN
1749: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
1750: if EC_DEBUG.G_debug_level >= 3 then
1751: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
1752: end if;
1753: END IF;
1754:
1755: -- 2

Line 1764: if EC_DEBUG.G_debug_level >= 3 then

1760: p_Pos => l_int_data_loc_pos);
1761:
1762: IF b_xref_data_found THEN
1763: c_ext_value2 := p_apps_tbl(l_int_data_loc_pos).value;
1764: if EC_DEBUG.G_debug_level >= 3 then
1765: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
1766: end if;
1767: END IF;
1768:

Line 1765: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);

1761:
1762: IF b_xref_data_found THEN
1763: c_ext_value2 := p_apps_tbl(l_int_data_loc_pos).value;
1764: if EC_DEBUG.G_debug_level >= 3 then
1765: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
1766: end if;
1767: END IF;
1768:
1769: -- 3

Line 1778: if EC_DEBUG.G_debug_level >= 3 then

1774: p_Pos => l_int_data_loc_pos);
1775:
1776: IF b_xref_data_found THEN
1777: c_ext_value3 := p_apps_tbl(l_int_data_loc_pos).value;
1778: if EC_DEBUG.G_debug_level >= 3 then
1779: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
1780: end if;
1781: END IF;
1782:

Line 1779: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);

1775:
1776: IF b_xref_data_found THEN
1777: c_ext_value3 := p_apps_tbl(l_int_data_loc_pos).value;
1778: if EC_DEBUG.G_debug_level >= 3 then
1779: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
1780: end if;
1781: END IF;
1782:
1783: -- 4

Line 1792: if EC_DEBUG.G_debug_level >= 3 then

1788: p_Pos => l_int_data_loc_pos);
1789:
1790: IF b_xref_data_found THEN
1791: c_ext_value4 := p_apps_tbl(l_int_data_loc_pos).value;
1792: if EC_DEBUG.G_debug_level >= 3 then
1793: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
1794: end if;
1795: END IF;
1796:

Line 1793: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);

1789:
1790: IF b_xref_data_found THEN
1791: c_ext_value4 := p_apps_tbl(l_int_data_loc_pos).value;
1792: if EC_DEBUG.G_debug_level >= 3 then
1793: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
1794: end if;
1795: END IF;
1796:
1797: -- 5

Line 1806: if EC_DEBUG.G_debug_level >= 3 then

1802: p_Pos => l_int_data_loc_pos);
1803:
1804: IF b_xref_data_found THEN
1805: c_ext_value5 := p_apps_tbl(l_int_data_loc_pos).value;
1806: if EC_DEBUG.G_debug_level >= 3 then
1807: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
1808: end if;
1809: END IF;
1810:

Line 1807: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);

1803:
1804: IF b_xref_data_found THEN
1805: c_ext_value5 := p_apps_tbl(l_int_data_loc_pos).value;
1806: if EC_DEBUG.G_debug_level >= 3 then
1807: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
1808: end if;
1809: END IF;
1810:
1811: -- ***************************************

Line 1845: if EC_DEBUG.G_debug_level >= 3 then

1841: FOR k IN 1..p_key_tbl.count LOOP
1842: IF p_apps_tbl(j).xref_key1_source_column =
1843: p_key_tbl(k).interface_column_name THEN
1844: key1 := p_key_tbl(k).value;
1845: if EC_DEBUG.G_debug_level >= 3 then
1846: EC_DEBUG.PL(3, 'key1 :', key1);
1847: end if;
1848: EXIT;
1849: END IF;

Line 1846: EC_DEBUG.PL(3, 'key1 :', key1);

1842: IF p_apps_tbl(j).xref_key1_source_column =
1843: p_key_tbl(k).interface_column_name THEN
1844: key1 := p_key_tbl(k).value;
1845: if EC_DEBUG.G_debug_level >= 3 then
1846: EC_DEBUG.PL(3, 'key1 :', key1);
1847: end if;
1848: EXIT;
1849: END IF;
1850: END LOOP;

Line 1861: if EC_DEBUG.G_debug_level >= 3 then

1857: FOR k IN 1..p_key_tbl.count LOOP
1858: IF p_apps_tbl(j).xref_key2_source_column =
1859: p_key_tbl(k).interface_column_name THEN
1860: key2 := p_key_tbl(k).value;
1861: if EC_DEBUG.G_debug_level >= 3 then
1862: EC_DEBUG.PL(3, 'key2 :', key2);
1863: end if;
1864: EXIT;
1865: END IF;

Line 1862: EC_DEBUG.PL(3, 'key2 :', key2);

1858: IF p_apps_tbl(j).xref_key2_source_column =
1859: p_key_tbl(k).interface_column_name THEN
1860: key2 := p_key_tbl(k).value;
1861: if EC_DEBUG.G_debug_level >= 3 then
1862: EC_DEBUG.PL(3, 'key2 :', key2);
1863: end if;
1864: EXIT;
1865: END IF;
1866: END LOOP;

Line 1876: if EC_DEBUG.G_debug_level >= 3 then

1872: FOR k IN 1..p_key_tbl.count LOOP
1873: IF p_apps_tbl(j).xref_key3_source_column =
1874: p_key_tbl(k).interface_column_name THEN
1875: key3 := p_key_tbl(k).value;
1876: if EC_DEBUG.G_debug_level >= 3 then
1877: EC_DEBUG.PL(3, 'key3 :', key3);
1878: end if;
1879: EXIT;
1880: END IF;

Line 1877: EC_DEBUG.PL(3, 'key3 :', key3);

1873: IF p_apps_tbl(j).xref_key3_source_column =
1874: p_key_tbl(k).interface_column_name THEN
1875: key3 := p_key_tbl(k).value;
1876: if EC_DEBUG.G_debug_level >= 3 then
1877: EC_DEBUG.PL(3, 'key3 :', key3);
1878: end if;
1879: EXIT;
1880: END IF;
1881: END LOOP;

Line 1891: if EC_DEBUG.G_debug_level >= 3 then

1887: FOR k IN 1..p_key_tbl.count LOOP
1888: IF p_apps_tbl(j).xref_key4_source_column =
1889: p_key_tbl(k).interface_column_name THEN
1890: key4 := p_key_tbl(k).value;
1891: if EC_DEBUG.G_debug_level >= 3 then
1892: EC_DEBUG.PL(3, 'key4 :', key4);
1893: end if;
1894: EXIT;
1895: END IF;

Line 1892: EC_DEBUG.PL(3, 'key4 :', key4);

1888: IF p_apps_tbl(j).xref_key4_source_column =
1889: p_key_tbl(k).interface_column_name THEN
1890: key4 := p_key_tbl(k).value;
1891: if EC_DEBUG.G_debug_level >= 3 then
1892: EC_DEBUG.PL(3, 'key4 :', key4);
1893: end if;
1894: EXIT;
1895: END IF;
1896: END LOOP;

Line 1906: if EC_DEBUG.G_debug_level >= 3 then

1902: FOR k IN 1..p_key_tbl.count LOOP
1903: IF p_apps_tbl(j).xref_key5_source_column =
1904: p_key_tbl(k).interface_column_name THEN
1905: key5 := p_key_tbl(k).value;
1906: if EC_DEBUG.G_debug_level >= 3 then
1907: EC_DEBUG.PL(3, 'key5 :', key5);
1908: end if;
1909: EXIT;
1910: END IF;

Line 1907: EC_DEBUG.PL(3, 'key5 :', key5);

1903: IF p_apps_tbl(j).xref_key5_source_column =
1904: p_key_tbl(k).interface_column_name THEN
1905: key5 := p_key_tbl(k).value;
1906: if EC_DEBUG.G_debug_level >= 3 then
1907: EC_DEBUG.PL(3, 'key5 :', key5);
1908: end if;
1909: EXIT;
1910: END IF;
1911: END LOOP;

Line 1955: if EC_DEBUG.G_debug_level >= 3 then

1951: p_Ext_val5 => c_ext_value5,
1952: p_Int_val => int_val);
1953:
1954: p_apps_tbl(j).value := int_val;
1955: if EC_DEBUG.G_debug_level >= 3 then
1956: EC_DEBUG.PL(3, 'int_val :', int_val);
1957: end if;
1958: key1 := NULL;
1959: key2 := NULL;

Line 1956: EC_DEBUG.PL(3, 'int_val :', int_val);

1952: p_Int_val => int_val);
1953:
1954: p_apps_tbl(j).value := int_val;
1955: if EC_DEBUG.G_debug_level >= 3 then
1956: EC_DEBUG.PL(3, 'int_val :', int_val);
1957: end if;
1958: key1 := NULL;
1959: key2 := NULL;
1960: key3 := NULL;

Line 1989: if EC_DEBUG.G_debug_level >= 3 then

1985:
1986: IF b_xref_data_found THEN
1987: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
1988: if (c_ext_value1 is not null) then
1989: if EC_DEBUG.G_debug_level >= 3 then
1990: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
1991: end if;
1992: p_apps_tbl(j).value := c_ext_value1;
1993: end if;

Line 1990: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);

1986: IF b_xref_data_found THEN
1987: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
1988: if (c_ext_value1 is not null) then
1989: if EC_DEBUG.G_debug_level >= 3 then
1990: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
1991: end if;
1992: p_apps_tbl(j).value := c_ext_value1;
1993: end if;
1994: END IF;

Line 2018: if EC_DEBUG.G_debug_level >= 2 then

2014: then
2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2016: end if;
2017:
2018: if EC_DEBUG.G_debug_level >= 2 then
2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2020: end if;
2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN

Line 2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2015: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2016: end if;
2017:
2018: if EC_DEBUG.G_debug_level >= 2 then
2019: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2020: end if;
2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2033: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

2029: p_return_status := FND_API.G_RET_STS_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2031: p_data => p_msg_data);
2032: WHEN OTHERS THEN
2033: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2035: ROLLBACK TO populate_plsql_tbl_PVT;
2036: p_return_status := FND_API.G_RET_STS_ERROR;
2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

2030: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2031: p_data => p_msg_data);
2032: WHEN OTHERS THEN
2033: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2035: ROLLBACK TO populate_plsql_tbl_PVT;
2036: p_return_status := FND_API.G_RET_STS_ERROR;
2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2038: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

Line 2109: if EC_DEBUG.G_debug_level >= 2 then

2105:
2106: k INTEGER;
2107:
2108: BEGIN
2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2106: k INTEGER;
2107:
2108: BEGIN
2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

Line 2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);

2107:
2108: BEGIN
2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

Line 2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);

2108: BEGIN
2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
2116: EC_DEBUG.PL(3, 'p_level',p_level);

Line 2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

2109: if EC_DEBUG.G_debug_level >= 2 then
2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
2116: EC_DEBUG.PL(3, 'p_level',p_level);
2117: end if;

Line 2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);

2110: EC_DEBUG.PUSH('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
2116: EC_DEBUG.PL(3, 'p_level',p_level);
2117: end if;
2118: -- Standard Start of API savepoint

Line 2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);

2111: EC_DEBUG.PL(3, 'API version : ',p_api_version_number);
2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
2116: EC_DEBUG.PL(3, 'p_level',p_level);
2117: end if;
2118: -- Standard Start of API savepoint
2119: SAVEPOINT populate_plsql_tbl_PVT;

Line 2116: EC_DEBUG.PL(3, 'p_level',p_level);

2112: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
2113: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);
2114: EC_DEBUG.PL(3, 'p_commit: ',p_commit);
2115: EC_DEBUG.PL(3, 'p_validation_level: ',p_validation_level);
2116: EC_DEBUG.PL(3, 'p_level',p_level);
2117: end if;
2118: -- Standard Start of API savepoint
2119: SAVEPOINT populate_plsql_tbl_PVT;
2120:

Line 2170: if EC_DEBUG.G_debug_level >= 3 then

2166: if (c_ext_value1 is not null) then
2167: p_apps_tbl(j).value := c_ext_value1;
2168: end if;
2169: END IF;
2170: if EC_DEBUG.G_debug_level >= 3 then
2171: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2172: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2173: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2174: end if;

Line 2171: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);

2167: p_apps_tbl(j).value := c_ext_value1;
2168: end if;
2169: END IF;
2170: if EC_DEBUG.G_debug_level >= 3 then
2171: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2172: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2173: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2174: end if;
2175: END IF;

Line 2172: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);

2168: end if;
2169: END IF;
2170: if EC_DEBUG.G_debug_level >= 3 then
2171: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2172: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2173: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2174: end if;
2175: END IF;
2176:

Line 2173: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);

2169: END IF;
2170: if EC_DEBUG.G_debug_level >= 3 then
2171: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2172: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2173: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2174: end if;
2175: END IF;
2176:
2177: -- *******************************************************

Line 2188: if EC_DEBUG.G_debug_level >= 3 then

2184:
2185: IF p_apps_tbl(j).conversion_sequence = 0 AND
2186: p_apps_tbl(j).value IS NULL THEN
2187:
2188: if EC_DEBUG.G_debug_level >= 3 then
2189: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2190: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2191: end if;
2192: -- *******************************************************

Line 2189: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);

2185: IF p_apps_tbl(j).conversion_sequence = 0 AND
2186: p_apps_tbl(j).value IS NULL THEN
2187:
2188: if EC_DEBUG.G_debug_level >= 3 then
2189: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2190: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2191: end if;
2192: -- *******************************************************
2193: -- These are data that need xref.

Line 2190: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);

2186: p_apps_tbl(j).value IS NULL THEN
2187:
2188: if EC_DEBUG.G_debug_level >= 3 then
2189: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2190: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2191: end if;
2192: -- *******************************************************
2193: -- These are data that need xref.
2194: -- First find all external values for xref.

Line 2269: if EC_DEBUG.G_debug_level >= 3 then

2265: IF b_xref_data_found THEN
2266: c_ext_value5 := p_apps_tbl(l_int_data_loc_pos).value;
2267: END IF;
2268:
2269: if EC_DEBUG.G_debug_level >= 3 then
2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);

Line 2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);

2266: c_ext_value5 := p_apps_tbl(l_int_data_loc_pos).value;
2267: END IF;
2268:
2269: if EC_DEBUG.G_debug_level >= 3 then
2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);

Line 2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);

2267: END IF;
2268:
2269: if EC_DEBUG.G_debug_level >= 3 then
2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
2275: end if;

Line 2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);

2268:
2269: if EC_DEBUG.G_debug_level >= 3 then
2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
2275: end if;
2276: -- ***************************************

Line 2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);

2269: if EC_DEBUG.G_debug_level >= 3 then
2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
2275: end if;
2276: -- ***************************************
2277: --

Line 2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);

2270: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2271: EC_DEBUG.PL(3, 'c_ext_value2 :', c_ext_value2);
2272: EC_DEBUG.PL(3, 'c_ext_value3 :', c_ext_value3);
2273: EC_DEBUG.PL(3, 'c_ext_value4 :', c_ext_value4);
2274: EC_DEBUG.PL(3, 'c_ext_value5 :', c_ext_value5);
2275: end if;
2276: -- ***************************************
2277: --
2278: -- Find out what is the xref catergory code

Line 2303: if EC_DEBUG.G_debug_level >= 3 then

2299: ckey4_used_column, ckey5_used_column,
2300: cxref_category_code
2301: FROM ece_xref_categories
2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
2303: if EC_DEBUG.G_debug_level >= 3 then
2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);
2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);
2306: end if;
2307:

Line 2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);

2300: cxref_category_code
2301: FROM ece_xref_categories
2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
2303: if EC_DEBUG.G_debug_level >= 3 then
2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);
2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);
2306: end if;
2307:
2308: -- Bug 2828072

Line 2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);

2301: FROM ece_xref_categories
2302: WHERE ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;
2303: if EC_DEBUG.G_debug_level >= 3 then
2304: ec_debug.pl(3,'xref_category_id',p_apps_tbl(j).xref_category_id);
2305: ec_debug.pl(3,'cxref_category_code',cxref_category_code);
2306: end if;
2307:
2308: -- Bug 2828072
2309: IF ckey1_used_flag = 'Y' AND

Line 2399: IF EC_DEBUG.G_debug_level = 3 THEN

2395: END IF;
2396: END LOOP;
2397: END IF;
2398:
2399: IF EC_DEBUG.G_debug_level = 3 THEN
2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);

Line 2400: EC_DEBUG.PL(3, 'key1 :', key1);

2396: END LOOP;
2397: END IF;
2398:
2399: IF EC_DEBUG.G_debug_level = 3 THEN
2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);
2404: EC_DEBUG.PL(3, 'key5 :', key5);

Line 2401: EC_DEBUG.PL(3, 'key2 :', key2);

2397: END IF;
2398:
2399: IF EC_DEBUG.G_debug_level = 3 THEN
2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);
2404: EC_DEBUG.PL(3, 'key5 :', key5);
2405: END IF;

Line 2402: EC_DEBUG.PL(3, 'key3 :', key3);

2398:
2399: IF EC_DEBUG.G_debug_level = 3 THEN
2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);
2404: EC_DEBUG.PL(3, 'key5 :', key5);
2405: END IF;
2406:

Line 2403: EC_DEBUG.PL(3, 'key4 :', key4);

2399: IF EC_DEBUG.G_debug_level = 3 THEN
2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);
2404: EC_DEBUG.PL(3, 'key5 :', key5);
2405: END IF;
2406:
2407: -- Now we know the int_value, the actual value of the key1-5,

Line 2404: EC_DEBUG.PL(3, 'key5 :', key5);

2400: EC_DEBUG.PL(3, 'key1 :', key1);
2401: EC_DEBUG.PL(3, 'key2 :', key2);
2402: EC_DEBUG.PL(3, 'key3 :', key3);
2403: EC_DEBUG.PL(3, 'key4 :', key4);
2404: EC_DEBUG.PL(3, 'key5 :', key5);
2405: END IF;
2406:
2407: -- Now we know the int_value, the actual value of the key1-5,
2408: -- so we just need to call int_2_ext APIs to get the

Line 2429: if EC_DEBUG.G_debug_level >= 3 then

2425: p_Ext_val5 => c_ext_value5,
2426: p_Int_val => int_val);
2427:
2428: p_apps_tbl(j).value := int_val;
2429: if EC_DEBUG.G_debug_level >= 3 then
2430: EC_DEBUG.PL(3, 'Internal value after code conversion:', int_val);
2431: end if;
2432: key1 := NULL;
2433: key2 := NULL;

Line 2430: EC_DEBUG.PL(3, 'Internal value after code conversion:', int_val);

2426: p_Int_val => int_val);
2427:
2428: p_apps_tbl(j).value := int_val;
2429: if EC_DEBUG.G_debug_level >= 3 then
2430: EC_DEBUG.PL(3, 'Internal value after code conversion:', int_val);
2431: end if;
2432: key1 := NULL;
2433: key2 := NULL;
2434: key3 := NULL;

Line 2452: if EC_DEBUG.G_debug_level >= 3 then

2448: /* Bug 2708573
2449: ELSIF (p_apps_tbl(j).xref_category_id is NULL AND
2450: p_apps_tbl(j).conversion_sequence = 0 AND
2451: p_apps_tbl(j).value is NULL) THEN
2452: if EC_DEBUG.G_debug_level >= 3 then
2453: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2454: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2455: end if;
2456: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq

Line 2453: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);

2449: ELSIF (p_apps_tbl(j).xref_category_id is NULL AND
2450: p_apps_tbl(j).conversion_sequence = 0 AND
2451: p_apps_tbl(j).value is NULL) THEN
2452: if EC_DEBUG.G_debug_level >= 3 then
2453: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2454: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2455: end if;
2456: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2457: (

Line 2454: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);

2450: p_apps_tbl(j).conversion_sequence = 0 AND
2451: p_apps_tbl(j).value is NULL) THEN
2452: if EC_DEBUG.G_debug_level >= 3 then
2453: ec_debug.pl(3,'Interface Column Name ',p_apps_tbl(j).Interface_Column_Name);
2454: ec_debug.pl(3,'Internal Value ',p_apps_tbl(j).value);
2455: end if;
2456: b_xref_data_found := ece_flatfile_pvt.match_xref_conv_seq
2457: (
2458: p_level => p_level,

Line 2467: if EC_DEBUG.G_debug_level >= 3 then

2463:
2464: IF b_xref_data_found THEN
2465: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
2466: if (c_ext_value1 is not null) then
2467: if EC_DEBUG.G_debug_level >= 3 then
2468: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2469: end if;
2470: p_apps_tbl(j).value := c_ext_value1;
2471: end if;

Line 2468: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);

2464: IF b_xref_data_found THEN
2465: c_ext_value1 := p_apps_tbl(l_int_data_loc_pos).value;
2466: if (c_ext_value1 is not null) then
2467: if EC_DEBUG.G_debug_level >= 3 then
2468: EC_DEBUG.PL(3, 'c_ext_value1 :', c_ext_value1);
2469: end if;
2470: p_apps_tbl(j).value := c_ext_value1;
2471: end if;
2472: END IF;

Line 2496: if EC_DEBUG.G_debug_level >= 2 then

2492: then
2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2494: end if;
2495:
2496: if EC_DEBUG.G_debug_level >= 2 then
2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2498: end if;
2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN

Line 2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');

2493: p_return_status := EC_Code_Conversion_PVT.G_XREF_NOT_FOUND;
2494: end if;
2495:
2496: if EC_DEBUG.G_debug_level >= 2 then
2497: EC_DEBUG.POP('EC_Code_Conversion_PVT.populate_plsql_tbl_with_intval');
2498: end if;
2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN
2501: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2511: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

2507: p_return_status := FND_API.G_RET_STS_ERROR;
2508: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2509: p_data => p_msg_data);
2510: WHEN OTHERS THEN
2511: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2513: ROLLBACK TO populate_plsql_tbl_PVT;
2514: p_return_status := FND_API.G_RET_STS_ERROR;
2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

2508: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2509: p_data => p_msg_data);
2510: WHEN OTHERS THEN
2511: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2513: ROLLBACK TO populate_plsql_tbl_PVT;
2514: p_return_status := FND_API.G_RET_STS_ERROR;
2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2516: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);