APPS.M4U_SETUP_PACKAGE dependencies on STANDARD

Line 35: l_standard_code VARCHAR2(10);

31: l_hub_user_id NUMBER;
32: l_tp_hdr_id NUMBER;
33:
34:
35: l_standard_code VARCHAR2(10);
36: l_party_type VARCHAR2(10);
37: l_direction VARCHAR2(10);
38: l_retcode VARCHAR2(20);
39:

Line 83: l_standard_code := 'UCCNET';

79: cln_debug_pub.Add('- Defaulting the local variables - ', 1);
80: END IF;
81:
82: l_ext_type := 'M4U';
83: l_standard_code := 'UCCNET';
84: l_transaction_type := 'M4U';
85: l_party_type := 'I';
86: l_doc_conf := '2';
87: l_src_loc := 'UCCNET_HUB';

Line 106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);

102:
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);

Line 138: ecx_standards svl

134: ecx_tp_details tpd,
135: ecx_tp_headers tph,
136: ecx_ext_processes extp,
137: ecx_transactions txn,
138: ecx_standards svl
139: WHERE 1=1
140: AND tph.tp_header_id = tpd.tp_header_id
141: AND tpd.ext_process_id = extp.ext_process_id
142: AND extp.transaction_id = txn.transaction_id

Line 143: AND extp.standard_id = svl.standard_id

139: WHERE 1=1
140: AND tph.tp_header_id = tpd.tp_header_id
141: AND tpd.ext_process_id = extp.ext_process_id
142: AND extp.transaction_id = txn.transaction_id
143: AND extp.standard_id = svl.standard_id
144: AND svl.standard_code = l_standard_code
145: AND extp.ext_type = l_ext_type
146: AND extp.ext_subtype = l_ext_subtype
147: AND extp.direction = l_direction

Line 144: AND svl.standard_code = l_standard_code

140: AND tph.tp_header_id = tpd.tp_header_id
141: AND tpd.ext_process_id = extp.ext_process_id
142: AND extp.transaction_id = txn.transaction_id
143: AND extp.standard_id = svl.standard_id
144: AND svl.standard_code = l_standard_code
145: AND extp.ext_type = l_ext_type
146: AND extp.ext_subtype = l_ext_subtype
147: AND extp.direction = l_direction
148: AND txn.transaction_type = l_transaction_type

Line 173: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);

169: FND_MESSAGE.SET_NAME('CLN','M4U_TP_DTL_SETUP_ISSUE');
170: FND_MESSAGE.SET_TOKEN('PARAM1',l_transaction_type);
171: FND_MESSAGE.SET_TOKEN('PARAM2',l_transaction_subtype);
172: FND_MESSAGE.SET_TOKEN('PARAM3',l_direction);
173: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);
174: l_msg_data := FND_MESSAGE.GET;
175: RAISE FND_API.G_EXC_ERROR;
176: END;
177:

Line 187: ecx_standards svl

183: SELECT extp.ext_process_id
184: INTO l_ext_process_id
185: FROM ecx_ext_processes extp,
186: ecx_transactions txn,
187: ecx_standards svl
188: WHERE 1=1
189: AND extp.transaction_id = txn.transaction_id
190: AND extp.standard_id = svl.standard_id
191: AND svl.standard_code = l_standard_code

Line 190: AND extp.standard_id = svl.standard_id

186: ecx_transactions txn,
187: ecx_standards svl
188: WHERE 1=1
189: AND extp.transaction_id = txn.transaction_id
190: AND extp.standard_id = svl.standard_id
191: AND svl.standard_code = l_standard_code
192: AND extp.ext_type = l_ext_type
193: AND extp.ext_subtype = l_ext_subtype
194: AND extp.direction = l_direction

Line 191: AND svl.standard_code = l_standard_code

187: ecx_standards svl
188: WHERE 1=1
189: AND extp.transaction_id = txn.transaction_id
190: AND extp.standard_id = svl.standard_id
191: AND svl.standard_code = l_standard_code
192: AND extp.ext_type = l_ext_type
193: AND extp.ext_subtype = l_ext_subtype
194: AND extp.direction = l_direction
195: AND txn.party_type = l_party_type

Line 215: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);

211: FND_MESSAGE.SET_NAME('CLN','M4U_EXT_PROCESS_SETUP_EXISTS');
212: FND_MESSAGE.SET_TOKEN('PARAM1',l_transaction_type);
213: FND_MESSAGE.SET_TOKEN('PARAM2',l_transaction_subtype);
214: FND_MESSAGE.SET_TOKEN('PARAM3',l_direction);
215: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);
216: l_msg_data := FND_MESSAGE.GET;
217:
218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('-- Two Many Ext Process ID for M4U exists --',1);