DBA Data[Home] [Help]

APPS.IGS_PE_LANGUAGES_PKG dependencies on FND_API

Line 28: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

24: ) AS
25:
26: -- CURSOR langcursor is SELECT IGS_PE_HZ_LANGUAGES_S.NEXTVAL S from DUAL;
27:
28: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
29: lv_language_use_reference_id1 NUMBER;
30: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;
31: lv_language_use_reference_id NUMBER;
32:

Line 30: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;

26: -- CURSOR langcursor is SELECT IGS_PE_HZ_LANGUAGES_S.NEXTVAL S from DUAL;
27:
28: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
29: lv_language_use_reference_id1 NUMBER;
30: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;
31: lv_language_use_reference_id NUMBER;
32:
33: -- V2API uptake
34:

Line 70: RAISE FND_API.G_EXC_ERROR;

66: IF (dup_lang_cur%FOUND) THEN
67: CLOSE dup_lang_cur;
68: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DUP_LANG_CODE');
69: IGS_GE_MSG_STACK.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: CLOSE dup_lang_cur;
73:
74:

Line 113: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

109:
110: -- ssawhney bug 2338473
111: IF p_msg_count > 1 THEN
112: FOR i IN 1..p_msg_count LOOP
113: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
114: tmp_var1 := tmp_var1 || ' '|| tmp_var;
115: END LOOP;
116: p_msg_data := tmp_var1;
117: END IF;

Line 128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);

124: ELSIF l_action = 'UPDATE' THEN
125:
126: lv_per_language_rec_type.language_name := p_language_name;
127: lv_per_language_rec_type.party_id := p_party_id;
128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);
129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);
130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);
131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);

Line 129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);

125:
126: lv_per_language_rec_type.language_name := p_language_name;
127: lv_per_language_rec_type.party_id := p_party_id;
128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);
129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);
130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);
131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;

Line 130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);

126: lv_per_language_rec_type.language_name := p_language_name;
127: lv_per_language_rec_type.party_id := p_party_id;
128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);
129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);
130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);
131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;
134: -- lv_per_language_rec_type.created_by_module := 'IGS';

Line 131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);

127: lv_per_language_rec_type.party_id := p_party_id;
128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);
129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);
130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);
131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;
134: -- lv_per_language_rec_type.created_by_module := 'IGS';
135: lv_per_language_rec_type.spoken_comprehension_level := NVL(p_understand_level,FND_API.G_MISS_CHAR);

Line 132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);

128: lv_per_language_rec_type.native_language := NVL(p_native_language,FND_API.G_MISS_CHAR);
129: lv_per_language_rec_type.primary_language_indicator := NVL(p_primary_language_indicator,FND_API.G_MISS_CHAR);
130: lv_per_language_rec_type.reads_level := NVL(p_reads_level,FND_API.G_MISS_CHAR);
131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;
134: -- lv_per_language_rec_type.created_by_module := 'IGS';
135: lv_per_language_rec_type.spoken_comprehension_level := NVL(p_understand_level,FND_API.G_MISS_CHAR);
136: lv_per_language_rec_type.status := NVL(p_status,FND_API.G_MISS_CHAR);

Line 135: lv_per_language_rec_type.spoken_comprehension_level := NVL(p_understand_level,FND_API.G_MISS_CHAR);

131: lv_per_language_rec_type.speaks_level := NVL(p_speaks_level,FND_API.G_MISS_CHAR);
132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;
134: -- lv_per_language_rec_type.created_by_module := 'IGS';
135: lv_per_language_rec_type.spoken_comprehension_level := NVL(p_understand_level,FND_API.G_MISS_CHAR);
136: lv_per_language_rec_type.status := NVL(p_status,FND_API.G_MISS_CHAR);
137:
138:
139: HZ_PERSON_INFO_V2PUB.update_person_language(

Line 136: lv_per_language_rec_type.status := NVL(p_status,FND_API.G_MISS_CHAR);

132: lv_per_language_rec_type.writes_level := NVL(P_writes_level,FND_API.G_MISS_CHAR);
133: lv_per_language_rec_type.language_use_reference_id := lv_language_use_reference_id;
134: -- lv_per_language_rec_type.created_by_module := 'IGS';
135: lv_per_language_rec_type.spoken_comprehension_level := NVL(p_understand_level,FND_API.G_MISS_CHAR);
136: lv_per_language_rec_type.status := NVL(p_status,FND_API.G_MISS_CHAR);
137:
138:
139: HZ_PERSON_INFO_V2PUB.update_person_language(
140: p_init_msg_list => lv_init_msg_list,

Line 154: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

150:
151: -- ssawhney bug 2338473
152: IF p_msg_count > 1 THEN
153: FOR i IN 1..p_msg_count LOOP
154: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
155: tmp_var1 := tmp_var1 || ' '|| tmp_var;
156: END LOOP;
157: p_msg_data := tmp_var1;
158: END IF;

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: END IF;
163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: p_return_status := FND_API.G_RET_STS_ERROR;
168: p_msg_data := SQLERRM;
169: WHEN OTHERS THEN
170: p_return_status := FND_API.G_RET_STS_ERROR;

Line 167: p_return_status := FND_API.G_RET_STS_ERROR;

163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: p_return_status := FND_API.G_RET_STS_ERROR;
168: p_msg_data := SQLERRM;
169: WHEN OTHERS THEN
170: p_return_status := FND_API.G_RET_STS_ERROR;
171: p_msg_data := SQLERRM;

Line 170: p_return_status := FND_API.G_RET_STS_ERROR;

166: WHEN FND_API.G_EXC_ERROR THEN
167: p_return_status := FND_API.G_RET_STS_ERROR;
168: p_msg_data := SQLERRM;
169: WHEN OTHERS THEN
170: p_return_status := FND_API.G_RET_STS_ERROR;
171: p_msg_data := SQLERRM;
172: RAISE ;
173: END Languages;
174: END IGS_PE_LANGUAGES_PKG;