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.IBY_EXT_PAYEE_RELSHIPS_PKG dependencies on FND_API

Line 86: x_result := FND_API.G_TRUE ;

82: IF ( (p_party_id = x_remit_party_id AND p_supplier_site_id IS NULL) OR
83: (p_party_id IS NULL AND p_supplier_site_id = x_remit_supplier_site_id) OR
84: (p_party_id = x_remit_party_id AND p_supplier_site_id = x_remit_supplier_site_id) ) THEN
85: print_debuginfo('0 Trading Partner and Remit to Supplier are same');
86: x_result := FND_API.G_TRUE ;
87: x_relationship_id := -1;
88: x_remit_party_id := p_party_id;
89: x_remit_supplier_site_id := p_supplier_site_id;
90: print_debuginfo('0 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');

Line 115: x_result := FND_API.G_TRUE ;

111: AND primary_flag = 'Y'
112: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
113: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
114:
115: x_result := FND_API.G_TRUE ;
116:
117: EXCEPTION
118: WHEN OTHERS THEN
119: print_debuginfo('1 Primary Relationship not found');

Line 120: x_result := FND_API.G_TRUE ;

116:
117: EXCEPTION
118: WHEN OTHERS THEN
119: print_debuginfo('1 Primary Relationship not found');
120: x_result := FND_API.G_TRUE ;
121: x_relationship_id := -1;
122: x_remit_party_id := p_party_id;
123: x_remit_supplier_site_id := p_supplier_site_id;
124: print_debuginfo('1 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');

Line 148: x_result := FND_API.G_TRUE ;

144: AND primary_flag = 'Y'
145: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
146: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
147:
148: x_result := FND_API.G_TRUE ;
149:
150: EXCEPTION
151: WHEN OTHERS THEN
152: IF (x_remit_supplier_site_id <> p_supplier_site_id ) THEN

Line 168: x_result := FND_API.G_TRUE ;

164: END IF;
165:
166: IF (( p_count > 0) OR (x_remit_supplier_site_id = p_supplier_site_id) ) THEN
167: print_debuginfo('2 Secondary Relationship found');
168: x_result := FND_API.G_TRUE ;
169: ELSE
170: print_debuginfo('2 Secondary Relationship not found');
171: x_result := FND_API.G_FALSE ;
172: END IF;

Line 171: x_result := FND_API.G_FALSE ;

167: print_debuginfo('2 Secondary Relationship found');
168: x_result := FND_API.G_TRUE ;
169: ELSE
170: print_debuginfo('2 Secondary Relationship not found');
171: x_result := FND_API.G_FALSE ;
172: END IF;
173:
174: x_relationship_id := -1;
175: x_remit_party_id := p_party_id;

Line 202: x_result := FND_API.G_TRUE ;

198: AND primary_flag = 'Y'
199: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
200: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
201:
202: x_result := FND_API.G_TRUE ;
203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: print_debuginfo('3 Primary Relationship not found');

Line 221: x_result := FND_API.G_TRUE ;

217: END IF;
218:
219: IF ( (p_count > 0 ) OR ( x_remit_party_id = p_party_id)) THEN
220: print_debuginfo('3 Secondary Relationship found');
221: x_result := FND_API.G_TRUE ;
222: ELSE
223: print_debuginfo('3 Secondary Relationship not found');
224: x_result := FND_API.G_FALSE ;
225: END IF;

Line 224: x_result := FND_API.G_FALSE ;

220: print_debuginfo('3 Secondary Relationship found');
221: x_result := FND_API.G_TRUE ;
222: ELSE
223: print_debuginfo('3 Secondary Relationship not found');
224: x_result := FND_API.G_FALSE ;
225: END IF;
226:
227: x_relationship_id := -1;
228: x_remit_party_id := p_party_id;

Line 254: x_result := FND_API.G_TRUE ;

250: AND primary_flag = 'Y'
251: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
252: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
253:
254: x_result := FND_API.G_TRUE ;
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: print_debuginfo('4 Primary Relationship not found');

Line 273: x_result := FND_API.G_TRUE ;

269: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
270:
271: IF ( p_count > 0 ) THEN
272: print_debuginfo('4 Secondary Relationship found');
273: x_result := FND_API.G_TRUE ;
274: ELSE
275: print_debuginfo('4 Secondary Relationship not found');
276: x_result := FND_API.G_FALSE ;
277: END IF;

Line 276: x_result := FND_API.G_FALSE ;

272: print_debuginfo('4 Secondary Relationship found');
273: x_result := FND_API.G_TRUE ;
274: ELSE
275: print_debuginfo('4 Secondary Relationship not found');
276: x_result := FND_API.G_FALSE ;
277: END IF;
278:
279: x_relationship_id := -1;
280: x_remit_party_id := p_party_id;

Line 308: x_result := FND_API.G_TRUE ;

304: AND relationship_id = x_relationship_id
305: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
306: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
307:
308: x_result := FND_API.G_TRUE ;
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: print_debuginfo('1 Relationship not found');

Line 313: x_result := FND_API.G_FALSE ;

309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: print_debuginfo('1 Relationship not found');
313: x_result := FND_API.G_FALSE ;
314: print_debuginfo('1 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
315: print_debuginfo('1 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
316:
317: END;

Line 336: x_result := FND_API.G_TRUE ;

332: AND relationship_id = x_relationship_id
333: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
334: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
335:
336: x_result := FND_API.G_TRUE ;
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: print_debuginfo('2 Relationship not found');

Line 341: x_result := FND_API.G_FALSE ;

337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: print_debuginfo('2 Relationship not found');
341: x_result := FND_API.G_FALSE ;
342: print_debuginfo('2 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
343: print_debuginfo('2 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
344:
345:

Line 367: x_result := FND_API.G_TRUE ;

363: AND relationship_id = x_relationship_id
364: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
365: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
366:
367: x_result := FND_API.G_TRUE ;
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: print_debuginfo('3 Relationship not found');

Line 372: x_result := FND_API.G_FALSE ;

368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: print_debuginfo('3 Relationship not found');
372: x_result := FND_API.G_FALSE ;
373: print_debuginfo('3 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
374: print_debuginfo('3 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
375:
376: END;

Line 397: x_result := FND_API.G_TRUE ;

393: AND relationship_id = x_relationship_id
394: AND(to_char(nvl(p_date, sysdate), 'YYYY-MM-DD HH24:MI:SS') BETWEEN(to_char(irel.from_date, 'YYYY-MM-DD') || ' 00:00:00')
395: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
396:
397: x_result := FND_API.G_TRUE ;
398:
399: EXCEPTION
400: WHEN OTHERS THEN
401: print_debuginfo('4 Relationship not found');

Line 402: x_result := FND_API.G_FALSE ;

398:
399: EXCEPTION
400: WHEN OTHERS THEN
401: print_debuginfo('4 Relationship not found');
402: x_result := FND_API.G_FALSE ;
403: print_debuginfo('4 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
404: print_debuginfo('4 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
405: END;
406: END IF;