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

Line 21: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was

17: -- 24-may-2002 rsripada Implemented reject row
18: -- 17-may-2002 rsripada Modified defer_row
19: -- 19-feb-2002 rsripada Created
20:
21: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was
22: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will
23: -- commit any work done as part of this proceduer using autonomous
24: -- transaction. sequence is a column in the inq that together with
25: -- the user_name, tran_id, pub_item can uniquely identify a record

Line 22: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will

18: -- 17-may-2002 rsripada Modified defer_row
19: -- 19-feb-2002 rsripada Created
20:
21: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was
22: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will
23: -- commit any work done as part of this proceduer using autonomous
24: -- transaction. sequence is a column in the inq that together with
25: -- the user_name, tran_id, pub_item can uniquely identify a record
26: -- in the inq.

Line 108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

104: l_bool_ret boolean;
105: l_cp_run varchar2(1);
106: BEGIN
107: l_cp_run := 'N';
108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;

Line 109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

105: l_cp_run varchar2(1);
106: BEGIN
107: l_cp_run := 'N';
108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: return;

Line 110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

106: BEGIN
107: l_cp_run := 'N';
108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;

Line 111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

107: l_cp_run := 'N';
108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
109: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
110: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
111: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: -- Construct the error message if it is not passed in
119: IF (p_error_msg = FND_API.G_MISS_CHAR) OR
120: (p_error_msg IS NULL) THEN

Line 119: IF (p_error_msg = FND_API.G_MISS_CHAR) OR

115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: -- Construct the error message if it is not passed in
119: IF (p_error_msg = FND_API.G_MISS_CHAR) OR
120: (p_error_msg IS NULL) THEN
121: l_error_msg := 'Error Msg: ';
122:
123: FOR j in 1 .. fnd_msg_pub.count_msg LOOP

Line 124: fnd_msg_pub.get(j, FND_API.G_FALSE, l_msg_data, l_msg_dummy);

120: (p_error_msg IS NULL) THEN
121: l_error_msg := 'Error Msg: ';
122:
123: FOR j in 1 .. fnd_msg_pub.count_msg LOOP
124: fnd_msg_pub.get(j, FND_API.G_FALSE, l_msg_data, l_msg_dummy);
125: l_errmsg_length := length(l_error_msg);
126: l_msg_length := l_errmsg_length + length(l_msg_data);
127: IF l_msg_length < 4000 THEN
128: l_error_msg := l_error_msg || l_msg_data;

Line 189: x_return_status := FND_API.G_RET_STS_ERROR;

185: OPEN c_resource_id(p_user_name);
186: FETCH c_resource_id INTO l_resource_id;
187: IF c_resource_id%NOTFOUND THEN
188: CLOSE c_resource_id;
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: return;
191: END IF;
192: CLOSE c_resource_id;
193: INSERT INTO asg_deferred_traninfo (DEVICE_USER_NAME,

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: inq_tbl_name VARCHAR2(30);
246: sql_string VARCHAR2(512);
247: BEGIN
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250: inq_tbl_name := 'CFM$' || p_pubitem;
251: sql_string := 'DELETE FROM '|| asg_base.G_OLITE_SCHEMA ||
252: '.' || inq_tbl_name ||
253: ' WHERE clid$$cs = :1 AND ' ||

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: USING p_user_name, p_tranid;
263: EXCEPTION
264: WHEN OTHERS THEN
265: -- Ignore exceptions
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: IF(asg_helper.check_is_log_enabled(g_err_level))
268: THEN
269: asg_helper.log('purge_deferred_rows: Exception: ',
270: 'asg_defer', g_err_level);

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: inq_tbl_name VARCHAR2(30);
312: sql_string VARCHAR2(512);
313: BEGIN
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: inq_tbl_name := 'CFM$' || p_pubitem;
317: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
318: '.' || inq_tbl_name ||
319: ' WHERE clid$$cs = :1 AND ' ||

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: USING p_user_name, p_tranid, p_sequence;
330: EXCEPTION
331: WHEN OTHERS THEN
332: -- Ignore exceptions
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: IF(asg_helper.check_is_log_enabled(g_err_level))
335: THEN
336: asg_helper.log('delete_deferred_row_internal: Exception: ',
337: 'asg_defer', g_err_level);

Line 381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

377: x_return_status OUT NOCOPY VARCHAR2)
378: IS
379: l_deferred_row VARCHAR2(1);
380: BEGIN
381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;

Line 382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

378: IS
379: l_deferred_row VARCHAR2(1);
380: BEGIN
381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: return;

Line 383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

379: l_deferred_row VARCHAR2(1);
380: BEGIN
381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: return;
387: END IF;

Line 384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

380: BEGIN
381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: return;
387: END IF;
388:

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
382: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
383: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
384: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: return;
387: END IF;
388:
389: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

Line 392: IF l_deferred_row = FND_API.G_FALSE THEN

388:
389: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
390: p_pubitem, p_sequence);
391: -- Row is not deferred do not delete.
392: IF l_deferred_row = FND_API.G_FALSE THEN
393: IF(asg_helper.check_is_log_enabled(g_err_level))
394: THEN
395: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
396: 'asg_defer',g_err_level);

Line 417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

413: IS
414: l_ret_status BOOLEAN;
415: l_def_trans VARCHAR2(1);
416: BEGIN
417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

414: l_ret_status BOOLEAN;
415: l_def_trans VARCHAR2(1);
416: BEGIN
417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: return;

Line 419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

415: l_def_trans VARCHAR2(1);
416: BEGIN
417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: return;
423: END IF;

Line 420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

416: BEGIN
417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: return;
423: END IF;
424:

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
418: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
419: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
420: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: return;
423: END IF;
424:
425: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: x_return_status := FND_API.G_RET_STS_ERROR;
422: return;
423: END IF;
424:
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: l_ret_status := asg_download.markdirty(p_pubitem, p_user_name,
428: p_tranid, p_sequence);
429: IF (l_ret_status = FALSE) THEN

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426:
427: l_ret_status := asg_download.markdirty(p_pubitem, p_user_name,
428: p_tranid, p_sequence);
429: IF (l_ret_status = FALSE) THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF(asg_helper.check_is_log_enabled(g_err_level))
432: THEN
433: asg_helper.log('reject_row: Error in call to markdirty',
434: 'asg_defer', g_err_level);

Line 441: IF l_def_trans = FND_API.G_FALSE THEN

437: END IF;
438:
439: -- Check if this transaction is deferred
440: l_def_trans := is_deferred(p_user_name, p_tranid, p_pubitem, p_sequence);
441: IF l_def_trans = FND_API.G_FALSE THEN
442: -- Delete the row from inq
443: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
444: x_return_status);
445: END IF;

Line 455: -- Returns FND_API.G_TRUE if the transaction is deferred

451: 'asg_defer',g_stmt_level);
452: END IF;
453: END reject_row;
454:
455: -- Returns FND_API.G_TRUE if the transaction is deferred
456: FUNCTION is_deferred(p_user_name IN VARCHAR2,
457: p_tranid IN NUMBER)
458: RETURN VARCHAR2 IS
459: l_retcode VARCHAR2(1);

Line 469: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

465: tranid = p_tranid AND
466: deferred <> 'N';
467: BEGIN
468:
469: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
470: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
471: return FND_API.G_FALSE;
472: END IF;
473:

Line 470: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

466: deferred <> 'N';
467: BEGIN
468:
469: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
470: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
471: return FND_API.G_FALSE;
472: END IF;
473:
474: l_retcode := FND_API.G_TRUE;

Line 471: return FND_API.G_FALSE;

467: BEGIN
468:
469: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
470: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
471: return FND_API.G_FALSE;
472: END IF;
473:
474: l_retcode := FND_API.G_TRUE;
475: OPEN c_isdeferred(p_user_name, p_tranid);

Line 474: l_retcode := FND_API.G_TRUE;

470: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
471: return FND_API.G_FALSE;
472: END IF;
473:
474: l_retcode := FND_API.G_TRUE;
475: OPEN c_isdeferred(p_user_name, p_tranid);
476: FETCH c_isdeferred INTO l_user_name;
477: IF c_isdeferred%NOTFOUND THEN
478: l_retcode := FND_API.G_FALSE;

Line 478: l_retcode := FND_API.G_FALSE;

474: l_retcode := FND_API.G_TRUE;
475: OPEN c_isdeferred(p_user_name, p_tranid);
476: FETCH c_isdeferred INTO l_user_name;
477: IF c_isdeferred%NOTFOUND THEN
478: l_retcode := FND_API.G_FALSE;
479: END IF;
480: CLOSE c_isdeferred;
481: IF(asg_helper.check_is_log_enabled(g_stmt_level))
482: THEN

Line 491: -- Returns FND_API.G_TRUE if the record is deferred

487: return l_retcode;
488:
489: END is_deferred;
490:
491: -- Returns FND_API.G_TRUE if the record is deferred
492: FUNCTION is_deferred(p_user_name IN VARCHAR2,
493: p_tranid IN NUMBER,
494: p_pubitem IN VARCHAR2,
495: p_sequence IN NUMBER)

Line 509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

505: object_name = p_pubitem AND
506: sequence = p_sequence;
507: BEGIN
508:
509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;

Line 510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

506: sequence = p_sequence;
507: BEGIN
508:
509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;
514: END IF;

Line 511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

507: BEGIN
508:
509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;
514: END IF;
515:

Line 512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

508:
509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;
514: END IF;
515:
516: l_retcode := FND_API.G_TRUE;

Line 513: return FND_API.G_FALSE;

509: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
510: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
511: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;
514: END IF;
515:
516: l_retcode := FND_API.G_TRUE;
517: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);

Line 516: l_retcode := FND_API.G_TRUE;

512: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
513: return FND_API.G_FALSE;
514: END IF;
515:
516: l_retcode := FND_API.G_TRUE;
517: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);
518: FETCH c_isdeferred INTO l_user_name;
519: IF c_isdeferred%NOTFOUND THEN
520: l_retcode := FND_API.G_FALSE;

Line 520: l_retcode := FND_API.G_FALSE;

516: l_retcode := FND_API.G_TRUE;
517: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);
518: FETCH c_isdeferred INTO l_user_name;
519: IF c_isdeferred%NOTFOUND THEN
520: l_retcode := FND_API.G_FALSE;
521: END IF;
522: CLOSE c_isdeferred;
523: IF(asg_helper.check_is_log_enabled(g_stmt_level))
524: THEN

Line 542: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

538: x_return_status OUT NOCOPY VARCHAR2)
539: IS
540: BEGIN
541:
542: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
543: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: return;
546: END IF;

Line 543: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

539: IS
540: BEGIN
541:
542: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
543: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: return;
546: END IF;
547:

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: BEGIN
541:
542: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
543: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: return;
546: END IF;
547:
548: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 548: x_return_status := FND_API.G_RET_STS_SUCCESS;

544: x_return_status := FND_API.G_RET_STS_ERROR;
545: return;
546: END IF;
547:
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549: UPDATE asg_users_inqinfo
550: SET deferred = 'D'
551: WHERE device_user_name = p_user_name AND
552: tranid = p_tranid;

Line 576: x_return_status := FND_API.G_RET_STS_SUCCESS;

572: FROM asg_deferred_traninfo
573: WHERE device_user_name = p_user_name AND
574: deferred_tran_id = p_tranid;
575: BEGIN
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577: delete_deferred_row(p_user_name, p_tranid, p_pubitem,
578: p_sequence, x_return_status);
579:
580: OPEN c_deferred_discarded(p_user_name, p_tranid);

Line 632: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

628: WHERE device_user_name = p_user_name AND
629: deferred_tran_id = p_tranid AND
630: status <> 0;
631: BEGIN
632: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
633: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: return;
636: END IF;

Line 633: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

629: deferred_tran_id = p_tranid AND
630: status <> 0;
631: BEGIN
632: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
633: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: return;
636: END IF;
637:

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: status <> 0;
631: BEGIN
632: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
633: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: return;
636: END IF;
637:
638: -- Check if this transaction is deferred

Line 640: IF l_def_trans = FND_API.G_FALSE THEN

636: END IF;
637:
638: -- Check if this transaction is deferred
639: l_def_trans := is_deferred(p_user_name, p_tranid);
640: IF l_def_trans = FND_API.G_FALSE THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: return;
643: END IF;
644:

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637:
638: -- Check if this transaction is deferred
639: l_def_trans := is_deferred(p_user_name, p_tranid);
640: IF l_def_trans = FND_API.G_FALSE THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: return;
643: END IF;
644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

641: x_return_status := FND_API.G_RET_STS_ERROR;
642: return;
643: END IF;
644:
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646: -- Get all the publications that have deferred pub items
647: counter :=1;
648: FOR cpw in c_pub_wrapper(p_user_name, p_tranid) LOOP
649: l_pubhandlers_tbl(counter) := cpw.wrapper_name;

Line 671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

667: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
668: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
669: l_pubitems_tbl, l_return_status);
670: -- Check if there is any data for this publication
671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
672: (l_pubitems_tbl.count >0) THEN
673: IF(asg_helper.check_is_log_enabled(g_stmt_level))
674: THEN
675: asg_helper.log('reapply_transaction: Calling handler package',

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: asg_helper.log('reapply_transaction: Exception in ' ||
705: 'wrapper call. Check if valid wrapper exists',
706: 'asg_defer',g_err_level);
707: END IF;
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
710: l_orig_app_id);
711: return;
712: END;

Line 752: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

748: l_curr_pubitem VARCHAR2(30);
749: l_pubitems_tbl asg_apply.vc2_tbl_type;
750: l_return_status VARCHAR2(1);
751: BEGIN
752: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
753: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: return;
756: END IF;

Line 753: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

749: l_pubitems_tbl asg_apply.vc2_tbl_type;
750: l_return_status VARCHAR2(1);
751: BEGIN
752: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
753: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: return;
756: END IF;
757:

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750: l_return_status VARCHAR2(1);
751: BEGIN
752: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
753: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: return;
756: END IF;
757:
758: -- Check if this transaction is deferred

Line 760: IF l_def_trans = FND_API.G_FALSE THEN

756: END IF;
757:
758: -- Check if this transaction is deferred
759: l_def_trans := is_deferred(p_user_name, p_tranid);
760: IF l_def_trans = FND_API.G_FALSE THEN
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: return;
763: END IF;
764: IF(asg_helper.check_is_log_enabled(g_stmt_level))

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757:
758: -- Check if this transaction is deferred
759: l_def_trans := is_deferred(p_user_name, p_tranid);
760: IF l_def_trans = FND_API.G_FALSE THEN
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: return;
763: END IF;
764: IF(asg_helper.check_is_log_enabled(g_stmt_level))
765: THEN

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

766: asg_helper.log('purge_transaction: Purging user: ' || p_user_name ||
767: ' transaction: ' || p_tranid,
768: 'asg_defer',g_stmt_level);
769: END IF;
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: asg_apply.get_all_pub_items(p_user_name, p_tranid,
772: l_pubitems_tbl, l_return_status);
773: -- Check if there is any data for this publication
774: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

Line 774: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: asg_apply.get_all_pub_items(p_user_name, p_tranid,
772: l_pubitems_tbl, l_return_status);
773: -- Check if there is any data for this publication
774: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
775: (l_pubitems_tbl.count >0) THEN
776: FOR curr_index in 1..l_pubitems_tbl.count LOOP
777: l_curr_pubitem := l_pubitems_tbl(curr_index);
778: IF(asg_helper.check_is_log_enabled(g_stmt_level))