eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_CODE_CONVERSION_PVT dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5:
6:
7: PROCEDURE Convert_from_ext_to_int
8: (p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_return_status OUT NOCOPY VARCHAR2,

Line 10: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

6:
7: PROCEDURE Convert_from_ext_to_int
8: (p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,

Line 11: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7: PROCEDURE Convert_from_ext_to_int
8: (p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,
15: p_msg_data OUT NOCOPY VARCHAR2,

Line 12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8: (p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_return_status OUT NOCOPY VARCHAR2,
14: p_msg_count OUT NOCOPY NUMBER,
15: p_msg_data OUT NOCOPY VARCHAR2,
16: p_Category IN VARCHAR2,

Line 54: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

50: XREF_KEY5 = p_Key5 AND
51: XREF_CATEGORY_CODE = p_Category AND
52: XREF_EXT_VALUE1 = p_Ext_val1 AND
53: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
54: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
55: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
56: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
58:

Line 55: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

51: XREF_CATEGORY_CODE = p_Category AND
52: XREF_EXT_VALUE1 = p_Ext_val1 AND
53: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
54: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
55: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
56: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
58:
59: CURSOR match_4 IS

Line 56: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

52: XREF_EXT_VALUE1 = p_Ext_val1 AND
53: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
54: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
55: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
56: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
58:
59: CURSOR match_4 IS
60: SELECT XREF_INT_VALUE

Line 57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

53: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
54: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
55: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
56: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
57: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
58:
59: CURSOR match_4 IS
60: SELECT XREF_INT_VALUE
61: FROM ECE_XREF_DATA

Line 74: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

70: XREF_KEY4 = p_Key4 AND
71: XREF_CATEGORY_CODE = p_Category AND
72: XREF_EXT_VALUE1 = p_Ext_val1 AND
73: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
74: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
75: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
76: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
78:

Line 75: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

71: XREF_CATEGORY_CODE = p_Category AND
72: XREF_EXT_VALUE1 = p_Ext_val1 AND
73: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
74: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
75: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
76: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
78:
79: CURSOR match_3 IS

Line 76: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

72: XREF_EXT_VALUE1 = p_Ext_val1 AND
73: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
74: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
75: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
76: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
78:
79: CURSOR match_3 IS
80: SELECT XREF_INT_VALUE

Line 77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

73: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
74: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
75: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
76: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
77: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
78:
79: CURSOR match_3 IS
80: SELECT XREF_INT_VALUE
81: FROM ECE_XREF_DATA

Line 93: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

89: XREF_KEY3 = p_Key3 AND
90: XREF_CATEGORY_CODE = p_Category AND
91: XREF_EXT_VALUE1 = p_Ext_val1 AND
92: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
93: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
94: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
95: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
97:

Line 94: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

90: XREF_CATEGORY_CODE = p_Category AND
91: XREF_EXT_VALUE1 = p_Ext_val1 AND
92: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
93: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
94: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
95: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
97:
98: CURSOR match_2 IS

Line 95: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

91: XREF_EXT_VALUE1 = p_Ext_val1 AND
92: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
93: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
94: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
95: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
97:
98: CURSOR match_2 IS
99: SELECT XREF_INT_VALUE

Line 96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

92: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
93: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
94: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
95: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
96: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
97:
98: CURSOR match_2 IS
99: SELECT XREF_INT_VALUE
100: FROM ECE_XREF_DATA

Line 111: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

107: XREF_KEY2 = p_Key2 AND
108: XREF_CATEGORY_CODE = p_Category AND
109: XREF_EXT_VALUE1 = p_Ext_val1 AND
110: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
111: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
112: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
113: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
115:

Line 112: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

108: XREF_CATEGORY_CODE = p_Category AND
109: XREF_EXT_VALUE1 = p_Ext_val1 AND
110: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
111: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
112: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
113: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
115:
116: CURSOR match_1 IS

Line 113: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

109: XREF_EXT_VALUE1 = p_Ext_val1 AND
110: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
111: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
112: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
113: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
115:
116: CURSOR match_1 IS
117: SELECT XREF_INT_VALUE

Line 114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

110: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
111: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
112: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
113: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
114: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
115:
116: CURSOR match_1 IS
117: SELECT XREF_INT_VALUE
118: FROM ECE_XREF_DATA

Line 128: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

124: XREF_KEY1 = p_Key1 AND
125: XREF_CATEGORY_CODE = p_Category AND
126: XREF_EXT_VALUE1 = p_Ext_val1 AND
127: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
128: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
129: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
130: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
132:

Line 129: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

125: XREF_CATEGORY_CODE = p_Category AND
126: XREF_EXT_VALUE1 = p_Ext_val1 AND
127: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
128: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
129: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
130: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
132:
133: CURSOR match_global IS

Line 130: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

126: XREF_EXT_VALUE1 = p_Ext_val1 AND
127: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
128: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
129: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
130: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
132:
133: CURSOR match_global IS
134: SELECT XREF_INT_VALUE

Line 131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

127: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
128: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
129: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
130: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
131: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);
132:
133: CURSOR match_global IS
134: SELECT XREF_INT_VALUE
135: FROM ECE_XREF_DATA

Line 144: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND

140: XREF_KEY5 IS NULL AND
141: XREF_CATEGORY_CODE = p_Category AND
142: XREF_EXT_VALUE1 = p_Ext_val1 AND
143: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
144: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
145: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
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:

Line 145: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND

141: XREF_CATEGORY_CODE = p_Category AND
142: XREF_EXT_VALUE1 = p_Ext_val1 AND
143: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
144: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
145: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
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

Line 146: NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND

142: XREF_EXT_VALUE1 = p_Ext_val1 AND
143: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
144: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
145: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
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

Line 147: NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

143: (DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
144: NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
145: NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
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');

Line 173: IF NOT FND_API.Compatible_API_Call

169: -- Standard Start of API savepoint
170: -- SAVEPOINT Convert_from_ext_to_int_PVT;
171:
172: -- Standard call to check for call compatibility.
173: IF NOT FND_API.Compatible_API_Call
174: (l_api_version_number,
175: p_api_version_number,
176: l_api_name, G_PKG_NAME) THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: IF NOT FND_API.Compatible_API_Call
174: (l_api_version_number,
175: p_api_version_number,
176: l_api_name, G_PKG_NAME) THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 181: IF FND_API.to_Boolean(p_init_msg_list) THEN

177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success

Line 186: p_return_status := FND_API.G_RET_STS_SUCCESS;

182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: p_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: -- *******************************************************
189: -- first validate the input key1-5
190: -- The input has to be one of the following

Line 352: IF FND_API.To_Boolean(p_simulate) THEN

348: -- *******************************************************
349: -- Standard check of p_simulate and p_commit parameters
350: -- *******************************************************
351: /*
352: IF FND_API.To_Boolean(p_simulate) THEN
353: ROLLBACK TO Convert_from_ext_to_int_PVT;
354: ELSIF FND_API.To_Boolean(p_commit) THEN
355: COMMIT WORK;
356: END IF;

Line 354: ELSIF FND_API.To_Boolean(p_commit) THEN

350: -- *******************************************************
351: /*
352: IF FND_API.To_Boolean(p_simulate) THEN
353: ROLLBACK TO Convert_from_ext_to_int_PVT;
354: ELSIF FND_API.To_Boolean(p_commit) THEN
355: COMMIT WORK;
356: END IF;
357: */
358: if l_Int_val is null

Line 386: WHEN FND_API.G_EXC_ERROR THEN

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;
388: p_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
390: p_data => p_msg_data);

Line 388: p_return_status := FND_API.G_RET_STS_ERROR;

384: end if;
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
388: p_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
390: p_data => p_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: -- ROLLBACK TO Convert_from_ext_to_int_PVT;

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

387: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
388: p_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
390: p_data => p_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
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);

Line 393: p_return_status := FND_API.G_RET_STS_ERROR;

389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
390: p_data => p_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
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);

Line 400: p_return_status := FND_API.G_RET_STS_ERROR;

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);
403: END IF;
404: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

406: END Convert_from_ext_to_int;
407:
408: PROCEDURE Convert_from_int_to_ext
409: (p_api_version_number IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
414: p_return_status OUT NOCOPY VARCHAR2,

Line 411: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

407:
408: PROCEDURE Convert_from_int_to_ext
409: (p_api_version_number IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
414: p_return_status OUT NOCOPY VARCHAR2,
415: p_msg_count OUT NOCOPY NUMBER,

Line 412: p_commit IN VARCHAR2 := FND_API.G_FALSE,

408: PROCEDURE Convert_from_int_to_ext
409: (p_api_version_number IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
414: p_return_status OUT NOCOPY VARCHAR2,
415: p_msg_count OUT NOCOPY NUMBER,
416: p_msg_data OUT NOCOPY VARCHAR2,

Line 413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

409: (p_api_version_number IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
412: p_commit IN VARCHAR2 := FND_API.G_FALSE,
413: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
414: p_return_status OUT NOCOPY VARCHAR2,
415: p_msg_count OUT NOCOPY NUMBER,
416: p_msg_data OUT NOCOPY VARCHAR2,
417: p_Category IN VARCHAR2,

Line 579: IF NOT FND_API.Compatible_API_Call

575: -- Standard Start of API savepoint
576: -- SAVEPOINT Convert_from_int_to_ext_PVT;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call
580: (l_api_version_number,
581: p_api_version_number,
582: l_api_name,
583: G_PKG_NAME) THEN

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: (l_api_version_number,
581: p_api_version_number,
582: l_api_name,
583: G_PKG_NAME) THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 588: IF FND_API.to_Boolean(p_init_msg_list) THEN

584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588: IF FND_API.to_Boolean(p_init_msg_list) THEN
589: FND_MSG_PUB.initialize;
590: END IF;
591:
592: -- Initialize API return status to success

Line 593: p_return_status := FND_API.G_RET_STS_SUCCESS;

589: FND_MSG_PUB.initialize;
590: END IF;
591:
592: -- Initialize API return status to success
593: p_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- *******************************************************
596: -- first validate the input key1-5
597: -- The input has to be one of the following

Line 807: IF FND_API.To_Boolean(p_simulate) THEN

803: -- *******************************************************
804: -- Standard check of p_simulate and p_commit parameters
805: -- *******************************************************
806: /*
807: IF FND_API.To_Boolean(p_simulate) THEN
808: ROLLBACK TO Convert_from_int_to_ext_PVT;
809: ELSIF FND_API.To_Boolean(p_commit) THEN
810: COMMIT WORK;
811: END IF;

Line 809: ELSIF FND_API.To_Boolean(p_commit) THEN

805: -- *******************************************************
806: /*
807: IF FND_API.To_Boolean(p_simulate) THEN
808: ROLLBACK TO Convert_from_int_to_ext_PVT;
809: ELSIF FND_API.To_Boolean(p_commit) THEN
810: COMMIT WORK;
811: END IF;
812: */
813: -- Standard call to get message count and if count is 1, get message info.

Line 820: WHEN FND_API.G_EXC_ERROR THEN

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;
822: p_return_status := FND_API.G_RET_STS_ERROR;
823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
824: p_data => p_msg_data);

Line 822: p_return_status := FND_API.G_RET_STS_ERROR;

818: end if;
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
822: p_return_status := FND_API.G_RET_STS_ERROR;
823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
824: p_data => p_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: -- ROLLBACK TO Convert_from_int_to_ext_PVT;

Line 825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

821: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
822: p_return_status := FND_API.G_RET_STS_ERROR;
823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
824: p_data => p_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
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);

Line 827: p_return_status := FND_API.G_RET_STS_ERROR;

823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
824: p_data => p_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
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);

Line 834: p_return_status := FND_API.G_RET_STS_ERROR;

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);
837: END IF;
838: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

841: END Convert_from_int_to_ext;
842:
843: PROCEDURE populate_plsql_tbl_with_extval
844: (p_api_version_number IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
847: p_commit IN VARCHAR2 := FND_API.G_FALSE,
848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
849: p_return_status OUT NOCOPY VARCHAR2,

Line 846: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

842:
843: PROCEDURE populate_plsql_tbl_with_extval
844: (p_api_version_number IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
847: p_commit IN VARCHAR2 := FND_API.G_FALSE,
848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
849: p_return_status OUT NOCOPY VARCHAR2,
850: p_msg_count OUT NOCOPY NUMBER,

Line 847: p_commit IN VARCHAR2 := FND_API.G_FALSE,

843: PROCEDURE populate_plsql_tbl_with_extval
844: (p_api_version_number IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
847: p_commit IN VARCHAR2 := FND_API.G_FALSE,
848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
849: p_return_status OUT NOCOPY VARCHAR2,
850: p_msg_count OUT NOCOPY NUMBER,
851: p_msg_data OUT NOCOPY VARCHAR2,

Line 848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

844: (p_api_version_number IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
847: p_commit IN VARCHAR2 := FND_API.G_FALSE,
848: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
849: p_return_status OUT NOCOPY VARCHAR2,
850: p_msg_count OUT NOCOPY NUMBER,
851: p_msg_data OUT NOCOPY VARCHAR2,
852: p_key_tbl IN ece_flatfile_pvt.Interface_tbl_type,

Line 915: IF NOT FND_API.Compatible_API_Call

911: -- Standard Start of API savepoint
912: SAVEPOINT populate_plsql_tbl_PVT;
913:
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call
916: (l_api_version_number,
917: p_api_version_number,
918: l_api_name,
919: G_PKG_NAME) THEN

Line 920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

916: (l_api_version_number,
917: p_api_version_number,
918: l_api_name,
919: G_PKG_NAME) THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE.
924: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 924: IF FND_API.to_Boolean(p_init_msg_list) THEN

920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE.
924: IF FND_API.to_Boolean(p_init_msg_list) THEN
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Initialize API return status to success

Line 929: p_return_status := FND_API.G_RET_STS_SUCCESS;

925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Initialize API return status to success
929: p_return_status := FND_API.G_RET_STS_SUCCESS;
930:
931: -- *******************************************************
932: -- work on each row in the p_tbl pl/sql
933: -- table to fill in the ext1-5 value

Line 1170: IF FND_API.To_Boolean(p_simulate) THEN

1166:
1167: -- *******************************************************
1168: -- Standard check of p_simulate and p_commit parameters
1169: -- *******************************************************
1170: IF FND_API.To_Boolean(p_simulate) THEN
1171: ROLLBACK TO populate_plsql_tbl_PVT;
1172: ELSIF FND_API.To_Boolean(p_commit) THEN
1173: COMMIT WORK;
1174: END IF;

Line 1172: ELSIF FND_API.To_Boolean(p_commit) THEN

1168: -- Standard check of p_simulate and p_commit parameters
1169: -- *******************************************************
1170: IF FND_API.To_Boolean(p_simulate) THEN
1171: ROLLBACK TO populate_plsql_tbl_PVT;
1172: ELSIF FND_API.To_Boolean(p_commit) THEN
1173: COMMIT WORK;
1174: END IF;
1175:
1176: -- Standard call to get message count and if count is 1, get message info.

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

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;
1191: p_return_status := FND_API.G_RET_STS_ERROR;
1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1193: p_data => p_msg_data);

Line 1191: p_return_status := FND_API.G_RET_STS_ERROR;

1187: end if;
1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: ROLLBACK TO populate_plsql_tbl_PVT;
1191: p_return_status := FND_API.G_RET_STS_ERROR;
1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1193: p_data => p_msg_data);
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1190: ROLLBACK TO populate_plsql_tbl_PVT;
1191: p_return_status := FND_API.G_RET_STS_ERROR;
1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1193: p_data => p_msg_data);
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 1196: p_return_status := FND_API.G_RET_STS_ERROR;

1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1193: p_data => p_msg_data);
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 1203: p_return_status := FND_API.G_RET_STS_ERROR;

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);
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1210: END populate_plsql_tbl_with_extval;
1211:
1212: PROCEDURE populate_plsql_tbl_with_extval
1213: (p_api_version_number IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1218: p_return_status OUT NOCOPY VARCHAR2,

Line 1215: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

1211:
1212: PROCEDURE populate_plsql_tbl_with_extval
1213: (p_api_version_number IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_msg_count OUT NOCOPY NUMBER,

Line 1216: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1212: PROCEDURE populate_plsql_tbl_with_extval
1213: (p_api_version_number IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_msg_count OUT NOCOPY NUMBER,
1220: p_msg_data OUT NOCOPY VARCHAR2,

Line 1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1213: (p_api_version_number IN NUMBER,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1218: p_return_status OUT NOCOPY VARCHAR2,
1219: p_msg_count OUT NOCOPY NUMBER,
1220: p_msg_data OUT NOCOPY VARCHAR2,
1221: p_tbl IN OUT NOCOPY ec_utils.mapping_tbl,

Line 1284: IF NOT FND_API.Compatible_API_Call

1280: -- Standard Start of API savepoint
1281: SAVEPOINT populate_plsql_tbl_PVT;
1282:
1283: -- Standard call to check for call compatibility.
1284: IF NOT FND_API.Compatible_API_Call
1285: (l_api_version_number,
1286: p_api_version_number,
1287: l_api_name,
1288: G_PKG_NAME) THEN

Line 1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1285: (l_api_version_number,
1286: p_api_version_number,
1287: l_api_name,
1288: G_PKG_NAME) THEN
1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1293: IF FND_API.to_Boolean(p_init_msg_list) THEN

1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success

Line 1298: p_return_status := FND_API.G_RET_STS_SUCCESS;

1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success
1298: p_return_status := FND_API.G_RET_STS_SUCCESS;
1299:
1300: -- *******************************************************
1301: -- work on each row in the p_tbl pl/sql
1302: -- table to fill in the ext1-5 value

Line 1563: IF FND_API.To_Boolean(p_simulate) THEN

1559:
1560: -- *******************************************************
1561: -- Standard check of p_simulate and p_commit parameters
1562: -- *******************************************************
1563: IF FND_API.To_Boolean(p_simulate) THEN
1564: ROLLBACK TO populate_plsql_tbl_PVT;
1565: ELSIF FND_API.To_Boolean(p_commit) THEN
1566: COMMIT WORK;
1567: END IF;

Line 1565: ELSIF FND_API.To_Boolean(p_commit) THEN

1561: -- Standard check of p_simulate and p_commit parameters
1562: -- *******************************************************
1563: IF FND_API.To_Boolean(p_simulate) THEN
1564: ROLLBACK TO populate_plsql_tbl_PVT;
1565: ELSIF FND_API.To_Boolean(p_commit) THEN
1566: COMMIT WORK;
1567: END IF;
1568:
1569: -- Standard call to get message count and if count is 1, get message info.

Line 1582: WHEN FND_API.G_EXC_ERROR THEN

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;
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1586: p_data => p_msg_data);

Line 1584: p_return_status := FND_API.G_RET_STS_ERROR;

1580: end if;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: ROLLBACK TO populate_plsql_tbl_PVT;
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1586: p_data => p_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: ROLLBACK TO populate_plsql_tbl_PVT;

Line 1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1583: ROLLBACK TO populate_plsql_tbl_PVT;
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1586: p_data => p_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 1589: p_return_status := FND_API.G_RET_STS_ERROR;

1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1586: p_data => p_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 1596: p_return_status := FND_API.G_RET_STS_ERROR;

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);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 1607: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1603: END populate_plsql_tbl_with_extval;
1604:
1605: PROCEDURE populate_plsql_tbl_with_intval
1606: (p_api_version_number IN NUMBER,
1607: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1608: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1611: p_return_status OUT NOCOPY VARCHAR2,

Line 1608: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

1604:
1605: PROCEDURE populate_plsql_tbl_with_intval
1606: (p_api_version_number IN NUMBER,
1607: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1608: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1611: p_return_status OUT NOCOPY VARCHAR2,
1612: p_msg_count OUT NOCOPY NUMBER,

Line 1609: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1605: PROCEDURE populate_plsql_tbl_with_intval
1606: (p_api_version_number IN NUMBER,
1607: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1608: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1611: p_return_status OUT NOCOPY VARCHAR2,
1612: p_msg_count OUT NOCOPY NUMBER,
1613: p_msg_data OUT NOCOPY VARCHAR2,

Line 1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1606: (p_api_version_number IN NUMBER,
1607: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1608: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
1609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1611: p_return_status OUT NOCOPY VARCHAR2,
1612: p_msg_count OUT NOCOPY NUMBER,
1613: p_msg_data OUT NOCOPY VARCHAR2,
1614: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

Line 1680: IF NOT FND_API.Compatible_API_Call

1676: -- Standard Start of API savepoint
1677: SAVEPOINT populate_plsql_tbl_PVT;
1678:
1679: -- Standard call to check for call compatibility.
1680: IF NOT FND_API.Compatible_API_Call
1681: (l_api_version_number,
1682: p_api_version_number,
1683: l_api_name,
1684: G_PKG_NAME) THEN

Line 1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1681: (l_api_version_number,
1682: p_api_version_number,
1683: l_api_name,
1684: G_PKG_NAME) THEN
1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: -- Initialize message list if p_init_msg_list is set to TRUE.
1689: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1689: IF FND_API.to_Boolean(p_init_msg_list) THEN

1685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1686: END IF;
1687:
1688: -- Initialize message list if p_init_msg_list is set to TRUE.
1689: IF FND_API.to_Boolean(p_init_msg_list) THEN
1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: -- Initialize API return status to success

Line 1694: p_return_status := FND_API.G_RET_STS_SUCCESS;

1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: -- Initialize API return status to success
1694: p_return_status := FND_API.G_RET_STS_SUCCESS;
1695:
1696: -- *******************************************************
1697: -- Move data from interface to source PL/SQL table
1698: -- These are data that do not need xref.

Line 2003: IF FND_API.To_Boolean(p_simulate) THEN

1999:
2000: -- *******************************************************
2001: -- Standard check of p_simulate and p_commit parameters
2002: -- *******************************************************
2003: IF FND_API.To_Boolean(p_simulate) THEN
2004: ROLLBACK TO populate_plsql_tbl_PVT;
2005: ELSIF FND_API.To_Boolean(p_commit) THEN
2006: COMMIT WORK;
2007: END IF;

Line 2005: ELSIF FND_API.To_Boolean(p_commit) THEN

2001: -- Standard check of p_simulate and p_commit parameters
2002: -- *******************************************************
2003: IF FND_API.To_Boolean(p_simulate) THEN
2004: ROLLBACK TO populate_plsql_tbl_PVT;
2005: ELSIF FND_API.To_Boolean(p_commit) THEN
2006: COMMIT WORK;
2007: END IF;
2008:
2009: -- Standard call to get message count and if count is 1, get message info.

Line 2022: WHEN FND_API.G_EXC_ERROR THEN

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;
2024: p_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2026: p_data => p_msg_data);

Line 2024: p_return_status := FND_API.G_RET_STS_ERROR;

2020: end if;
2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO populate_plsql_tbl_PVT;
2024: p_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2026: p_data => p_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2023: ROLLBACK TO populate_plsql_tbl_PVT;
2024: p_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2026: p_data => p_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 2029: p_return_status := FND_API.G_RET_STS_ERROR;

2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2026: p_data => p_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 2036: p_return_status := FND_API.G_RET_STS_ERROR;

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);
2039: END IF;
2040: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

Line 2047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2043:
2044: PROCEDURE populate_plsql_tbl_with_intval
2045: (
2046: p_api_version_number IN NUMBER,
2047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2048: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
2049: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2051: p_return_status OUT NOCOPY VARCHAR2,

Line 2048: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

2044: PROCEDURE populate_plsql_tbl_with_intval
2045: (
2046: p_api_version_number IN NUMBER,
2047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2048: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
2049: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2051: p_return_status OUT NOCOPY VARCHAR2,
2052: p_msg_count OUT NOCOPY NUMBER,

Line 2049: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2045: (
2046: p_api_version_number IN NUMBER,
2047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2048: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
2049: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2051: p_return_status OUT NOCOPY VARCHAR2,
2052: p_msg_count OUT NOCOPY NUMBER,
2053: p_msg_data OUT NOCOPY VARCHAR2,

Line 2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2046: p_api_version_number IN NUMBER,
2047: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2048: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
2049: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2050: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2051: p_return_status OUT NOCOPY VARCHAR2,
2052: p_msg_count OUT NOCOPY NUMBER,
2053: p_msg_data OUT NOCOPY VARCHAR2,
2054: p_apps_tbl IN OUT NOCOPY ec_utils.mapping_tbl,

Line 2122: IF NOT FND_API.Compatible_API_Call

2118: -- Standard Start of API savepoint
2119: SAVEPOINT populate_plsql_tbl_PVT;
2120:
2121: -- Standard call to check for call compatibility.
2122: IF NOT FND_API.Compatible_API_Call
2123: (l_api_version_number,
2124: p_api_version_number,
2125: l_api_name,
2126: G_PKG_NAME) THEN

Line 2127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2123: (l_api_version_number,
2124: p_api_version_number,
2125: l_api_name,
2126: G_PKG_NAME) THEN
2127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2128: END IF;
2129:
2130: -- Initialize message list if p_init_msg_list is set to TRUE.
2131: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2131: IF FND_API.to_Boolean(p_init_msg_list) THEN

2127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2128: END IF;
2129:
2130: -- Initialize message list if p_init_msg_list is set to TRUE.
2131: IF FND_API.to_Boolean(p_init_msg_list) THEN
2132: FND_MSG_PUB.initialize;
2133: END IF;
2134:
2135: -- Initialize API return status to success

Line 2136: p_return_status := FND_API.G_RET_STS_SUCCESS;

2132: FND_MSG_PUB.initialize;
2133: END IF;
2134:
2135: -- Initialize API return status to success
2136: p_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: -- *******************************************************
2139: -- Move data from interface to source PL/SQL table
2140: -- These are data that do not need xref.

Line 2481: IF FND_API.To_Boolean(p_simulate) THEN

2477:
2478: -- *******************************************************
2479: -- Standard check of p_simulate and p_commit parameters
2480: -- *******************************************************
2481: IF FND_API.To_Boolean(p_simulate) THEN
2482: ROLLBACK TO populate_plsql_tbl_PVT;
2483: ELSIF FND_API.To_Boolean(p_commit) THEN
2484: COMMIT WORK;
2485: END IF;

Line 2483: ELSIF FND_API.To_Boolean(p_commit) THEN

2479: -- Standard check of p_simulate and p_commit parameters
2480: -- *******************************************************
2481: IF FND_API.To_Boolean(p_simulate) THEN
2482: ROLLBACK TO populate_plsql_tbl_PVT;
2483: ELSIF FND_API.To_Boolean(p_commit) THEN
2484: COMMIT WORK;
2485: END IF;
2486:
2487: -- Standard call to get message count and if count is 1, get message info.

Line 2500: WHEN FND_API.G_EXC_ERROR THEN

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;
2502: p_return_status := FND_API.G_RET_STS_ERROR;
2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2504: p_data => p_msg_data);

Line 2502: p_return_status := FND_API.G_RET_STS_ERROR;

2498: end if;
2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN
2501: ROLLBACK TO populate_plsql_tbl_PVT;
2502: p_return_status := FND_API.G_RET_STS_ERROR;
2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2504: p_data => p_msg_data);
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO populate_plsql_tbl_PVT;

Line 2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2501: ROLLBACK TO populate_plsql_tbl_PVT;
2502: p_return_status := FND_API.G_RET_STS_ERROR;
2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2504: p_data => p_msg_data);
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 2507: p_return_status := FND_API.G_RET_STS_ERROR;

2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2504: p_data => p_msg_data);
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO populate_plsql_tbl_PVT;
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);

Line 2514: p_return_status := FND_API.G_RET_STS_ERROR;

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);
2517: END IF;
2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,