DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on FND_SEQNUM

Line 1879: l_status := FND_SEQNUM.GET_SEQ_VAL(

1875:
1876: l_doc_sequence_value := null;
1877: l_doc_sequence_id := null;
1878:
1879: l_status := FND_SEQNUM.GET_SEQ_VAL(
1880: 222,
1881: p_name,
1882: p_set_of_books_id,
1883: 'A',

Line 1890: IF (l_status = FND_SEQNUM.SEQSUCC)

1886: l_doc_sequence_id,
1887: 'Y',
1888: 'Y');
1889:
1890: IF (l_status = FND_SEQNUM.SEQSUCC)
1891: THEN
1892:
1893: IF (l_doc_sequence_value is not NULL)
1894: THEN

Line 1910: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

1906: G_ERROR := 'Y';
1907:
1908: END IF;
1909:
1910: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
1911:
1912: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
1913: G_ERROR := 'Y';
1914:

Line 2182: l_status := FND_SEQNUM.GET_SEQ_VAL(

2178:
2179: l_doc_sequence_value := null;
2180: l_doc_sequence_id := null;
2181:
2182: l_status := FND_SEQNUM.GET_SEQ_VAL(
2183: 222,
2184: p_name,
2185: p_set_of_books_id,
2186: 'A',

Line 2193: IF (l_status = FND_SEQNUM.SEQSUCC)

2189: l_doc_sequence_id,
2190: 'Y',
2191: 'Y');
2192:
2193: IF (l_status = FND_SEQNUM.SEQSUCC)
2194: THEN
2195:
2196: IF (l_doc_sequence_value is not NULL)
2197: THEN

Line 2215: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

2211: G_ERROR := 'Y';
2212:
2213: END IF;
2214:
2215: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2216:
2217: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2218: G_ERROR := 'Y';
2219:

Line 2471: l_status := FND_SEQNUM.GET_SEQ_VAL(

2467:
2468: l_doc_sequence_value := null;
2469: l_doc_sequence_id := null;
2470:
2471: l_status := FND_SEQNUM.GET_SEQ_VAL(
2472: 222,
2473: p_name,
2474: p_set_of_books_id,
2475: 'A',

Line 2482: IF (l_status = FND_SEQNUM.SEQSUCC)

2478: l_doc_sequence_id,
2479: 'Y',
2480: 'Y');
2481:
2482: IF (l_status = FND_SEQNUM.SEQSUCC)
2483: THEN
2484:
2485: IF (l_doc_sequence_value is not NULL)
2486: THEN

Line 2504: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

2500: G_ERROR := 'Y';
2501:
2502: END IF;
2503:
2504: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2505:
2506: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2507: G_ERROR := 'Y';
2508:

Line 2760: l_status := FND_SEQNUM.GET_SEQ_VAL(

2756:
2757: l_doc_sequence_value := null;
2758: l_doc_sequence_id := null;
2759:
2760: l_status := FND_SEQNUM.GET_SEQ_VAL(
2761: 222,
2762: p_name,
2763: p_set_of_books_id,
2764: 'A',

Line 2771: IF (l_status = FND_SEQNUM.SEQSUCC)

2767: l_doc_sequence_id,
2768: 'Y',
2769: 'Y');
2770:
2771: IF (l_status = FND_SEQNUM.SEQSUCC)
2772: THEN
2773:
2774: IF (l_doc_sequence_value is not NULL)
2775: THEN

Line 2793: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

2789: arp_standard.debug ( 'ERROR!!!!');
2790:
2791: END IF;
2792:
2793: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2794:
2795: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2796:
2797: ELSE

Line 3054: l_status := FND_SEQNUM.GET_SEQ_VAL(

3050:
3051: l_doc_sequence_value := null;
3052: l_doc_sequence_id := null;
3053:
3054: l_status := FND_SEQNUM.GET_SEQ_VAL(
3055: 222,
3056: p_name,
3057: p_set_of_books_id,
3058: 'A',

Line 3065: IF (l_status = FND_SEQNUM.SEQSUCC)

3061: l_doc_sequence_id,
3062: 'Y',
3063: 'Y');
3064:
3065: IF (l_status = FND_SEQNUM.SEQSUCC)
3066: THEN
3067:
3068: IF (l_doc_sequence_value is not NULL)
3069: THEN

Line 3086: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

3082: arp_standard.debug ( 'ERROR!!!!');
3083:
3084: END IF;
3085:
3086: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3087:
3088: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3089: ELSE
3090: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');

Line 3342: l_status := FND_SEQNUM.GET_SEQ_VAL(

3338:
3339: l_doc_sequence_value := null;
3340: l_doc_sequence_id := null;
3341:
3342: l_status := FND_SEQNUM.GET_SEQ_VAL(
3343: 222,
3344: p_name,
3345: p_set_of_books_id,
3346: 'A',

Line 3353: IF (l_status = FND_SEQNUM.SEQSUCC)

3349: l_doc_sequence_id,
3350: 'Y',
3351: 'Y');
3352:
3353: IF (l_status = FND_SEQNUM.SEQSUCC)
3354: THEN
3355:
3356: IF (l_doc_sequence_value is not NULL)
3357: THEN

Line 3373: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

3369: arp_standard.debug ( 'ERROR!!!!');
3370:
3371: END IF;
3372:
3373: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3374:
3375: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3376:
3377:

Line 3608: l_status := FND_SEQNUM.GET_SEQ_VAL(

3604:
3605: l_doc_sequence_value := null;
3606: l_doc_sequence_id := null;
3607:
3608: l_status := FND_SEQNUM.GET_SEQ_VAL(
3609: 222,
3610: p_name,
3611: p_set_of_books_id,
3612: 'A',

Line 3619: IF (l_status = FND_SEQNUM.SEQSUCC)

3615: l_doc_sequence_id,
3616: 'Y',
3617: 'Y');
3618:
3619: IF (l_status = FND_SEQNUM.SEQSUCC)
3620: THEN
3621:
3622: IF (l_doc_sequence_value is not NULL)
3623: THEN

Line 3639: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

3635: arp_standard.debug ( 'ERROR!!!!');
3636:
3637: END IF;
3638:
3639: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3640:
3641: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3642:
3643:

Line 3873: l_status := FND_SEQNUM.GET_SEQ_VAL(

3869:
3870: l_doc_sequence_value := null;
3871: l_doc_sequence_id := null;
3872:
3873: l_status := FND_SEQNUM.GET_SEQ_VAL(
3874: 222,
3875: p_name,
3876: p_set_of_books_id,
3877: 'A',

Line 3884: IF (l_status = FND_SEQNUM.SEQSUCC)

3880: l_doc_sequence_id,
3881: 'Y',
3882: 'Y');
3883:
3884: IF (l_status = FND_SEQNUM.SEQSUCC)
3885: THEN
3886:
3887: IF (l_doc_sequence_value is not NULL)
3888: THEN

Line 3904: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN

3900: arp_standard.debug ( 'ERROR!!!!');
3901:
3902: END IF;
3903:
3904: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3905:
3906: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3907:
3908: