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

Line 5: -- Declare package variables used for FND_API calls.

1: package BODY GMS_PO_API2_GRP as
2: --$Header: gmsgpo2b.pls 120.0.12020000.2 2012/07/18 09:31:29 admarath ship $
3:
4: -- Start of comments
5: -- Declare package variables used for FND_API calls.
6: -- End of comments
7: -- ------------------
8:
9: G_api_version CONSTANT NUMBER := 1.0 ;

Line 78: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

74: p_api_name IN varchar2 ) is
75:
76: l_msg_count NUMBER ;
77: l_msg_data varchar2(2000) ;
78: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
79: BEGIN
80:
81: -- Standrad call to check API compatibility.
82: IF NOT FND_API.Compatible_API_Call( G_api_version,

Line 82: IF NOT FND_API.Compatible_API_Call( G_api_version,

78: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
79: BEGIN
80:
81: -- Standrad call to check API compatibility.
82: IF NOT FND_API.Compatible_API_Call( G_api_version,
83: p_api_version,
84: p_api_name,
85: G_pkg_name) THEN
86:

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

83: p_api_version,
84: p_api_name,
85: G_pkg_name) THEN
86:
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
88: END IF ;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE
91: --

Line 92: IF FND_API.to_boolean( p_init_msg_list) THEN

88: END IF ;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE
91: --
92: IF FND_API.to_boolean( p_init_msg_list) THEN
93:
94: FND_MSG_PUB.initialize ;
95:
96: END IF ;

Line 100: l_return_status := FND_API.G_RET_STS_SUCCESS ;

96: END IF ;
97:
98: -- Initialize API return status to success.
99: --
100: l_return_status := FND_API.G_RET_STS_SUCCESS ;
101:
102: --
103: -- Determine the validation level
104: --

Line 105: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

101:
102: --
103: -- Determine the validation level
104: --
105: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
106:
107: -- No validation logic required for this API.
108: --
109: NULL ;

Line 120: WHEN FND_API.G_EXC_ERROR then

116: x_msg_data := l_msg_data ;
117: x_return_status := l_return_status ;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;

Line 121: x_return_status := FND_API.G_RET_STS_ERROR ;

117: x_return_status := l_return_status ;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;
125:

Line 122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR then
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

122: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
129: p_count => x_msg_count ,
130: p_data => x_msg_data ) ;

Line 127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

123: p_count => x_msg_count ,
124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
129: p_count => x_msg_count ,
130: p_data => x_msg_data ) ;
131: WHEN OTHERS THEN

Line 128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

124: p_data => x_msg_data ) ;
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
129: p_count => x_msg_count ,
130: p_data => x_msg_data ) ;
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

128: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
129: p_count => x_msg_count ,
130: p_data => x_msg_data ) ;
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133:
134: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg( G_pkg_name, p_api_name ) ;
136: END IF ;

Line 138: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

134: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg( G_pkg_name, p_api_name ) ;
136: END IF ;
137:
138: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
139: p_count => x_msg_count ,
140: p_data => x_msg_data ) ;
141: END common_code ;
142:

Line 181: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

177:
178: l_dummy NUMBER ;
179: BEGIN
180:
181: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
182:
183: IF NVL(p_interface_obj.distribution_id.COUNT,0) <= 0 then
184: return ;
185: END IF ;

Line 353: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

349: p_interface_obj in out nocopy gms_po_interface_type) is
350:
351: l_msg_count NUMBER ;
352: l_msg_data varchar2(4000) ;
353: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
354: l_api_name varchar2(45) := 'create_adls' ;
355: begin
356:
357: -- API standards requires a standard code to validate

Line 377: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

373: IF not gms_install.enabled then
374: return ;
375: END IF ;
376:
377: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
378: -- =================================================
379: -- Bulk processing to create award distribution
380: -- lines.
381: -- =================================================

Line 449: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

445: ) is
446:
447: l_msg_count NUMBER ;
448: l_msg_data varchar2(4000) ;
449: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
450: l_api_name varchar2(45) := 'validate_po_purge' ;
451: begin
452:
453: -- Standrad call to check API compatibility.

Line 530: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

526: p_in_rec IN PURGE_IN_RECTYPE
527: ) is
528: l_msg_count NUMBER ;
529: l_msg_data varchar2(4000) ;
530: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
531: l_api_name varchar2(45) := 'po_purge' ;
532: begin
533:
534: -- Standrad call to check API compatibility.

Line 548: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

544: l_msg_data ,
545: l_return_status ,
546: l_api_name ) ;
547:
548: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
549: -- Program logic begins here
550: IF p_in_rec.entity_ids.COUNT > 0 THEN
551: FORALL i in p_in_rec.entity_ids.first.. p_in_rec.entity_ids.last
552: delete from gms_award_distributions adl

Line 605: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

601: x_award_num_tbl OUT nocopy tbl_v15) is
602:
603: l_msg_count NUMBER ;
604: l_msg_data varchar2(2000) ;
605: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
606: l_api_name varchar2(45) := 'get_award_number' ;
607: l_award_set_id NUMBER ;
608: l_award_number gms_awards_all.award_number%TYPE ;
609: l_count NUMBER ;

Line 627: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

623: l_return_status ,
624: l_api_name ) ;
625:
626: -- Program logic begins here
627: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
628: IF p_award_set_id_tbl.count > 0 THEN
629:
630: FOR l_index in 1..p_award_set_id_tbl.count LOOP
631: l_award_set_id := p_award_set_id_tbl(l_index) ;

Line 652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

648: x_return_status := l_return_status ;
649:
650: EXCEPTION
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
655: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
656: END IF ;

Line 658: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,

654: IF FND_MSG_PUB.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
655: fnd_msg_pub.add_exc_msg( G_pkg_name, l_api_name ) ;
656: END IF ;
657:
658: FND_MSG_PUB.count_and_get ( p_encoded => fnd_api.g_false,
659: p_count => x_msg_count ,
660: p_data => x_msg_data ) ;
661: END get_award_number ;
662: