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 87: x_result := FND_API.G_TRUE ;

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

Line 116: x_result := FND_API.G_TRUE ;

112: AND primary_flag = 'Y'
113: 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')
114: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
115:
116: x_result := FND_API.G_TRUE ;
117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: print_debuginfo('1 Primary Relationship not found');

Line 121: x_result := FND_API.G_TRUE ;

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

Line 149: x_result := FND_API.G_TRUE ;

145: AND primary_flag = 'Y'
146: 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')
147: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
148:
149: x_result := FND_API.G_TRUE ;
150:
151: EXCEPTION
152: WHEN OTHERS THEN
153: IF (x_remit_supplier_site_id <> p_supplier_site_id ) THEN

Line 169: x_result := FND_API.G_TRUE ;

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

Line 172: x_result := FND_API.G_FALSE ;

168: print_debuginfo('2 Secondary Relationship found');
169: x_result := FND_API.G_TRUE ;
170: ELSE
171: print_debuginfo('2 Secondary Relationship not found');
172: x_result := FND_API.G_FALSE ;
173: END IF;
174:
175: IF( p_count = 1) THEN
176: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id

Line 217: x_result := FND_API.G_TRUE ;

213: AND primary_flag = 'Y'
214: 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')
215: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
216:
217: x_result := FND_API.G_TRUE ;
218:
219: EXCEPTION
220: WHEN OTHERS THEN
221: print_debuginfo('3 Primary Relationship not found');

Line 236: x_result := FND_API.G_TRUE ;

232: END IF;
233:
234: IF ( (p_count > 0 ) OR ( x_remit_party_id = p_party_id)) THEN
235: print_debuginfo('3 Secondary Relationship found');
236: x_result := FND_API.G_TRUE ;
237: ELSE
238: print_debuginfo('3 Secondary Relationship not found');
239: x_result := FND_API.G_FALSE ;
240: END IF;

Line 239: x_result := FND_API.G_FALSE ;

235: print_debuginfo('3 Secondary Relationship found');
236: x_result := FND_API.G_TRUE ;
237: ELSE
238: print_debuginfo('3 Secondary Relationship not found');
239: x_result := FND_API.G_FALSE ;
240: END IF;
241:
242: IF( p_count = 1) THEN
243: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id

Line 283: x_result := FND_API.G_TRUE ;

279: AND primary_flag = 'Y'
280: 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')
281: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
282:
283: x_result := FND_API.G_TRUE ;
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: print_debuginfo('4 Primary Relationship not found');

Line 302: x_result := FND_API.G_TRUE ;

298: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
299:
300: IF ( p_count > 0 ) THEN
301: print_debuginfo('4 Secondary Relationship found');
302: x_result := FND_API.G_TRUE ;
303: ELSE
304: print_debuginfo('4 Secondary Relationship not found');
305: x_result := FND_API.G_FALSE ;
306: END IF;

Line 305: x_result := FND_API.G_FALSE ;

301: print_debuginfo('4 Secondary Relationship found');
302: x_result := FND_API.G_TRUE ;
303: ELSE
304: print_debuginfo('4 Secondary Relationship not found');
305: x_result := FND_API.G_FALSE ;
306: END IF;
307:
308: IF( p_count = 1) THEN
309: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id

Line 352: x_result := FND_API.G_TRUE ;

348: AND relationship_id = x_relationship_id
349: 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')
350: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
351:
352: x_result := FND_API.G_TRUE ;
353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: print_debuginfo('1 Relationship not found');

Line 357: x_result := FND_API.G_FALSE ;

353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: print_debuginfo('1 Relationship not found');
357: x_result := FND_API.G_FALSE ;
358: print_debuginfo('1 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
359: print_debuginfo('1 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
360:
361: END;

Line 380: x_result := FND_API.G_TRUE ;

376: AND relationship_id = x_relationship_id
377: 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')
378: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
379:
380: x_result := FND_API.G_TRUE ;
381:
382: EXCEPTION
383: WHEN OTHERS THEN
384: print_debuginfo('2 Relationship not found');

Line 385: x_result := FND_API.G_FALSE ;

381:
382: EXCEPTION
383: WHEN OTHERS THEN
384: print_debuginfo('2 Relationship not found');
385: x_result := FND_API.G_FALSE ;
386: print_debuginfo('2 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
387: print_debuginfo('2 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
388:
389:

Line 411: x_result := FND_API.G_TRUE ;

407: AND relationship_id = x_relationship_id
408: 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')
409: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
410:
411: x_result := FND_API.G_TRUE ;
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: print_debuginfo('3 Relationship not found');

Line 416: x_result := FND_API.G_FALSE ;

412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: print_debuginfo('3 Relationship not found');
416: x_result := FND_API.G_FALSE ;
417: print_debuginfo('3 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
418: print_debuginfo('3 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
419:
420: END;

Line 441: x_result := FND_API.G_TRUE ;

437: AND relationship_id = x_relationship_id
438: 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')
439: AND(to_char(nvl(irel.to_date, nvl(p_date, sysdate)), 'YYYY-MM-DD') || ' 23:59:59'));
440:
441: x_result := FND_API.G_TRUE ;
442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: print_debuginfo('4 Relationship not found');

Line 446: x_result := FND_API.G_FALSE ;

442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: print_debuginfo('4 Relationship not found');
446: x_result := FND_API.G_FALSE ;
447: print_debuginfo('4 Output Parameters : x_result,x_relationship_id,x_remit_party_id,x_remit_supplier_site_id');
448: print_debuginfo('4 Output Values : ' || x_result ||',' || x_relationship_id ||',' || x_remit_party_id || ','|| x_remit_supplier_site_id );
449: END;
450: END IF;

Line 476: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

472: print_debuginfo('Enter : create_Ext_Payee_Relationship ');
473:
474: validate_Payee_Relationship(p_relationship,'CREATE', x_return_status);
475:
476: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
477:
478: x_relationship_id := IBY_EXT_PAYEE_RELSHIP_SEQ.nextval;
479:
480: INSERT

Line 577: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

573:
574: validate_Payee_Relationship(p_relationship,'UPDATE', x_return_status);
575: x_relationship_id := p_relationship.relationship_id;
576:
577: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
578: UPDATE IBY_EXT_PAYEE_RELATIONSHIPS
579: SET
580: party_id = p_relationship.party_id,
581: supplier_site_id = p_relationship.supplier_site_id,

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: l_error_count := 0;
640:
641: IF (p_relationship.party_id IS NULL OR p_relationship.supplier_site_id IS NULL OR p_relationship.remit_party_id IS NULL OR p_relationship.remit_supplier_site_id IS NULL) THEN
642: print_debuginfo('One or more of the mandatory payee parameters is/are NULL');
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: ELSIF (p_relationship.from_date IS NULL OR (NVL(p_relationship.from_date,SYSDATE) > NVL(p_relationship.to_date,NVL(p_relationship.from_date,SYSDATE)+1))) THEN
645: print_debuginfo('Either the relationship from_date is NULL or the relationship from_date is after the relationship to_date');
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: ELSE

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642: print_debuginfo('One or more of the mandatory payee parameters is/are NULL');
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: ELSIF (p_relationship.from_date IS NULL OR (NVL(p_relationship.from_date,SYSDATE) > NVL(p_relationship.to_date,NVL(p_relationship.from_date,SYSDATE)+1))) THEN
645: print_debuginfo('Either the relationship from_date is NULL or the relationship from_date is after the relationship to_date');
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: ELSE
648:
649: IF(p_relationship.active='Y') THEN
650: --Finding other active primary relationships for the same date range

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

716: print_debuginfo('Conflicting Active Relationships : '||l_error_count);
717: print_debuginfo('Conflicting Active Relationship IDs: '||l_error_id);
718:
719: IF l_error_total > 0 THEN
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: ELSE
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: END IF;
724: ELSE

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

718:
719: IF l_error_total > 0 THEN
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: ELSE
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: END IF;
724: ELSE
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726: END IF;

Line 725: x_return_status := FND_API.G_RET_STS_SUCCESS;

721: ELSE
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: END IF;
724: ELSE
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726: END IF;
727: END IF;
728:
729: print_debuginfo('Exit : validate_Payee_Relationship ');