DBA Data[Home] [Help]

APPS.QA_ERES_SHIPPING dependencies on FND_API

Line 13: out_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS;

9: ARGUMENT2 IN VARCHAR2) IS
10:
11: from_pickup_dt DATE;
12: to_pickup_dt DATE;
13: out_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS;
14: edr_profile VARCHAR2(20) := 'N';
15: BEGIN
16:
17: -- ARGUMENT1 --> From Date

Line 52: if (out_status = FND_API.G_RET_STS_ERROR

48: --default value for out_status is SUCCESS
49: delivery_erecord(from_pickup_dt, to_pickup_dt, out_status);
50: END IF;
51:
52: if (out_status = FND_API.G_RET_STS_ERROR
53: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)
54: then
55: RETCODE := 1;
56: ERRBUF := 'Warning: Some eRecords may have resulted in error';

Line 53: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)

49: delivery_erecord(from_pickup_dt, to_pickup_dt, out_status);
50: END IF;
51:
52: if (out_status = FND_API.G_RET_STS_ERROR
53: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)
54: then
55: RETCODE := 1;
56: ERRBUF := 'Warning: Some eRecords may have resulted in error';
57: else

Line 95: out_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS;

91: --following indexes exist on EDR table
92: --EDR_PSIG_DOCUMENTS_N1 - on event_name and event_key
93:
94: out_erecord_id NUMBER;
95: out_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS;
96:
97: BEGIN
98:
99: FOR wsh_rec IN wsh_delivery_cur (p_from_date, p_to_date, g_event_name_const)

Line 108: if (out_status = FND_API.G_RET_STS_ERROR

104:
105: --even if one of the events gives an error, mark it so
106: --Warning can be raised for Concurrent program completion
107: --if everything fine, default value will be success
108: if (out_status = FND_API.G_RET_STS_ERROR
109: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)
110: then
111: x_status := out_status;
112: end if;

Line 109: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)

105: --even if one of the events gives an error, mark it so
106: --Warning can be raised for Concurrent program completion
107: --if everything fine, default value will be success
108: if (out_status = FND_API.G_RET_STS_ERROR
109: or out_status = FND_API.G_RET_STS_UNEXP_ERROR)
110: then
111: x_status := out_status;
112: end if;
113: END LOOP;

Line 176: p_init_msg_list => FND_API.G_TRUE, --BUG 3763874

172:
173: QA_EDR_STANDARD.RAISE_ERES_EVENT
174: (
175: p_api_version => 1.0,
176: p_init_msg_list => FND_API.G_TRUE, --BUG 3763874
177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
178: x_return_status => o_return_status,
179: x_msg_count => o_msg_count,
180: x_msg_data => o_msg_data,

Line 177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

173: QA_EDR_STANDARD.RAISE_ERES_EVENT
174: (
175: p_api_version => 1.0,
176: p_init_msg_list => FND_API.G_TRUE, --BUG 3763874
177: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
178: x_return_status => o_return_status,
179: x_msg_count => o_msg_count,
180: x_msg_data => o_msg_data,
181: p_child_erecords => l_child_erecords,

Line 210: , p_init_msg_list => FND_API.G_TRUE

206: IF (o_erecord_id IS NOT NULL AND o_erecord_id > 0)
207: THEN
208: QA_EDR_STANDARD.SEND_ACKN
209: ( p_api_version => 1.0
210: , p_init_msg_list => FND_API.G_TRUE
211: , x_return_status => o_return_status
212: , x_msg_count => o_msg_count
213: , x_msg_data => o_msg_data
214: , p_event_name => l_event.event_name

Line 220: , p_autonomous_commit => FND_API.G_TRUE);

216: , p_erecord_id => o_erecord_id
217: , p_trans_status => 'SUCCESS'
218: , p_ackn_by => 'Shipment Delivery eRecord Program'
219: , p_ackn_note => ''
220: , p_autonomous_commit => FND_API.G_TRUE);
221: --english ok here for p_ackn_by, since internal
222: --program name
223: END IF;
224: END raise_delivery_event;